View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam Cam is offline
external usenet poster
 
Posts: 165
Default 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