MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

Posted by Richard Staley on April 10, 2001 4:55 PM

Found the answer!

Posted by anon on April 10, 2001 5:02 PM

=IF(A1>4,"More than 4?",IF(A1=4,"E",IF(A1>2.9,"EE",IF(A1>1.9,"ME",IF(A1>0.9,"IN","U")))))