Using multiple IF statements in one command

[Woozy39]

<o12,if(s17><o$12,if(s17><o<o<o$12,if(s17>

I am attempting to enter a "Yes" if the cell matches all three criteria and a "-" if it fails.

<o$12,if(s17>=IF(O17<O$12, IF(S17>S$12, IF(W17>W$12," Yes ","-")))

- I get a "Yes" if all three criteria are met, but
- I'm getting a "FALSE" if two of the three criteria are not met
- The formula works if two of the three are met..."-"

What am I missing to get a "-" if all three of the criteria are not met?

Thanks in advance</o$12,if(s17></o<o<o$12,if(s17></o$12,if(s17></o12,if(s17>

 

[Joe4]

You can use AND to check all three conditions, i.e.

=IF(AND(condition1,condition2,condition3),"Yes","-")

 

[mrhstn]

Try like this

=IF((O17>O$12)*(S17>S$12)*(W17>W$12)," Yes ","-")

 

[AlanY]

try

=if(and(O17>O$12,S17>S$12,W17>W$12)," Yes ","-")

 

[Woozy39]

Perfect! Thank you.