ABS function

The ABS function in Excel is used to return the absolute value of a number. The absolute value of a number is the distance of that number from zero on the number line, without considering whether the number is positive or negative.

Syntax

=ABS(number)

Parameters

• number: This is the only argument. It is the numeric value, reference to a cell, or expression for which you want to find the absolute value.

How It Works

The ABS function will return the positive version of a number, even if the number is negative. If the number is already positive, it will return the number as is.

Examples

Example 1: Absolute Value of a Positive Number

If you enter 5 in cell A1, the formula:

=ABS(A1)

will return 5.

Example 2: Absolute Value of a Negative Number

If you enter -5 in cell A2, the formula:

=ABS(A2)

will return 5, as it converts the negative number to its positive counterpart.

Example 3: Absolute Value of Zero

If you enter 0 in cell A3, the formula:

=ABS(A3)

will return 0, as zero does not have a sign.

Example 4: Absolute Value of an Expression

You can also use ABS with mathematical expressions. For example, the formula:

=ABS(-7 + 3)

will return 4, as it first calculates -7 + 3 = -4, and then converts the result to 4.

Key Points

• ABS is useful in scenarios where you need to disregard the sign of a number, such as when calculating distances, differences, or magnitudes.
• It’s often used in financial analysis, engineering, and statistical calculations.

Use Cases

• Financial Calculations: To calculate the absolute difference in values or to work with amounts that should always be treated as positive, such as profit or loss calculations.
• Statistical Analysis: In calculations like the absolute deviation, where you need to measure the difference between data points and the mean without considering negative signs.