ACOS in Excel: Recover Angles from Ratios and Vector Comparisons

• Introduced: original introduction release and first numeric build are not established by the official history reviewed.
• Availability: the official ACOS reference lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026. Documentation and independently calculated finite-value examples; no native Excel execution or broader platform certification.

=ACOS(number)

The required input is a cosine value from −1 through 1. Microsoft specifies an output between 0 and PI() radians. Both endpoints are included in the ordinary mathematical branch. Convert the output, not the input ratio, if degrees are required.

Examples use English function names and decimal points; comma separators appear in multiargument helper functions. Keep ratios dimensionless by dividing quantities expressed in compatible units.

Enter 1, 0.5, 0, −0.5, −1 in A2:A6. In B2 use and fill down:

=ACOS(A2)*180/PI()

Expected results: 0, 60, 90, 120, 180 degrees. A negative cosine yields an obtuse principal angle, not a negative ACOS result. At zero input, the radian result is approximately 1.570796327.

These controls help reveal an accidental use of ASIN, which has a different principal range. Function names that both start with A do not imply interchangeable inverse relationships.

For a constructed right triangle with adjacent side 12 and hypotenuse 13:

=ACOS(12/13)*180/PI()

Expected acute angle: approximately 22.619864948 degrees. The remaining opposite side is 5, so the result agrees with ASIN(5/13). This is a geometry identity using a stated triangle, not an inference from arbitrary measurements.

If the intended ratio were opposite/hypotenuse, use ASIN instead. Verify the roles of the input lengths before changing a formula just to match an expected angle.

Let the two-dimensional vectors be u=(1,2) and v=(2,1). Their dot product is 4, each length is SQRT(5), and the normalized dot product is 4/5. Use:

=ACOS((1*2+2*1)/(SQRT(1^2+2^2)*SQRT(2^2+1^2)))*180/PI()

Expected angle: approximately 36.869897646 degrees. The vectors are nonzero, so the normalization denominator is defined. Reversing either vector changes the ratio to −0.8 and gives approximately 143.130102354 degrees.

This calculation returns an unsigned angle between vectors. It does not identify a clockwise versus counterclockwise turn. When an orientation from a coordinate pair is needed, review ATAN2 and its coordinate-order convention.

=ACOS(COS(-60*PI()/180))*180/PI()

Expected result: 60. COS has the same value for positive and negative 60 degrees, and ACOS chooses its nonnegative principal representative. A source angle outside the principal interval cannot generally be reconstructed without extra information.

A normalized ratio outside −1 to 1 is not a valid real ACOS input. Check for a zero-length vector, incompatible units, mismatched components or rounding in intermediate calculations. Near an endpoint, finite precision may move an intended ratio slightly outside the interval.

Do not silently clamp every ratio with MIN or MAX unless a documented tolerance policy permits it; that can hide an actual data or model error. Keep intermediate dot products and vector lengths available for inspection. The dedicated reference states the domain, while arbitrary text coercion and exact displayed error codes remain outside this guide’s native testing scope.

• Microsoft ACOS reference.
• Editorial testing standards.

Numerical outputs are independent mathematical expectations, rounded where stated. Product-specific syntax and scope come from the cited reference. Native error/coercion matrices and extreme-value precision remain untested.