IF formula

Victoria Ganuelas

May I please ask assistance to help generate the following IF formula.  Depending on what number value is in column 1, I want the column 2 to it to return a certain value.

 

If in column 1 the value is >980 then return the value in Column 2 to "Excellent"

If in column 1 the value is >950 but less than 980 then return the value in Column 2 to "Good"

If in column 1 the value is >930 but less than 950 then return the value in Column 2 to "Average"

If in column 1 the value is <930 then return the value in Column 2 to "Poor"

Rob Hagan

Hi Victoria,

The approach is to always ask the least inclusive question first, so the way that you have written it is excellent. The code that you are looking for is:

=IF([Column2]1 > 980, "Excellent", IF([Column2]1 > 950, "Good", IF([Column2]1 > 930, "Average", "Poor")))

But your specification is silent on what to do when [Column2]1 contains exactly 930. I have assumed that you meant <=930 in your fourth condition and that is what I have implemented above.

Cheers,

Rob.