IF
The IF function returns a value depending on whether the condition that is being evaluated is TRUE or FALSE.
Syntax
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
The above formula returns AC-PY/PY if PY is greater than 0 otherwise, it returns 0.
Excel equivalent
Last updated