How Easy To Use The ABS Function In Microsoft Excel – What Does ABS 2023?

The Above video article describes the formula syntax and usage of the ABS function in Microsoft Excel. ABS converts negative numbers to positive numbers, and positive numbers are unaffected.

ABS Function In Microsoft Excel

The ABS function returns the absolute value of a number. You can think about absolute value as a number’s distance from zero on a number line.

The ABS function takes just one argument, number, which must be a numeric value. If number is not numeric, ABS returns a #VALUE! error.

The Formula of ABS function is very easy, and that includes only one parameter, i.e. number.

Number: This is the required parameter. The number you wish to get the absolute number without its sign.

For this, the function we can give cell reference, we can enter the number directly, and we can enter the number in double-quotes.

Basic example

How to Use the ABS Function in Excel?

This ABS function is very simple and easy to use. Let us now see how to use the ABS Function with the help of some examples.

Negative numbers become positive, while positive numbers and zero (0) are unaffected:



The ABS function syntax has the following arguments:

Number Required. The real number of which you want the absolute value.


=ABS(-3) // returns 3

=ABS(5) // returns 5

=ABS(0) // returns 0

Absolute Variance Calculating the variance between two numbers is a common problem.


ABS Formula in excel is used to convert any negative number into a positive value. This is one of such function which we can use in any mathematical operation where there are some expectations of getting negative value. The values obtained from the ABS function are the absolute values just by removing the minus (-) sign from the calculated value; for this, we simply need to apply the ABS function in the value or put the formula inside the ABS.

Main Menu