fx =ABS(A1)ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

ABS Formula for Math

Return absolute (positive) value of a number. Copy-paste ready for Excel, Google Sheets, and Airtable.

=ABS(A1)
When you need this: When you calculate profit/loss (could be negative -$500) but need to show the absolute amount ($500) in a report.

How it works

  1. 1ABS converts any number to its positive equivalent.
  2. 2ABS(-50) returns 50, ABS(50) returns 50.
  3. 3Perfect for variance analysis, distances, and magnitudes.

Variations

ABS for variance calculation
=ABS(B1-A1)
SUMPRODUCT with ABS
=SUM(ABS(A1:A100))

Related Formulas

SUM — Add up a range of numbersMathSUMIF — Sum values that meet a single conditionMathSUMIFS — Sum values meeting multiple conditionsMathROUND — Round a number to specified decimal placesMath

Need a formula that's not here?

Generate custom formula →