"Ed" wrote:

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,D D*B1)))
and copied this formula down to produce the results you want.


Regards
Peter