Home › Functions › Math & Trig › ABS
fx
ABS
Math & Trig  ·  Since: Excel 2003  ·  9 languages

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

🌐 Translations

English ABS
Deutsch ABS
Français ABS
Español ABS
Italiano ASS
Português ABS
Nederlands ABS
Polski MODUŁ.LICZBY
Русский ABS

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

ABS(number)

Arguments

number (required) — The real number of which you want the absolute value.

▶ Examples

=ABS(A2)
=ABS(2)
=ABS(-2)

Related functions

Copied to clipboard