MS Excel: ABS function

DESCRIPTION

The Microsoft Excel ABS function returns the absolute value of a number

SYNTAX

The syntax for the ABS function in Microsoft Excel is:

ABS( number )

PARAMETERS or ARGUMENTS

number - A numeric value used to calculate the absolute value.

EXAMPLES

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 Excel spreadsheet above, the following ABS examples would return:

=ABS(A1)

 Result: 120

=ABS(A2)

 Result: 3.5

=ABS(A3)

 Result: 45

=ABS(-6.9)

 Result: 6.9

=ABS(5-15)

 Result: 10