How to use the Excel ABS function

ABS Function 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 expectation of getting negative value. The values obtained from ABS function are the absolute values just by removing the minus (-) sign from the calculated value, for this we just simply need to apply ABS function in the value or we can put formula inside the ABS

Syntax: =ABS (number)

The ABS function syntax has the following arguments:

  • Number (Required): The real number of which you want the absolute value.

Example: Let’s look at some Excel ABS function examples and explore how to use the ABS function as a worksheet function in Microsoft Excel:

Syntax:  =ABS(C2)


Based on the Excel spreadsheet above, the following ABS examples would return:

Syntax: =ABS(C3)
Result: 38

Syntax: =ABS(C4)
Result: 91.2

Syntax: =ABS(C5)
Result: 35.87

Syntax: =ABS(C6)
Result: 0

Syntax: =ABS(C7)
Result: 130.82

Syntax: =ABS(C8)
Result: 6

Syntax: =ABS(C9)
Result: 0

Note: For example, ABS(-3) returns a value of 3 and ABS(3) returns a value of 3, because the ABS function returns a number’s distance from zero.

Add a Comment

Your email address will not be published. Required fields are marked *