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

[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!

 

[Niek Otten]

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?

 

[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

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