The Excel COS Function

Related Functions:
SIN Function
TAN Function
Cosine of an Angle

For the simple right-angled triangle below, the cosine of the angle θ, is the ratio of the adjacent side, a, to the hypotenuse, h.

Right-Angled Triangle

I.e. for the triangle above,

Cosine Equation

The trig. ratios are discussed further on the Wikipedia Trigonometric Ratios Page

Basic Description

The Excel COS function calculates the cosine of a given angle.

The format of the function is :

COS( number )

Where the number argument is the angle, in radians, that you want to calculate the cosine of.

Converting from Radians to Degrees

If your angle is in degrees, you will need to convert it into radians before supplying it to the Cos function.

The easiest way to do this is to use the Excel Radians function:

=RADIANS( degrees )
An example of this is given below.

Cos Function Examples

Column A of the spreadsheet below, shows examples of the Excel Cos Function, used to calculate the cosine of different angles.

 Formulas:
 AB
1=COS( 0.785398163 ) - cos of 0.785398163 Radians
2=COS( 0 ) - cos of 0 Radians
3=COS( -PI()/3 ) - cos of -π/3 Radians
4=COS( RADIANS( -30 ) ) - cos of -30 Degrees
 Results:
 A
10.707106781
21
30.5
40.866025404

Note that in the above examples:


Further information and examples of the Excel Cos function can be found on the Microsoft Office website.