When is if() function used in formbuilding?

When is if() function used in xls form?

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 our community post that has been discussed previously.