The ABS Function returns the absolute value of a number. This means Excel will convert negative numbers to positive. Positive number are not converted.

Syntax:

=ABS(number) 

Arguments

  • number – (required) Must be a valid number

ABS Function Usage Example:

Returns absolute value of a number.

ABS Function

Other Usage Examples:

We can use the ABS Function with the sum function. In order to do so, we need to turn the formula into an Array. When you first enter the formula below, you will receive the following #VALUE! error.

ABS Error

To turn the formula into an array, you need to select Cell B9, put your cursor in fx formula bar, then hit the following key commands.

Ctrl Shift Enter

This will convert the formula into an array.

ABS Array