COS Function

Returns the cosine of an angle given in radians.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A number from −1 to 1

Want to practice COS in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

COS returns the cosine of an angle — the adjacent side divided by the hypotenuse.

Excel's trig functions work in radians. Convert degrees with RADIANS, or multiply by PI()/180.

Syntax

=COS(number) Explain

Arguments

ArgumentRequired?What it does
numberYesThe angle in radians.

Examples

Example 1 — Cosine of common angles

Angles in degrees, converted inside the formula.

B2fx=COS(RADIANS(A2))
AB
1DegreesCosine
201
3600.5
4180-1
=COS(RADIANS(A2)) Explain

Example 2 — Horizontal reach

A 6 m ramp at 5° covers how much floor?

=6*COS(RADIANS(5)) Explain

About 5.98 m.

Common mistakes

  • Tiny numbers instead of zero. COS(RADIANS(90)) shows 6.12E-17 — floating-point noise. Wrap in ROUND(…, 10) if you need a clean 0.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.