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.

radians to degrees in excel

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.

convert radians to degrees using math operator

  • 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.

radians to degrees result in excel

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.

convert radians to degrees using vba

  • 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

convert radians to degrees vba code

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.

convert radians to degrees vba run

  • Here’s the result.

convert radians to degrees 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.

convert radians to degrees minutes seconds in excel

  • 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.

Read More: How to Convert CM to Feet and Inches in Excel


Calculator – Radians to Degrees

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

calculator to convert radians to degrees


Download the Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan Shimul
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo