دالة Google Sheets

ACOS

Returns the arccosine of a number.

تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.

الصيغة

ACOS(number)

The ACOS function calculates the angle whose cosine is the specified number. The returned angle is given in radians in the range 0 to pi.

=ACOS(0.5)

النتيجة: 1.047197551

Returns the arccosine of 0.5 in radians, which is pi/3.

=ACOS(-1)

النتيجة: 3.141592654

Returns the arccosine of -1, which is equal to pi.

What happens if the number is outside the range -1 to 1?

Excel will return the #NUM! error because the cosine of an angle cannot be outside this range.

How do I convert the result to degrees?

You can use the formula =DEGREES(ACOS(number)).