Documentation/How Tos/Calc: SIGN function

From Apache OpenOffice Wiki
Jump to: navigation, search


SIGN

Returns the sign of a number:- 1 if the number is positive, -1 if negative and 0 if zero.

Syntax:

SIGN(number)

number is the number whose sign is to be determined.

Example:

SIGN(3.4)

returns 1.

SIGN(-4.5)

returns -1.

SIGN(0)

returns 0.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SIGN_function&oldid=243272"
Views
Personal tools
Navigation
Print/export
Tools