Returns the absolute value of a number.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
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.
=ABS(-5)Ergebnis: 5
Converts the negative integer -5 to its positive equivalent.
=ABS(10-25)Ergebnis: 15
Calculates the absolute difference between 10 and 25.
The function will return the number unchanged.
No, it will return a #VALUE! error if the input is non-numeric text.