Multiple Formula in one cell.

[Shannon671]

I need a formula that will look at multiple figures but will assign a letter for a particular number. I'd rather not use a macro.

my example, Less than 50% will have the letter 'E' assigned to it.
Then it needs to look for numbers between 50% and 65% will be assigned a 'D'.
Then it needs to look for numbers between 65% and 75% will be assigned a 'C'.
Then it needs to look for numbers between 75% and 85% will be assigned a 'B'
and anything greater than 85% will have a 'A' assigned to it.

It needs to look at all of this and when it has the figure it needs to assign the letter in another cell. it only has to look in one cell for the figure.

I have the IF formula for them individually eg =IF(A1<50%, "e", "") but that only assigns either a number or blank.

Any help would be greatly appreciated.


Thank you

[contaminated]

Hi and welcome to the forum
Try this

=LOOKUP(A1,{0;0.5;0.65;0.75;0.85},{"E";"D";"C";"B";"A"})

[Shannon671]

Thank you very much, worked perfectly.