menu

Supported Excel Functions

Logical functions

Syntax

logical_testRequired.
The condition you want to test.

value_if_true Required.
The value, which will be returned if the result of the logical_test is true.

value_if_false Optional.
The value, which will be returned if the result of the logical_test is false.

Checks whether a condition is met, and returns one value if true and another value if false. If the value_if_false is not supplied and the logical_test is false, IF acts as a simple no-opeartion function and doesn't influence its formula value.

The Adaptive Calculation Engine supports the nested IF functions.

This is the Adaptive Calculation Engine implementation of the Excel IF function.

Syntax

IFERROR(value, value_if_error)

value Required.
The argument that is checked for an error.

value_if_error Required.
The value to return if the formula evaluates to an error.

Traps and handles errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

The following error types are evaluated: #N/A, #VALUE!, #DIV/0!, #NUM!, #NAME?
and #ERROR!.

This is the Adaptive Calculation Engine implementation of the Excel IFERROR function.

Syntax

IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

logical_test1 Required.
The condition that evaluates to true or false.

value_if_true1 Required.
Result to be returned if logical_test1 evaluates to true.

logical_test2,... Optional.
Condition that evaluates to true or false.

value_if_true2,... Required.
Result to be returned if llogical_test2,... evaluates to true.

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first true condition. If a logical_test argument is evaluated and resolves to a value other than true or false, this function returns a #VALUE! error. The Adaptive Calculation Engine supports the unlimited number of conditions. If no true conditions are found, this function doesn't return any value, so its formula field retains its value.

The following error types are evaluated: #N/A, #VALUE!, #DIV/0!, #NUM!, #NAME?,
and #ERROR!.

This is the Adaptive Calculation Engine implementation of the Excel IFS function.

Syntax

SWITCH(expression, value1, result1, [default or value2, result2],...[default])

expression Required.
It will be compared against value1, value2,...

value1, value2,... A value that will be compared against expression.

result1, result2,... A value to be returned when the corresponding valueN argument matches expression.

value_if_true2,... Required.
Result to be returned if llogical_test2,... evaluates to true.

default Optional. Default is the value to return in case no matches are found in the valueN expressions. Default must be the final argument in the function.

The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. The Adaptive Calculation Engine supports the unlimited number of value / result pairs. If no matches are found and no default value is supplied conditions are found, this function doesn't return any value, so its formula field retains its value.

This is the Adaptive Calculation Engine implementation of the Excel SWITCH function.

Syntax

OR(condition1, [condition2], ...)

condition1  Required.
The first condition to test whether it is true or false.

condition2,...   Optional.
Additional conditions to test whether they are true or false.

Returns true if any of the conditions are true. Otherwise, it returns false.

This is the Adaptive Calculation Engine implementation of the Excel OR function.

Syntax

AND(condition1, [condition2], ...)

condition1  Required.
The first condition to test whether it is true or false.

condition2,... Optional.
Additional conditions to test whether they are true or false.

Returns true if all conditions are true. It returns false if any of the conditions are false.

This is the Adaptive Calculation Engine implementation of the Excel AND function.

Syntax

NOT(logical_value)

logical_value   Required.
An expression that evaluates to true or false. If used with an expression of true, then false is returned. If used with an expression of false, then true is returned.

Returns the reversed logical value.

This is the Adaptive Calculation Engine implementation of the Excel NOT function.