Have a value of numbers equal a letter value

[chompz]

Hi there,

I'm trying to create a formula to get Excel 2003 to do basically this:

if the value of column i = 0 to 5 the letter value shown is L
if the value of column i - 6 to 11 the letter value shown is M
if the value of column i - 12 to 17 the letter value shown is H

basically i have columns F, G, H that have numerical values and a formula that adds those together to come up with a number 0 to 17. I want that number, based on the idea above, to visualize a letter instead of the number

for example:

F = 4
G = 4
H = 7
I = 15 so it would show up as H in the cell.

something like this:
=SUM(F12:H12) ----- THEN add the other part where if the answer is 0-5 it displays L, etc.

Thanks for any help and input!

Stephanie

[DonkeyOte]

A LOOKUP should suffice

=LOOKUP(SUM(F12:H12),{0,6,12},{"L","M","H"})

[chompz]

Thank you!! That worked wonderfully!!!!!!! :D