Quick Answer
ABS Function
ABS converts negative numbers to positive, leaving positive numbers unchanged.
✓ Excel✓ Google SheetsExcel All versions
Syntax
ABS
(number)
Parameters
| Parameter | Description | Required |
|---|---|---|
| number | The number for which you want the absolute value. | Required |
Basic Example
Get absolute value of a number
=ABS(-10)Result10
Converts -10 to its absolute value of 10.
Advanced Examples
Example 1: Calculate absolute differences
Data analysisFind the absolute difference between two values
=ABS(A1 - B1)Result: 5
Returns the positive difference regardless of which value is larger.
Example 2: Sum absolute values
Error calculationSum all absolute values in a range
=SUM(ABS(A1:A10))Result: 100
Converts all values to positive before summing.
How ABS Works
ABS removes the negative sign from negative numbers, returning their positive equivalent. Positive numbers and zero remain unchanged.
1
Select output cell
Choose where the result should appear.
2
Enter formula
Type =ABS(number).
3
Press Enter
The result shows the absolute value.
Important Notes & Limitations
ABS only works with numeric values.
For array operations, use ABS with array formulas or dynamic arrays.
Common Errors & Fixes
#VALUE!Non-numeric argumentFix: Ensure the argument is a number.
Download Practice File
ABS
absPractice ABS with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the ABS function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Frequently Asked Questions
Does ABS work with arrays?
In Excel 365 and Google Sheets, ABS works with arrays natively. In older versions, use array formulas (Ctrl+Shift+Enter).
What is ABS of zero?
ABS(0) = 0