ABS function. Get absolute value. SIGN function. Get Signs.(Microsoft Excel)

Japanese version.

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.

How it works

NumberRequiredTarget number.

The result of the SIGN function is as follows:

1 or more.1
-1 or less.-1

Example Results


If a cell range is specified as an Argument, it will be Spill.



Microsoft Excel Functions Math & Trig