X? T: F

 

Description

This function returns the value of T if X evaluates to non-zero, or it returns F if X evaluates to zero.  This function is identical to IF(X,T,F).

 

Parameters

 

X

A numeric value.

 

T

A value.

 

F

A value.

 

Examples

 

A1? 7: 9 = 7

Where A1 = 1.

 

(B17==0)? 0: "non-zero" = "non-zero"

Where B17 = 1.