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.