Excel ABS Function

The ‘ABS’ function in Excel will return the absolute value of any input number.

This formula works by returning the delta between the input number and zero. As (10) and 10 are both 10 away from zero, the formula would return 10 against both values. As a result, the ABS function has no effect on positive numbers, whilst negative numbers are converted to positives.

This can be useful when working with large datasets where you want to ensure no negatives have been incorrectly included.




Number – input number which you want to get the absolute value of.

Function category

Maths and trigonometry


The ABS function will return a numeric value.

Download Excel file

 Example of ABS function

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.