View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed
 
Posts: n/a
Default How can I put a reference to a cell into a formula?

Here's what I've got - the formulas are named AA,BB,CC,&DD, respectively, and
"(numbers*2)" is in A1.

Basically I want to be able to use the respective values in the "numbers"
column in the formulas, but I don't know how to arrange or set up the
formulas to include them.

formulas text numbers IF functions
Desired Result
(numbers*2) A 1 IF(B1="A",AA,IF(B1="B",BB",IF(B1="C",CC,DD))) 2
(numbers*3) B 2 IF(B1="A",AA,IF(B1="B",BB",IF(B1="C",CC,DD))) 6
(numbers*4) C 3 IF(B1="A",AA,IF(B1="B",BB",IF(B1="C",CC,DD))) 12
(numbers*5) D 4 IF(B1="A",AA,IF(B1="B",BB",IF(B1="C",CC,DD))) 20

Any help would be greatly appreciated - thanks!