OK, first post put me on the right track. I have on that works, now i need
to it work for all 5 numbers.

Thanks

"R..VENKATARAMAN" wrote:

what you require is "nested if". see help "if" and examples therein. you
have to enter the formula in the cell 2.


"snwooz" wrote in message
...
I have a set group of numbers associated with letters. I need to know what
formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter
show up inj another are.

Thanks:)