If function?

[Guest]

I am trying to create a formula to do the following for a
rating spreadsheet:

95 and above = E
90-94 = S
below 90 = I
and some results will have NA.

I need the formula to return the E,S,I, or NA for these
numbers. How do I do this?

 

[Peo Sjoblom]

One way

=LOOKUP(A1,{0;90;95},{"E";"S";"I"})