Learn how to use the Excel ABS function with syntax and examples.
The Microsoft Excel ABS function returns the absolute value of a number.
The syntax for the Microsoft Excel ABS function is:
ABS( number )
number is a numeric value.
The ABS function can be used in the following versions of Microsoft Excel:
The ABS function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel ABS function examples and explore how to use the ABS function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel ABS examples would return:
=ABS(A1) Result: 210.67 =ABS(A2) Result: 2.9 =ABS(A3) Result: 3 =ABS(-4.5) Result: 4.5 =ABS(-210.67) Result: 210.67 =ABS(5) Result: 5 =ABS(2-10) Result: 8
Now, let's look at more Excel ABS examples and explore how to use the ABS function in Excel VBA code. For example:
Dim LNumber As Double LNumber = Abs (-210.6)
In this example, the variable called LNumber would now contain the value of 210.6.