DEGREES Excel Formula

Author Zaheer    Category Formulas     Tags ,

When working with spreadsheet which primarily incorporates data in degrees, it would be an excellent idea to utilize an Excel function that has the ability to work around with them. There is the so-called DEGREES function in Microsoft Excel which can now allow you to change values measured in radians to angle values that are measured in degrees, instead of using complicated formulas manually.

Description of DEGREES Function in Microsoft Excel

The DEGREES function in excel is used to convert an angle measured in radians into degrees. The formula of this function is:

DEGREES( Angle )

In this formula, the angle argument refers to angle measured in radians that you want to convert into degrees. You are required to supply a numerical value for this argument.

You have to take note that you can supply this argument in the formula in the following:

  • A cell reference containing the angle value
  • The actual numerical value
  • Values that are returned from other functions or formulas

Examples on the Usage of the DEGREES Function in Microsoft Excel

These particular examples will show you on how to use the DEGREES function in converting angle values measured in radians into degrees.

  • Let’s say that a numerical value of 1 radian is contained in cell A1. Then type in this formula in any cell where you want the result to be displayed, =DEGREES(A1). The function will return the result which is 57.29577951.
  • For instance, 2.5 radians is contained in cell A2. You can use this formula to convert this into a value measured in degrees, =DEGREES(A2). The function will return the result which is 143.2394488.
  • Then take for instance that you want to convert ? radians into degrees. Remember that you can also use the PI function instead of using the symbol “?”. The formula of the PI function is, PI(). Then type in this formula in any cell where you want the result to be displayed, =DEGREES(PI()). The function will return the result which is 180.
  • Lastly, type in this formula in any cell, =DEGREES(-2*PI()). Then the function will return the result which is -360.

Keep in mind that the results in those examples above are now measured in degrees. You can try these examples in your own spreadsheet so you can explore more about the usage of the DEGREES function in Microsoft Excel.

Easy Steps on How to Use the DEGREES Function

For a better understanding on how to use the DEGREES function, this article will also provide the easy steps about its usage.

  • Learn the formula of the DEGREES function as given above.
  • Examine the radians. This unit of measurement is based on the equation of the circumference of the circle, c = 2?r (where r happens to be the radius of the circle, ? is a constant approximately equal to 3.14 and c is the circumference of the circle). With the use of unit circle having a radius equal to 1, you can have c=2? which is approximately equal to 6.28. Then a complete circle is roughly equal to 6.28 radians.
  • Study the degrees. This unit of measurement divides a circle in 360 parts. Most probably, it was selected due to the fact that 360 has several factors and also because this number is near to the number of days in a year.
  • Finally, try the examples that were given earlier so you can learn the usage of the DEGREES function.

Post comment