Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

ABS function: Description, Usage, Syntax, Examples and Explanation

What is ABS function in Excel?

ABS function is one of the Math and Trig functions in Microsoft Excel that returns the absolute value of a number. The absolute value of a number is the number without its sign.

Worked Example:   Find closest match in Excel

Syntax of ABS function


The ABS function syntax has the following arguments:

  • Number: The real number of which you want the absolute value.

Example of ABS function

Steps to follow:

Worked Example:   Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

Worked Example:   Change negative numbers to positive in Excel

You can adjust the column widths to see all the data, if need be.

Formula Description Result
=ABS(2) Absolute value of 2 2
=ABS(-2) Absolute value of -2 2
=ABS(A2) Absolute value of -4 4

Leave a Reply

Your email address will not be published. Required fields are marked *