Multiple IF statements required?
Posted by Richard Staley on April 10, 2001 4:47 PM
I have a spreadsheet that I would like to use a value in a cell, we will call "A1". Based on the value of this cell, I need the following statement printed onto the spreadsheet:
Exceptional 4
Exceeds Expectations 3 3.9
Meets Expectations 2 2.9
Improvement Needed 1 1.9
Unsatisfactory 0 0.9
So if cell "A1" = 3.5 the cell would print "Exceeds Expectations" and so on....
Is there an easy way to do this for all these values?