Documentation/Calc Functions/ABS

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

Calc Functions Home | List of functions | Abbreviations

Function name:

ABS

Category:

Mathematical

Summary:

Calculates the absolute value or modulus of a real number.

Syntax:

ABS(Number)

Returns:

Returns a non-negative, real number which is the absolute value of the real number passed as argument.

Arguments:

Number is the real number, or a reference to a cell containing that number, whose absolute value is to be calculated.

• If Number is non-numeric, then ABS reports a #VALUE! error.

Additional details:

The absolute value of a number is its value without the +/- sign. If Number is negative, the corresponding positive value is returned. If Number is not negative, its value is returned without change.

The figure below illustrates the ABS function:

ABS function

Examples:

Formula	Description	Returns
=ABS(234.5)	Absolute value of 234.5	234.5
=ABS(D1) where cell D1 contains the value -123	Absolute value of -123	123
=ABS(0)	Absolute value of 0	0

Related LibreOffice functions:

IMABS

SIGN

ODF standard:

Section 6.16.2, part 2.

Related (or similar) Excel functions:

ABS