<< Click to Display Table of Contents >> CHOICE (x>0, x=0, x<0?)

Syntax:

CHOICE(Number, IfGreater [, IfZero, IfLess])

Description:

This returns one of the following values:

IfGreater, if Number is greater than zero.

IfZero, if Number equals zero.

IfLess, if Number is less than zero.

The last two arguments are optional.

Compatibility notes:

This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

Example:

CHOICE(42, "Greater", "Zero", "Less") returns Greater

CHOICE(0, "Greater", "Zero", "Less") returns Zero

CHOICE(-42, "Greater", "Zero", "Less") returns Less

See also:

IF