How to Convert Angles from Radians to Degrees in Excel

This post will guide you how to convert angles from radians to degrees with a formula in Excel. How do I convert angle between radians to degrees in Excel.

When you want to solve trigonometric expressions like sine, cosine and tangent, you need to use radians to perform these calculations. So if your have a range of list that contain degree values, and you have to convert it to radians for calculation.

You may be have a list of data that contain radian values, and you want to convert it from radians to degrees. You can use a build-in function known as RADIANS function, it can be used to convert degrees to radians. And you can use the DEGREES function to convert radians into degrees in Excel.

Convert angles from Radians to degrees


Assuming that you have a list of degrees in range B1:B4, and you want to convert those values into radians, just use the following formula:

=RADIANS(B1)

Type this formula into a blank cell or the adjacent cell C1, press Enter key to apply this formula. And then drag the AutoFill Handle down to other cells until to C4.

convert angels from radians to degree1

You would see that all degree values has been converted to radian values.

 

Convert Angles from Degrees to Radians


If you want to convert radian values to degree values, just use the below formula based on the DEGREES function.

=DEGREEES(C1)

Type this formula into a blank cell or the adjacent cell D1, press Enter key to apply this formula. And then drag the AutoFill Handle down to other cells until to D4.

convert angels from radians to degree2

You would see that all radian values have been converted to degree values.

Related Functions


  • Excel DEGREES Function
    The Excel DEGREES function converts radians into degrees. And it will return a numeric value.The syntax of the DEGREES function is as below:=DEGREES (angle)…

 

 

Related Posts
If Cell is Blank
If Cell is Blank_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String
If cell equals certain text_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2
If cell contains text1 or text2_1

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

VLOOKUP From Another Sheet Not Working
vlookup from another sheet not working3

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you reasons why your VLOOKUP formula is not working ...

If Cell Begins with One of Three Supplied Characters
If Cell Begins with One of Three Supplied Characters

If you want to test values to see if they begin with some given specific characters like “x”, ”y”, or “z”, you can create a formula with COUNTIF and SUM functions to return results. EXAMPLE You can see “TRUE” or ...

Fix #N/A Error For VLOOKUP From Another Sheet
vlookup from anther sheet not working1

This post will show you how to fix the #N/A error why it occurs when you extract values from another sheet using VLOOKUP function in Excel 2016,2013,2010 or other Excel versions. How can you correct a #N/A error in VLOOKUP ...

How To Remove Special Characters in Excel
remove special character2

This post will show you how to remove special characters from text strings in Excel. And I am going to introduce two ways to remove special characters (@&)#%$) from a string in Excel. Removing Special Characters using Power Query If ...

How To Insert Comments in Protected Worksheet in Excel
insert commetns in protected workshee3

This post will show you how to allow comments in a protected worksheet in Excel. You can easily to insert comments into cells in a normal worksheet in Excel, but if want to insert a comment in a worksheet that ...

How To Convert Text to Upper Cases(Using VBA) in Excel
convert text to upper cases1

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

Sidebar