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

Ask a question KEVB - Last answered on Jul 26, 2017 at 04:49 PM by ac3mark

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

plus moins
The If syntax is as follows:

You can nets IF statments as in:

I hope this helps you out!

Was this answer helpful?  
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!