IfThen, If
IfThen is a conditional function that returns a value when the condition equals True, and another value when the condition equals False.
The function 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. See the following table for a list of valid conditional operators.
-
TrueParameter and FalseParameter are any valid expression that are evaluated based on the outcome of the condition.
The following table describes the conditional operators that are fully supported. Alternate syntax is listed wherever it is supported by a conditional operator.
Table B-5 Conditional Operators
Conditional Operator | Syntax | Logic |
---|---|---|
Equal To |
expression |
Tests whether the left expression is equal to the right expression. Note: The routine that evaluates the condition does not consider any rounding. If rounding is required, use the Round function. Example:
|
Greater Than |
expression |
Tests whether the left expression is greater than the right expression. Example:
|
Greater Than or Equal To |
expression |
Tests whether the left expression is greater than or equal to the right expression. Note: The correct syntax is ">=". The syntax "=>" is not supported. Example:
|
Less Than |
expression |
Tests whether the left expression is less than the right expression. Example:
|
Less Than or Equal To |
expression |
Tests whether the left expression is less than or equal to the right expression. Note: The correct syntax is "<=". The syntax "=<" is not supported. Example:
Returns true |
Not Equal To |
expression expression |
Tests whether the left expression is not equal to the right expression. Note: The routine that evaluates the condition does not consider any rounding. If rounding is required, use the Round function. Example:
|
IsMissing |
|
Tests whether the reference contains a #MISSING result. Note: If the reference is an expanded row or column, then all resulting cells must be #MISSING in order for the condition to be true. Example:
|
IsError |
|
Tests whether the reference contains an #ERROR result. Note: If the reference is an expanded row or column, all resulting cells must be #ERROR in order for the condition to be true. Only formula rows and columns can result in #ERROR. Example:
|
IsNonNumeric |
|
Tests whether the reference contains a #MISSING or #ERROR results. Note: If the reference is an expanded row or column, all resulting cells must be #MISSING and/or #ERROR in order for the condition to be true. Example:
|
Parenthesis |
|
Used to group a condition. Used mostly for visual clarity. Example:
|
Table B-6 Conditional Operators
Complex Conditions | Syntax | Logic |
---|---|---|
And |
|
Complex condition used to compare two conditions. Returns true if all conditions result in true. Example:
|
Not |
|
Used to negate the result by reversing the result of the condition. Example:
|
Or |
|
Complex condition used to compare two conditions. Returns true if any of the conditions result in true. Example:
|