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.

convert radians to degrees in Excel

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

calculate_rad_to_deg is a sub-procedure,

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 (&).