SIGN function
The SIGN function is one of the math and trigonometry functions. It is used to return the sign of a number. If the number is positive, the function returns 1. If the number is negative, the function returns -1. If the number is 0, the function returns 0.
Syntax
SIGN(number)
The SIGN function has the following argument:
| Argument | Description |
|---|---|
| number | A numeric value for which you want to get the sign. |
Notes
How to apply the SIGN function.
Examples
The required argument is A1, where A1 is 12. The number is positive, so the function returns 1.
If we change the A1 value from 12 to -12, the function returns -1:
Host ONLYOFFICE Docs on your own server or use it in the cloud
Article with the tag:
Browse all tags