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.