Category
General-Purpose Functions
Description
Conditional choice function
Syntax
IF(condition, if_true, if_false)
Parameters
condition - formula specifying a true/false condition (non-zero means true)
if_true - formula to evaluate and return the result of if condition is true
if_false - formula to evaluate and return the result of if condition is false
Notes
Only one the two formulas gets evaluated, depending on the condition. The function returns the result of evaluating the selected formula.
This function can also be referred to as "IIF" if you prefer.
|