Usually angles are measured in degrees. They can, however, also be measured in radians, which most of us don't understand.
To help make sense of these radians measurements, Excel has included a DEGREES function to convert radians to degrees.
The syntax for the DEGREES function is:
= DEGREES ( Angle )
Angle - the angle in radians to be converted to degrees.
Example: Using Excel's DEGREES Function
For help with this example, see the image above.
- Enter the following data into cell D1: 0.5
- 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 DEGREES 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 28.64789 should appear in cell E1.
- When you click on cell E1 the complete function = DEGREES ( D1 ) appears in the formula bar above the worksheet.
- If you want to reduce the number of decimal places in the answer 28.64789 to make it easier to understand, use the ROUND Function.