Returns the absolute value of a number.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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)Sonuç: 5
Converts the negative integer -5 to its positive equivalent.
=ABS(10-25)Sonuç: 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.