The ABS function is a Math formula that returns the absolute value of a given number. The absolute value of a number represents number's distance from zero, regardless of the direction. This means that the distance of a number x has the same distance as negative number -x from zero. In this guide, we’re going to show you how to use the absolute value function (ABS) in Excel and also go over some tips and error handling methods.
Supported versions
- All Excel versions
ABS Function Syntax
Arguments
number | A real number for which you want the absolute value. |
Examples
Simple Use Case
The ABS function needs only a single argument named number. The number can be a value, cell reference, or another formula. Below is an example:
Closest Date
The ABS function can be used to calculate the days between dates. For example, to calculate the difference between a date (MyDate) and today's date, use the following formula:
Tolerance
Another common usage of the ABS function is to calculate the tolerance. Tolerance represents the acceptable amount a value can change. These amounts are always indicated as positive values. Thus, the ABS function is perfect for these types of calculations. The following formula checks if the absolute value is less than or equal to the allowed tolerance, and returns "Yes" or "No" depending on the outcome.
Tips
- The ABS function effectively removes the sign of a number and returns a positive value.
- You can use the function to calculate absolute difference between dates.
- The function is useful for tolerance calculations.