Formula Issue

[abacon1960]

I am looking to perform the following but cannot figure out what to do with the middle IF statement?

=IF(A1<1,"SATISFACTORY",IF(A1>1,A1<1.25,"CAUTION",IF(A1>1.25,"HIGH ALERT","")

I know there is a simple solution, hopefully.

Thanks.

 

[Joe4]

When you have more than one condition to check, you can use AND (if multiple conditions MUST be met) or OR (if just any one of multiple conditions must be met).
So your middle IF code would look like:

...IF(AND(A1 > 1,A1 < 1.25),...

However, this is not necessary if you understand how nested IF statements work. A nested IF statement will STOP at the point where it finds a TRUE, and not evaluate anything after it.
So if you have a situation where you are checking increasing or decreasing amount, just start at one end and work your way up (or down).
So, you could simply write your formula like this:

[COLOR=#333333]=IF(A1<1,"SATISFACTORY",IF(A1<1.25,"CAUTION","HIGH ALERT"))[/COLOR]