ABS function. Get absolute value. SIGN function. Get Signs.(Microsoft Excel)
The ABS function can be used to get a number without a positive or negative sign.
The SIGN function can be used to determine whether a number is positive or negative.
Both of these functions are often used in combination with other functions rather than alone.
Contents
How it works
=ABS(Number)
=SIGN(Number)
| Name | Omission | Specify |
|---|---|---|
| Number | Required | Target number. |
The result of the SIGN function is as follows:
| Number | Result |
|---|---|
| 1 or more. | 1 |
| 0 | 0 |
| -1 or less. | -1 |
Example Results
Spill
If a cell range is specified as an Argument, it will be Spill.
---