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.
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.
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.
This will convert the formula into an array.