excel formula
snwooz wrote:
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:)
You can use a VLOOKUP formula; you can build a Vlookup table and use the
formula, or just incapsulate the table into the formula.
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|