IF
The IF function checks a condition and returns one value when it is TRUE; otherwise, it returns a second value.
Syntax
IF( logical_test, value_if_true, value_if_false )Arguments
logical_test – Any value or expression that can be evaluated as TRUE or FALSE
value_if_true – The value to be returned if the logical test is TRUE.
value_if_false – The value to be returned if the logical test is FALSE.
Return value
The return value can be either value_if_true or value_if_false.
Example
IF(PY > 0 , (AC-PY)/PY, 0 )The above formula returns (AC-PY)/PY if the PY value is greater than 0; otherwise, it returns 0.
Excel equivalent
Last updated