To report a found bug,
please select the text with the bug and click Report a Bug
or CTRL+ENTER.
Help
system 10.11 LTS of 15/07/2026,
©
FORESIGHT
Sign(Value)
Value. Value, sign of which should be defined.
NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.
It determines a number sign.
It can return the following values:
1. The number is positive.
0. The number is equal to 0.
-1. The number is negative.
| Formula | Result | Description |
| =Sign(-9) | -1 | The sign of a negative number. |
| =Sign(B6) | 1 | The sign of a positive number from the B6 cell. The B6 cell contains the 5.64 number. |
See also:
Function Wizard │ Mathematical Functions