Excel's list of functions includes a number of the most common trig functions. These include the SIN function which gives you the sine of an angle measured in radians.
Note: Since most angles are measured in degrees, you might need to convert your data to radians using the RADIANS function.
The syntax for the SIN function is:
= SIN ( Number )
Number - the angle in radians being calculated.
Example: Using Excel's SIN Function
For help with this example, see the image above.
- Enter the following data into cell D1: 0.593412
- Click on cell E1 in the spreadsheet - this is where the function will be located.
- Click on the Formulas tab of the ribbon menu.
- Choose Math & Trig from the ribbon to open
the function drop down list.
- Click on SIN in the list to bring up the function's dialog box.
- In the dialog box, click on the Number line.
- Click on cell D1 in the spreadsheet.
- Click OK.
- The answer 0.559193 should appear in cell E1.
- When you click on cell E1 the complete function = SIN ( D1 ) appears in the formula bar above the worksheet.