| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choosing a Formula Based on a Value
How would I choose between several different formulas in a cell based on a
variable in another cell? Simplified Example: Let's say I have three fields, field 'A' has a number, field 'B' is our variable and field 'C' either adds/subtracts or multiplies field 'A' by 5. How do we get the formula in 'C' to change based on the value in 'B'? Let's assume for the moment there are more than 7 different formulas so an IF/Then might be tricky. Is there anyway to do this without a macro? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choosing a date from a list based on two criteria | Excel Discussion (Misc queries) | |||
| Choosing data based on Match to several items | Excel Worksheet Functions | |||
| Choosing a formula to used based on a codition fulfilled | Excel Discussion (Misc queries) | |||
| VBA - Choosing rows based on a criteria | Excel Programming | |||
Threaded Mode
