These functions are used for trigonometric and geometric calculations.

PI

Returns the value of π.

=PI()

Approximate result:

3.141592654

SIN

Returns the sine of an angle.

Excel’s trigonometric functions use radians, so degrees can be converted using RADIANS.

Example

=SIN(RADIANS(30))

Result:

0.5

\(\sin(a)=0.5\)

Drag the pointsa30.0°60.0°Adjacent 0.87Opposite 0.5Hypotenuse 1

Give feedback

COS

Returns the cosine of an angle.

=COS(RADIANS(60))

Result:

0.5

TAN

Returns the tangent of an angle.

=TAN(RADIANS(45))

Result:

1

Example Table

Angle

SIN

COS

TAN

0°

     

30°

     

45°

     

60°

     

90°

     

Practice

Create a Trigonometry Calculator where the user enters an angle in degrees and Excel calculates:

  • SIN
  • COS
  • TAN