As mathematical operations are a primary use of Excel sheet, one can use the trigonometric functions to compute these easily.
The following sheet was created by Rahul to find the cos and sine values of the angle. He can use the values using COS and SIN functions.
Trigonometric Functions – COS
In trigonometry, COS is the quotient of the length of the adjacent side to the angle divided by the length of the hypotenuse.
Syntax:
COS(number)
where ‘number’ is the cell reference of the value that must be used for calculation.
The formula he should use is
=COS(A2)
He can now drag the formula over the other cells to find values for these too. The result will appear as follows.
Alternatively, he can go to the ‘Math & Trig’ from the ‘Function Library’ of ‘Formulas’ menu and then choose ‘COS’. The following dialogue box will appear. He can enter the particulars or select the cell references manually by selecting the arrow mark near the box. Click ‘OK’ once done.
Do note that the value will be taken as to be in the radians unit, by default, for this function. He can use the mathematical formula PI()/180 to convert it to degrees.
Trigonometric Functions – SIN
In trigonometry, SIN is the quotient of the length of the opposite side to the angle divided by the length of the hypotenuse.
Syntax:
SIN(number)
where ‘number’ is the cell reference of the value that must be used for calculation.
The formula he should use is
=SIN(A2)
He can now drag the formula over the other cells to find values for these too. The result will appear as follows.
Alternatively, he can go to the ‘Math & Trig’ from the ‘Function Library’ of ‘Formulas’ menu and then choose ‘SIN’. The following dialogue box will appear. He can enter the particulars or select the cell references manually by selecting the arrow mark near the box. Click ‘OK’ once done.
Do note that the value will be taken as to be in the radians unit, by default, for this function. He can use the mathematical formula PI()/180 to convert it to degrees.