Summary
The Excel ABS function returns the absolute value of a number. Absolute value refers to the distance of a number from zero, disregarding its sign. This function is commonly used in mathematics and financial analysis to express a number without its sign, ensuring only non-negative values are considered.
Syntax
=ABS(number)
- number: The number for which you want the absolute value
Return value
The non-negative absolute value of the specified number.
How to use
Use ABS by entering a number or a cell reference containing a number as the argument. The function will return the number without any sign, effectively converting negative values to positive ones.
Examples
Simple ABS
Converting a Negative Number to Positive: To get the absolute value of a negative number:
=ABS(-5)
This formula returns 5, which is the absolute value of -5.
ABS with Cell Reference
Using ABS with a Cell Reference: To find the absolute value of a number in a cell:
=ABS(A2)
If A2 contains -10, this formula will return 10.
ABS in Financial Calculations
Calculating Absolute Differences in Finance: To calculate the absolute difference between two values:
=ABS(A2 - B2)
If A2 is 100 and B2 is 120, this formula returns 20, representing the absolute difference between these values.
ABS with SUM
Combining ABS with Other Formulas: Using ABS in a more complex formula with SUM:
=ABS(SUM(A2:A10))
This calculates the sum of values in A2:A10 and then returns the absolute value of the sum.
ABS for Data Analysis
Analyzing Data with Absolute Values: To analyze variations or changes in data:
=ABS(A2 - AVERAGE(A2:A10))
This finds the absolute difference between a value in A2 and the average of values in A2:A10.
Additional Notes
- The ABS function is particularly useful in scenarios where only the magnitude of a number is important, not its direction (positive or negative).
- Common uses of ABS include calculating distances, differences, and handling positive and negative values uniformly in various calculations.