IF

Syntax:

IF ( logical-value , [ value-if-true ] [ , [ value-if-false ] ] )

Description: Tests logical-value, and if it is TRUE, value-if-true is evaluated and returned; otherwise, value-if-false is evaluated and returned.

Arguments:

Name	Type	Description
logical-value	logical	The value to be tested.
value-if-true	any	The value returned if logical-value is `TRUE`. If logical-value is `TRUE` and value-if-true is omitted, this argument evaluates to 0. value-if-true can contain up to seven levels of nested `IF` function calls. value-if-true and value-if-false need not evaluate to results of the same type.
value-if-false	any	The value returned if logical-value is `FALSE`. If logical-value is `FALSE` and value-if-false and its preceding comma is omitted, this argument evaluates to `FALSE`. If logical-value is `FALSE` and value-if-false is omitted, but its preceding comma is present, this argument evaluates to 0. value-if-false can contain at least seven levels of nested `IF` function calls. value-if-true and value-if-false need not evaluate to results of the same type.

If any argument is an array, every element of that array shall be evaluated when that argument is evaluated.

Return Type and Value: any – value-if-true, if logical-value is TRUE; otherwise, value-if-false.

example:

IF(10>5,,"No") results in 0IF(10>5,,) results in 0IF(10>5,"Yes",20) results in YesIF(10<5,"Yes",20) results in 20]