Formulas calculation (if statement)

[Kal_Lam]

@TushaarKOBO, maybe this post discussed previously should help you understand and use the if-statement properly:

When is if() function used in formbuilding?

You could use the if() statement when you have to assign a certain value/expression for a certain condition else use another value/expression. Thus, the if statements require three arguments: a condition; the result if the condition is true; and the result if the condition is false. The syntax would be as follows: if(condtion,value,value) if(condtion,expression,expression) if(condtion,value,expression) if(condtion,expression,value) You could learn more about the if-statement by following o…