
MathLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
ACOS is the inverse of COS. It appears in the formula for distance between two places on Earth.
Syntax
=ACOS(number)
| Argument |
What it means |
number |
Between −1 and 1. |
Examples
Example 1
=6371*ACOS(COS(RADIANS(90-B2))*COS(RADIANS(90-B3))+SIN(RADIANS(90-B2))*SIN(RADIANS(90-B3))*COS(RADIANS(C2-C3)))
Approximate km between two latitude/longitude points.
COS · RADIANS
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong