Math & Trig

COS Function in Excel

Returns the cosine of an angle specified in radians.

Syntax

  • =COS(number)

Arguments

  • number (required): Angle in radians

Examples

  • =COS(0) - Cosine of 0 - Result: 1
  • =COS(PI()) - Cosine of 180 degrees - Result: -1

COS in reporting workflows

  • Use absolute references when copying formulas across rows.
  • For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
  • Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

  • Argument must be in radians, not degrees

Use cases

  • Trigonometry
  • Circular motion
  • Engineering calculations

Frequently asked questions

  • How do I calculate the x-coordinate of a point on a circle? Use =radius*COS(angle). For a point at 45° on a circle with radius 10: =10*COS(RADIANS(45)) = 7.07. Combined with SIN for y-coordinate, you can plot any point on a circle: x=r*COS(θ), y=r*SIN(θ).
  • What is the relationship between SIN and COS? COS and SIN are phase-shifted by 90°: COS(x) = SIN(x + π/2). Also, SIN²(x) + COS²(x) = 1 always (Pythagorean identity). COS starts at 1 when angle is 0, while SIN starts at 0.
  • How do I use COS for direction calculations? For movement in a direction: x_move = speed*COS(RADIANS(angle)), y_move = speed*SIN(RADIANS(angle)). At 0°, COS=1 and SIN=0, so movement is purely horizontal. At 90°, COS=0 and SIN=1, so movement is purely vertical.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.