IF

The IF function returns one value if a condition is true and another value if it is false.

Syntax

IF( logical_test, value_if_true, value_if_false )

Arguments

• logical_test: The condition to evaluate.

• value_if_true: The value returned if the condition is true.

• value_if_false: The value returned if the condition is false.

Return value

Returns either value_if_true or value_if_false based on the result of the condition.

Example

IF(PY > 0, (AC - PY) / PY, 0)

Returns (AC - PY) / PY if PY is greater than 0; otherwise, returns 0.

Excel equivalent

IF