Notes on Conditions
-
Expression—Any valid formula expression. The expression can be any combination of a constant (integer or real number), a reference, or another function.
-
Reference—Any valid reference; thus the IFNN reference property can be used as part of the reference.
-
Condition—Any valid condition applied to the complex conditions And, Not, and Or. Those operators can have embedded conditions.
Note:
And, Not, and Or operators require surrounding parentheses.
-
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.