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