Excel ABS Function

Summary

The Excel ABS function returns the absolute value of a number. Negative numbers are converted to positive numbers, and positive numbers are unaffected.

Purpose

Find the absolute value of a number

Return value

A positive number.

Syntax

=ABS (number)

Arguments

number - The number to get the absolute value of.

Usage notes

For example, ABS(-3) returns a value of 3 and ABS(3) returns a value of 3, because the ABS function returns a number's distance from zero.