IF

The IF function returns a value depending on whether the condition that is being evaluated is TRUE or FALSE.

Syntax

if( logical_test, value_if_true, value_if_false )

Arguments

logical_test – The condition to be evaluated

value_if_true – The value to be returned if the condition is met

value_if_false – The value to be returned if the condition is not met

Return value

Either value_if_true or value_if_false.

Example

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

The above formula returns AC-PY/PY if PY is greater than 0 otherwise, it returns 0.

Excel equivalent

IF