Google Sheets
ABS function in Google Sheets
Returns the absolute value of a number.
=ABS(value)ABS syntax and parameters
One argument, one required.
- valuenumberRequired
The number of which to return the absolute value.
ABS examples
Formulas you'll actually reuse.
The size of a variance, ignoring its direction:
=ABS(B2 - C2)Result
340Total absolute error between forecast and actual:
=SUMPRODUCT(ABS(B2:B50 - C2:C50))Result
4120
ABS in Excel
Same name — your formula ports as-is.
Try ABS in the playground
Edit the example — nothing to install.
Preloaded with the ABS formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel
- ASINHReturns the inverse hyperbolic sine of a number.MathExcel