Google Sheets-funktion

ABS

Returns the absolute value of a number.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

ABS(number)

The ABS function removes the negative sign from a number, effectively converting it to a positive value. It is commonly used to calculate the magnitude of a difference between two values regardless of which is larger.

Argument

numberobligatorisktThe real number for which you want the absolute value.

Exempel

=ABS(-5)

Resultat: 5

Converts the negative integer -5 to its positive equivalent.

=ABS(10-25)

Resultat: 15

Calculates the absolute difference between 10 and 25.

Vanliga frågor

What happens if the input is already positive?

The function will return the number unchanged.

Can ABS handle text inputs?

No, it will return a #VALUE! error if the input is non-numeric text.

Relaterade funktioner

SIGN SUM POWER