ABS function (absolute value calculation) in Excel

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.

ABS function (absolute value calculation) in Excel Picture 1

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.

ABS function (absolute value calculation) in Excel Picture 2

- Calculate the absolute value of a numeric expression:

ABS function (absolute value calculation) in Excel Picture 3

- Calculate the absolute value of a reference:

ABS function (absolute value calculation) in Excel Picture 4

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!