IF(X, T, F)

 

Description

This function returns the value of T if X evaluates to non-zero, or F if X evaluates to zero.  This function is identical to X? T: F, which is more efficient to evaluate.

 

Parameters

 

X

A numeric value.

 

T

A value.

 

F

A value.

 

Examples

 

IF (A1, 7, 9) = 7

Where A1 = 1.

 

IF (B17==0, 0, "non-zero") = "non-zero"

Where B17 = 1.