IFThen, If
IfThen
is a conditional function that returns a value when the condition equals True, and another value when the condition equals False.
Syntax:
IfThen(Condition, TrueParameter, FalseParameter)
-
Condition is a logical expression that evaluates to true or false. Full conditional logic can be used as well as complex Boolean operators (And, Not, and Or). A condition can also test for #missing and #error values.
-
TrueParameter and FalseParameter are expressions that are evaluated based on the outcome of the condition.