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

‍

Generic formula

=ABS(value)

‍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 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.