# How to Convert Radians to Degrees in Excel (3 Easy Methods)

## Method 1 – Converting Radians to Degrees Using the DEGREES Function

• Select the cell to store the result. In our case, the cell is C6.

• Insert the following formula.
`=DEGREES(B6)`

B6 is the cell for radian input.

• Press Enter and use the Fill Handle to copy the formula to the cells below.

Read More: How to Convert MM to CM in Excel

## Method 2 – Converting Radians to Degrees Using PI

• Select the first cell to show the result. In our case, the cell is C6.

• Insert the formula given below in the cell.
`=B6*180/PI()`

We have multiplied the radian input value from B6 with 180 and then divided by pi.

• Press Enter and use the Fill Handle to copy the formula to the cells below.

Read More: Converting CM to Inches in Excel

## Method 3 – Converting Radians to Degrees with VBA Code

• Press Alt + F11 to open the VBA window.
• Right-click the sheet where you want the code to work.
• Select Insert, then Module.

• The Module window will show up. Insert the following code in the window.
``````Sub calculate_rad_to_deg()

For Each input_cell In Selection

input_cell.Offset(0, 1).Value =Application.WorksheetFunction.Degrees(input_cell.Value)

Next input_cell

End Sub``````

input_cell is a variable,

Offset(0, 1).Value puts the result in the next cell of the input cell,

Degrees(input_cell.Value) is a VBA function that converts the input radians to degrees.

• Close the window and select the range of cells whose values we want to convert to degrees.

• Select Macros from the View tab in the ribbon.

• The Macro window will show up.
• Select the VBA function created by the code and press Run.

• Here’s the result.

## How to Convert Radians to Degrees-Minutes-Seconds in Excel

• Select the cell where we want the result. In our case, the cell is D5.

• Insert the following formula there.
`=TEXT(INT(C5),"0Â° ")&TEXT(INT((C5-INT(C5))*60),"0' ")&TEXT((C5*60-INT(C5*60))*60,"0.0")&""""`

TEXT(INT(C5),”0Â° “) is giving the output in degrees without the fractional value,
Output: “49Â° ”

TEXT(INT((C5-INT(C5))*60),”0′ “) here the fractional value of the result of the degree is separated and multiplied by 60 to show the Minutes results
Output: “59′ ”

TEXT((C5*60-INT(C5*60))*60,”0.0″) is separating the fractional value from the Minutes result and multiplying it by 60 to get the Seconds results.
Output: “46.7”

Excel concatenates all these results through the concatenation operator (&).Â Â

• Press Enter and use the Fill Handle to copy the formula to the cells below.

## Calculator – Radians to Degrees

In the practice worksheet, we have included a calculator that you can use to convert angles in radians to degrees.

## Related Articles

<< Go Back to Excel CONVERT Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF