Manuals/calci/SIGN
Syntax
Examples
''''''' ''''
Description
' SIGN '
1. Consider n = 10 then
=SIGN (10) gives 1 (1 represents a positive number)
2. Consider n = -3.5 then
=SIGN (-3.5) gives 0 (-1 represents a negative number)
A SIGN function determines the sign of a number and gives
1 if the number is positive
0 if the number is 0
1 if the number is negative.
SIGN(n)
n is any real number.
Column1 | Column2 | Column3 | Column4 | |||
Row1 | 10 | 1 | ||||
Row2 | -3.5 | -1 | ||||
Row3 | ||||||
Row4 | ||||||
Row6 |