# ABS formula generator

> Describe what you need and get a ABS formula for Excel and Google Sheets, run on real data before you copy it. Plus 8 tested ABS examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/abs · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

ABS returns a number without its sign, so -250 becomes 250 and 250 stays 250.

Describe the task at [ABS formula generator](https://spreadsheetpractice.com/tools/formula-generator/abs) and get a ABS formula for Excel and Google Sheets, tested on real data.

## Tested ABS examples

### Calculate percentage change with negative numbers

`=(C2-B2)/ABS(B2)`

Excel. Result on the sample sheet: 5 rows (D2:D6). [See it and try it](https://spreadsheetpractice.com/formulas/percentage-change-with-negative-numbers)

### Calculate percent error

`=ABS(B2-$F$1)/$F$1`

Excel. Result on the sample sheet: 5 rows (C2:C6). [See it and try it](https://spreadsheetpractice.com/formulas/calculate-percent-error)

### Make positive numbers negative

`=-ABS(B2)`

Excel. Result on the sample sheet: 5 rows (C2:C6). [See it and try it](https://spreadsheetpractice.com/formulas/make-positive-numbers-negative)

### Calculate the percentage difference between two numbers

`=ABS(B2-C2)/AVERAGE(B2,C2)`

Excel. Result on the sample sheet: 5 rows (D2:D6). [See it and try it](https://spreadsheetpractice.com/formulas/percentage-difference-between-two-numbers)

### Convert negative numbers to positive

`=ABS(B2)`

Excel. Result on the sample sheet: 5 rows (C2:C6). [See it and try it](https://spreadsheetpractice.com/formulas/convert-negative-numbers-to-positive)

### Show percentage change with up and down arrows

`=TEXT(C2/B2-1,"▲0.0%;▼0.0%;0.0%")`

Excel. Result on the sample sheet: 5 rows (D2:D6). [See it and try it](https://spreadsheetpractice.com/formulas/show-percentage-change-with-arrows)

### Sum absolute values

`=SUMPRODUCT(ABS(B2:B8))`

Excel. Result on the sample sheet: 100. [See it and try it](https://spreadsheetpractice.com/formulas/sum-absolute-values)

### Check if a value is within a tolerance

`=IF(ABS(B2-$F$1)<=$F$2,"Pass","Fail")`

Excel. Result on the sample sheet: 6 rows (C2:C7). [See it and try it](https://spreadsheetpractice.com/formulas/check-if-value-is-within-tolerance)

## Questions

### What does the ABS formula generator do?

You describe the task in plain English, and it writes the formula, using ABS where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.

### What does ABS do?

ABS returns a number without its sign, so -250 becomes 250 and 250 stays 250.

### Can I learn to write ABS formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the ABS function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
