Material Quantity Calculation Nested If Statments Not Valid?

[elena_balionyte]

I am trying to solve an issue with material quantity calculation, I need to nest if statements, but I get an error saying Invalid formula (Message number 40303)

Here is the formula I am trying:

IF ([002,002]<3) THEN (IF ([002,003]<3) THEN (10) ELSE (30)) ELSE (20)

And this is the formula that doesn't throw errors:

IF ([002,002]<3) THEN (10) ELSE (20)

Adding other functions to the if statement doesn't throw errors, only nested if statements do, this works without errors:

IF ([002,002]<3) THEN (ROUND(1,8)) ELSE (20)

I have tried to look for documentation about this but was unsuccessful.

Could you please tell me if there is a way to have nested if loops in material quantity calculation?

[elena_balionyte · Accepted solution]

For the next person with this issue: you can't nest if statements in MQC.