Arrow left
Back to product guides
Google Sheets Formulas

How to Use ABS Formula in Google Sheets

In this article, you will learn how to get absolute values in Google Sheets. 

How to use ABS function in Google Sheets

  1. Type in “=ABS” or go to “Insert” tab ➝ “Function” ➝ “Math” ➝ “ABS”
  2. Input a number or a series of calculations by manual input or cell reference
  3. Done
How to insert ABS formula in a cell

Generic formula


Value: A number you want to convert to an absolute value.

The screenshot below presents examples of how to input value in the formula.

How to use ABS function in Google Sheets with examples

How do you find the mean absolute deviation in Google Sheets?

You can see how to compute the mean absolute deviation in this article.

How do you have absolute references in multiple cells in Google Sheets?

There is an article about relative and absolute references. Go to this page.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711