Returns the absolute value of a number.
تعمل هذه الدالة في Google Sheets كما تعمل في 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.