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:
You could learn more about the
if-statement by following our community post that has been discussed previously.