Excel ABS Function | Example + Sample File


The Excel ABS Function is listed under Microsoft Excel’s Maths Functions category. It returns a number after converting it into an absolute number. In simple words, converting a negative number into positive and unaffecting the positive number. In simple words, it returns a number without a sign.

How to use it

To learn how to use ABS function in Excel, you need to understand its syntax and arguments:




  • number: A number or value to get a positive number of.


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


To master the ABS function we need to try it out in an example, so make sure to check out the below one: In the below example, we have used ABS to convert negative values into positive ones.

It has just removed the negative sign from the numbers.

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

Sample File

Make sure to check out this Basic Excel Tutorial, this is a guide that will help you to get started with Excel, and after that, here we have a list of EXCEL‌ TIPS to make you an advanced Excel user in no time.

Related Functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

puneet one point one

Puneet is using Excel since his college days. He helped thousands of people to understand the power of spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.