How can I put a reference to a cell into a formula?

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

Guest

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!
 
Not easy to see what you're trying to achieve.
The number of quotes in your formula is uneven, which doesn't seem right.
Without formulas, can you try and explain what you want to do?
 
Ed said:
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
Click to expand...
I created Range Names Insert, Range Name, define.
In the name box I typed AA and in the Refers to box I type =2, then I
clicked the Add button. I repeated this BB refers to 3 and so on.

A1 to A4 = A, B, C, D and B1 to b4 = 1, 2, 3, 4 in C1 I typed the formula
=IF(A1="A",AA*B1,IF(A1="B",BB*B1,IF(A1="C",CC*B1,DD*B1)))
and copied this formula down to produce the results you want.


Regards
Peter
 
Back
Top