| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with calculation based on 3 scenerio??
Hello,
What is the formula or calcalution to calculate (different formula) based on three scenerio? I thought about IF function, but that only work for two scenerio. Anyway, here is an example of what I need for the formula to calculate: Scenerio 1: Task = 1, Machine = 2, use formula calculation A Scenerio 2: Task = 2, Machine = 1, use formula calculation B Scenerio 3: Task = 1, Machine = 1, use formula calculation C Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation based on Y or N Values | Excel Discussion (Misc queries) | |||
| Sum calculation based on condition | Excel Worksheet Functions | |||
| Calculation based on 2 cols | Excel Discussion (Misc queries) | |||
| Calculation based on date | Excel Discussion (Misc queries) | |||
| Solver? Scenerio? Goal Seeker? | Excel Discussion (Misc queries) | |||
Threaded Mode
