True or False Value based on 3 difference cells' criteria

Solved/Closed
Report
-
 Blocked Profile -
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

1 reply


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