Since Excel's, trig functions use radians, we often need a way of converting angles measured in degrees to radians. The RADIANS function, one of Excel's math functions, does just that.
The syntax for the RADIANS function is:
= RADIANS ( Angle )
Angle - the angle in degrees to be converted to radians.
Example: Using Excel's RADIANS Function
For help with this example, see the image above.
- Enter the following data into cell D1: 34
- 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 RADIANS in the list to bring up the function's dialog box.
- In the dialog box, click on the Angle line.
- Click on cell D1 in the spreadsheet.
- Click OK.
- The answer 0.593412 should appear in cell E1.
- When you click on cell E1 the complete function = RADIANS ( D1 ) appears in the formula bar above the worksheet.