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

Syntax:

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

Description:

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 is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Example:

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

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

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

See also:

IF