[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
SIGN ( x )
Description: Determines the sign of x.
Arguments:
|
Name |
Type |
Description |
|
number |
The number whose sign is to be determined. |
Return Type and Value: number – 1 if x is positive, 0 if x is 0, and -1 if x is negative.
[Example:
SIGN(10.5) results in 1
SIGN(0) results in 0
SIGN(-5.4) results in -1
end example]