True or False Value based on 3 difference cells' criteria

 Blocked Profile -

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

The If syntax is as follows:

You can nets IF statments as in:

I hope this helps you out!

Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month