Formulas and Functions

Chapter 8 Numeric Functions 195
SIGN
The SIGN function returns 1 when the argument number is positive, –1 when it is
negative, and 0 when it is zero.
SIGN(num)
 num: A number. number is a number value.
Examples
=SIGN(2) returns 1.
=SIGN(0) returns 0.
=SIGN(-2) returns -1.
=SIGN(A4) returns -1, if cell A4 contains -2.
Related Topics
For related functions and additional information, see:
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
SQRT
The SQRT function returns the square root of a number.
SQRT(num)
 num: A number. number is a number value.
Examples
=SQRT(16) returns 4.
=SQRT(12.25) returns 3.5, the square root of 12.25.
Related Topics
For related functions and additional information, see:
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15