Returns the absolute value of a number.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 5
Converts the negative integer -5 to its positive equivalent.
=ABS(10-25)Результат: 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.