True or False Value based on 3 difference cells' criteria

Solved/Closed
KEVB - Jul 26, 2017 at 03:38 PM
 Blocked Profile - Jul 26, 2017 at 04:49 PM
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

Blocked Profile
Jul 26, 2017 at 04:49 PM
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