From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Use DEGREES function in MS Excel Guide

What is DEGREES Function in Excel?

The DEGREES function in Excel converts radians to degrees. It takes an angle value in radians as its argument and returns the equivalent angle value in degrees.

DEGREES Function Description

The DEGREES formula in Excel is used to convert numerical values from radians to degrees. It is a useful tool for anyone working with angles, particularly when the value is known in radians and needs to be converted to degrees.

The function takes one argument, which must be a numerical value representing a radian angle. The function will then convert the radian value to degree form. For example, if the argument value is 3.14159, the function will return 180.

In addition to its main purpose, you can use the formula as part of a larger formula. For example, if you need to calculate the sine of an angle in degrees, you can use the combination of the SIN function and the Degrees formula. The SIN function requires the argument to be in radians, so you can use the function to convert the angle in degrees to radians before passing it to the SIN function.

You can find the function in the Math & Trig category of the Excel functions library. It’s simple and you can use it to quickly convert an angle from radians to degrees.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

DEGREES Function Syntax

=DEGREES(Radians)

How to use DEGREES function in your workbook:

Degrees function MS Excel - Excel Formula Cheat Sheet
  1. Open a new Excel document.
  2. Select the cell where you want to enter the function.
  3. Type “=DEGREES(“ into the cell.
  4. Enter the angle you want to convert from radians to degrees.
  5. Close the parentheses after entering the angle.
  6. Press “Enter” to calculate the value.
  7. The cell will now contain the angle in degrees.

Frequently Asked Questions

Can the DEGREES formula be used with any type of angle measurement?

No, the DEGREES formula is specifically used to convert angle measurements from radians to degrees. If you have an angle measurement in a different unit, you may need to use a different function to convert it to radians before using the function to convert it to degrees.

Are there any other functions in Excel that are similar to the DEGREES?

Yes, the RADIANS function is the inverse of the DEGREES formula and is used to convert an angle value from degrees to radians. The CONVERT function is also similar to the DEGREES formula, as it can be used to convert between different units of measurement, including angles.