True or False Value based on 3 difference cells' criteria [Solved/Closed]

Report
-
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
-
Hello,

I need a True or False (or Y/N) return if for example:

A1>=30 AND B1>=80 AND C1>=80

but I have been unable to get IFS to work with three different cells and criteria

2 replies

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1576
The If syntax is as follows:
=IF(logicTest,True,False)

You can nets IF statments as in:
=IF(logicTest,True,if(Logictest2,truth2,false))

I hope this helps you out!

1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5782 users have said thank you to us this month