ABS function

This article describes the formula syntax and usage of the ABS function in Microsoft Excel.

Description

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax

ABS(number)

The ABS function syntax has the following arguments:

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

Example

Copy the table below, and paste into cell A1 in Excel. You may need to select any cells that contain formulas and press F2 and then Enter to make the formulas work. You may also want to make the columns wider to make your worksheet easier to read.

Data

-4

Formula

Description

Result

=ABS(2)

Absolute value of 2

2

=ABS(-2)

Absolute value of -2

2

=ABS(A2)

Absolute value of -4

4

Applies To: Excel 2010, Excel Starter, Excel 2013, Excel Online, Excel 2016 for Mac, Excel for Mac 2011, Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language