Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax

ABS(number)

Number     is the real number of which you want the absolute value.

Example

Col1

Formula

Description (Result)

-4

=ABS([Col1])

Absolute value of -4 (4)

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×