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

Report
-
ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
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

1 reply

Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,684
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 4151 users have said thank you to us this month