formulas in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know if anyone can help!! I need to know if it is possible
in excel to to the following:

I have separate cells G E B. These cells then refer to a key for G E B etc.
alongside these letters in separate cells I have a figure ie £10.00.

But each time or every month these cells change the order in which they are
in. So I am looking to ask in the total cell box if the letter in cell A3 is
equal to G then go to H1 for the answer. If the letter in cell A3 is equal
to E then go to H2 etc. Have this for A to I. It is difficult to explain.

But if anyone can help or suggest where I can get help from.
 
=IF(A3="G",H1,IF(A3="E",H2,H3))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top