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

KEVB - Jul 26, 2017 at 03:38 PM - Latest reply: ac3mark 9571 Posts Monday June 3, 2013Registration dateModeratorStatus June 19, 2018 Last seen
- 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

See more 

Your reply

1 reply

Best answer
ac3mark 9571 Posts Monday June 3, 2013Registration dateModeratorStatus June 19, 2018 Last seen - Jul 26, 2017 at 04:49 PM
1
Thank you
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!

Thank you, ac3mark 1

Something to say? Add comment

CCM has helped 1869 users this month

Respond to ac3mark