Skip to main content

IFS

Returns the value corresponding to the first true condition. Evaluates conditions left-to-right and short-circuits.

CategoryLogical
SyntaxIFS(condition1, value1, [condition2, value2], ...)

Parameters

ParameterRequiredDescription
condition1RequiredThe first condition to evaluate.
value1RequiredThe value to return if condition1 is true.
condition2OptionalAdditional condition to evaluate if previous conditions are false.
value2OptionalThe value to return if condition2 is true.

Example

IFS(x > 90, "A", x > 80, "B", x > 70, "C")

Auto-generated from the EngCanvas function registry.