HELP - I need some assistance in Writing an IF formula

[LVGRAY]

Hi People,

I am trying to write an IF formula for an Excel document I'm working on and running into some difficulties.

Basically, I have a column of numbers that in the next cell I want it translate to a Letter equivalent, eg if the number is between 3 and 4 ie 3, 3.25, 3.5, 3.75 or 4 then I want the next cell to say M. In addition I want it to translate any number between 2 - 2.75 = D, 0.75 - 1.75 = E, 0 - 0.5 = N

Can anyone help me with this?

Much appreciated.
Louise

[JohnTopley]

Try

=LOOKUP(B1,{0,0.75,2,3},{"N","E","O","M"})

[José Augusto]

Hi
Try this

Please Login or Register  to view this content.

Formula gives you a empty string for missing values.

[LVGRAY]

This worked a dream! Thank you Jose.

[José Augusto]

You are welcomed.