ACOS function

The ACOS function in Excel returns the arccosine, or inverse cosine, of a number. It is used to find the angle (in radians) whose cosine is a given number.

Syntax

=ACOS(number)

Parameters

• number: This is a required argument. It is the cosine value for which you want to find the angle. The number must be between -1 and 1, inclusive. If the value is outside this range, the function will return an error (#NUM!).

How It Works

The ACOS function calculates the angle (in radians) whose cosine is the given value. The result is an angle in the range of 0 to π radians (0 to 180 degrees). To convert the result to degrees, you can use the DEGREES function.

Examples

Example 1: Using ACOS with a Cosine Value

If the value in cell A1 is 0.5, the formula:

=ACOS(A1)

will return 1.0472 (which is the arccosine of 0.5, or 60 degrees in radians).

Example 2: Converting Radians to Degrees

If you want the result in degrees instead of radians, you can use the DEGREES function. For example:

=DEGREES(ACOS(A1))

If A1 is 0.5, this will return 60, which is the angle in degrees.

Example 3: Value Outside the Range

If the value in A2 is 1.5, the formula:

=ACOS(A2)

will return an error #NUM!, as 1.5 is outside the valid range of -1 to 1 for the cosine function.

Key Points

• The ACOS function returns the arccosine (inverse cosine) in radians.
• It is typically used in trigonometry, geometry, and physics, where you need to calculate angles from the cosine values.
• If you need the result in degrees, combine ACOS with the DEGREES function.

Use Cases

• Engineering: When calculating angles based on cosine values, such as in mechanical systems or trigonometric problems.
• Data Analysis: Used in scenarios involving circular data or rotational geometry.
• Physics: Useful in problems related to vector analysis, such as finding angles between vectors given their cosine values.