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

Question

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

System Configuration: Windows / Chrome 59.0.3071.115

ac3mark · Answer

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!

True or False Value based on 3 difference cells' criteria

1 response

Similar discussions

Subscribe To Our Newsletter!