ACOS Function in Excel: Angle From a Cosine

⏱ 1 min readUpdated 28 September 2026

MathLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. 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 article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong