When you need to calculate absolute values for numbers in Excel spreadsheets, you can use the ABS function to calculate. The ABS function helps you calculate the absolute value of a number, an expression or reference containing a number.
The following article shows the syntax and usage of ABS function in Excel.
Description
ABS returns the absolute value of a number, the absolute value of a number is a non-negative number (always greater than or equal to 0, without a sign), and its value is equal to the value of the given number.
Syntax
= ABS (number)
Inside:
number is the real number you want to get absolute value from, it can be a specific number, a reference containing a number or a numeric expression is a required parameter.
For example
- Calculate the absolute value of a specific number: - 5, 5.
- Calculate the absolute value of a numeric expression:
- Calculate the absolute value of a reference:
So you know the syntax and usage of ABS function to calculate absolute value, you can combine ABS function with other functions to perform calculations on Excel. Good luck!