ABS (Excel Function)


- 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.





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


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.


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.


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



  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.
Last Updated: April 27, 2023