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

Categorize Text With Keywords

If you are looking for the simplest approach to categorize the text with keywords, then look no further because you have just landed on the right blog post where you will get to know a formula and its usage to ...

Cash Denomination Calculator

Every country has different cash denominations, so you may need to calculate the number of different denominations based on the total amount. If it is just a small amount of cash, then you can calculate the different cash denominations manually, ...

7 Best Free Weekly/Bi-Weekly Budget Template

This article will show you some free printable weekly/ BiWeekly budget templates for google sheet and Microsoft Excel spreadsheet applications, and will also explain some of the features or important functions of these templates. This will make it easy for ...

COUNTIF Function: Everything You Need To Know

In previous articles, we have written a lot about the application of Excel COUNTIF function in specific situations. In today's article, we will still focus on Excel COUNTIF function, we will introduce you some basic functions of COUNTIF function including ...

Cap percentage values between 0 and 100

This article will talk about how to cap the percentage values between 0% and 100% in Microsoft Excel Spreadsheet or Google Sheets. If you are a newbie on Excel or google Sheets, you may be able to do this by ...

Sidebar