if

IF

Evaluates an expression and returns a defined value or text based the on the results.

Syntax

IF(qualifier,true-response,{false-response})

Arguments

qualifier The analysis expression to use. This can contain other functions and cell references.

true-response Value or cell reference to return if the qualifier is TRUE. If omitted, nothing is displayed.

false-response Value or cell reference to return if the qualifier is FALSE. If omitted, nothing is displayed.

Example

IF((SUM(A2..A5))<1000,"Running Low","OK")

This function displays the text "Running Low" if the sum of A2 through A5 is less than 1000, otherwise "OK" is displayed.

qualifier	The analysis expression to use. This can contain other functions and cell references.
true-response	Value or cell reference to return if the qualifier is TRUE. If omitted, nothing is displayed.
false-response	Value or cell reference to return if the qualifier is FALSE. If omitted, nothing is displayed.