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




  • 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

Leave a Reply

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common

Read More »


The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

Read More »
Scroll to Top