How To Use Excel ABS Function

How To Use Excel ABS Function2017-11-21T09:43:07+00:00

ABS function returns an absolute number. In simple words, it returns a number after removing its sign.

Syntax

ABS(number)

  1. number A number or value to get a positive number of.

Examples

In the below example, to get positive numbers we have used ABS. It has just removed the negative sign from the numbers.

use excel abs function to get absolute value

And here we have used ABS to get absolute values against the change in the interest rate.

excel abs function to get absolute or positive number

Sample File

Remember

  1. You can also use this absolute function as an array function.
  2. You can also put the number in the function to get the positive number.
  3. If specify a number which is not an integer, it will return #VALUE!.

>