How to Use the DEGREES Function in Excel

Welcome to our comprehensive guide on using the DEGREES function in Microsoft Excel and Google Sheets. The DEGREES function is essential for converting angles measured in radians to degrees. This article will outline the function”s syntax, illustrate its applications with examples, and show you how to use it effectively.

Syntax:

The syntax for the DEGREES function is consistent across both Excel and Google Sheets:

=DEGREES(angle)

• angle: The angle in radians you wish to convert to degrees.

Example 1: Simple Conversion

Here’s how to convert an angle from 1.5 radians to degrees using the DEGREES function.

By entering =DEGREES(1.5) in a cell, Excel or Google Sheets will display the result as approximately 85.9437 degrees.

Example 2: Using Cell Reference

It is also possible to use a cell reference with the DEGREES function. For example, if cell A1 contains the radian measure you wish to convert, you would use the formula:

=DEGREES(A1)

Example 3: Applying DEGREES Function in a Formula

Consider a scenario where you need to calculate the hypotenuse of a right-angled triangle using the sine function and also want the angle in degrees. You can achieve this as follows:

=DEGREES(SIN(1))

This expression first calculates the sine of 1 radian and then converts the result to degrees using the DEGREES function.

These examples demonstrate the flexibility of the DEGREES function in efficiently converting angles from radians to degrees in both Excel and Google Sheets.

More information: https://support.microsoft.com/en-us/office/degrees-function-4d6ec4db-e694-4b94-ace0-1cc3f61f9ba1