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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with calculation based on 3 scenerio??
Well, you could use nested IF statements (if you have xl2003 or older, the
maximum functions you can 'nest' is 7). =IF(task=1,IF(machine=1,calculation C,IF(machine=2,calculation A,"Task=1, Machine<1 or 2")),IF(task=2,IF(machine=1,calculation B,"Task=2, Machine<1"),"Task<1 or 2")) -- ** John C ** "Cam" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with calculation based on 3 scenerio??
You can nest your IF functions.
Assuming Task is A1, Machine is B1 Example: =IF(AND(A1=1,B1=2),calculation A,IF(AND(A1=2,B1=2),calculation B,IF(AND(A1=1,B1=1),calculation C,"Did not meet defined critera"))) Note that this equation still needs you to put in the calculations you wanted to do, but hopefully it provides a clear example. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Cam" wrote: 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 |
Reply |
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) |