Expression can be any valid formula expression. The expression can be any combination of a constant (integer or real number), a reference, or another function.
Reference can be any valid reference; thus the IFNN reference property can be utilized as part of the reference.
Condition can be any valid condition applied to the complex conditions And, Not, and Or. Those operators can have embedded conditions.
And, Not, and Or operators require surrounding parentheses. See Complex Conditions for additional information. |
When any expression within the condition returns an #error or #missing value, the If function returns #missing or #error. This does not apply when you use the IsMissing, IsError, or IsNonNumeric conditions.