Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put a reference to a cell into a formula?
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? -- Kind regards, Niek Otten "Ed" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put a reference to a cell into a formula?
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
How do I use cell reference instead of name in a formula? | Excel Discussion (Misc queries) | |||
formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) |