| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Scenario in formula
I want a formula to evaluate cells according to a scenario. In other words,
a scenario identifier will be one of the parameters of a function, and cell arguments evaluated as if they contained the scenario's values. Can it be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scenario in formula
An example might be useful to enable a better understanding of what you
require. "hmm" wrote: I want a formula to evaluate cells according to a scenario. In other words, a scenario identifier will be one of the parameters of a function, and cell arguments evaluated as if they contained the scenario's values. Can it be done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scenario in formula
Example:
Suppose scenario A sets cell A1 to 1, and scenario B sets A1 to 2. In B1, I would like to show 2*A1, according to scenario A (2). In C1, I would like to show 2*A1 according to scenario B (4). "Toppers" wrote: An example might be useful to enable a better understanding of what you require. "hmm" wrote: I want a formula to evaluate cells according to a scenario. In other words, a scenario identifier will be one of the parameters of a function, and cell arguments evaluated as if they contained the scenario's values. Can it be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| scenario/what if ?? | New Users to Excel | |||
| need a formula for this scenario | Excel Worksheet Functions | |||
| Scenario? | Excel Worksheet Functions | |||
| Is it possible to have a formula for the following scenario please | Excel Worksheet Functions | |||
Linear Mode
