Thread: excel formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default 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