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
Last updated