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