Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)
Advertise on the
ExcelTips Site
Newest Tips
Working with Imperial Linear Distances
Incomplete and Corrupt Sorting
Quickly Removing a Toolbar Button
Deriving High and Low Non-Zero Values
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
Converting Radians to Degrees
Summary: When applying trigonometry to the values in a worksheet, you may need to convert radians to degrees. This is done by using the DEGREES worksheet function, described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)Excel includes a wide range of worksheet formulas you can use for many different mathematical purposes. If you are working with trigonometric functions, you may need to convert radians to degrees. For instance, if you have an angle that is 0.75 radians, and you wanted to know how many degrees that represented, you could use the following formula:
=DEGREES(0.75)
The result would be 42.97183463 degrees. You can, of course, use a cell reference in the place of the radians value within the formula:
=DEGREES(G17)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2162) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.Check out Excel Conditional Formatting today!