ABS (Excel Function)

Last Updated: April 27, 2023
puneet-gogia-excel-champs

- Written by Puneet

ABS function is the part of Excel’s Maths Functions that can be used to convert any number into an absolute number. In simple words, converting a negative number into a positive and unaffecting the positive number (returns a number without a sign) in the result cell. You can refer to the cell or input value into function direct.

abs-function

Syntax

ABS(number)

Arguments

number: A number or value that you want to convert into an absolute number.

Example

In the example below, you have a few numbers in column A, and now, you need to use the ABS function to convert these numbers into absolute numbers.

numbers-data

All you need to do is to add the function in the first cell, refer to the cells with the first value, and after that, drag it down to the last cell with the value.

add-abs-function-in-cell

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

abs-to-get-absolute-value

Notes

  1. You can directly insert the number in the function.
  2. If you specify a number that is not an integer, it will return #VALUE!.
  3. You can also use the ABS as an array function.