DEGREESfunction converts an angle value in radians to degrees. This is useful when working with trigonometric functions that require angles in degrees. The function takes one parameter,
angle, which is the angle value in radians.
- How to use
- Examples of using
DEGREESformula not working?
- Similar formulas to
DEGREES formula with the syntax shown below, it has 1 required parameter:
- angle (required):
The angle value in radians to be converted to degrees.
ExamplesHere are a few example use cases that explain how to use the
DEGREESformula in Google Sheets.
Converting radians to degrees
DEGREES function can be used to convert an angle value in radians to degrees. For example, if you have an angle value of 1.5708 radians, which is equivalent to 90 degrees, you can use
DEGREES(1.5708) to convert it to degrees.
Calculating angles in degrees
DEGREES function can be used in combination with other math functions to calculate angles in degrees. For example, if you have the sine of an angle in radians, you can use
DEGREES(ASIN(value)) to calculate the angle in degrees.
Plotting trigonometric functions
DEGREES function can be used to plot trigonometric functions in degrees on a graph. By converting the angles to degrees, you can easily plot the values using the chart tools in Google Sheets.
DEGREESnot working? Here are some common mistakes people make when using the
DEGREESGoogle Sheets Formula:
Incorrect argument type
The angle argument must be in radians, not degrees. If the angle is in degrees, it must be converted to radians before using the DEGREES formula.
The DEGREES formula requires one argument, the angle in radians, and will produce an error if this argument is missing.
Incorrect function name
Make sure the function name is spelled correctly, DEGREES is a valid formula in Google Sheets and not DEGREE or DEGRE.
The following functions are similar to
DEGREES or are often used with it in a formula:
RADIANSformula is used to convert an angle value from degrees to radians. This is commonly used in trigonometry and other mathematical calculations that require angles to be in radians.
SINfunction in Google Sheets returns the sine of a given angle in radians. Sine is a mathematical function that describes a smooth repetitive oscillation. It is commonly used in trigonometry, physics, and engineering to model phenomena such as waves, oscillations, and periodic motion.
COSfunction in Google Sheets returns the cosine of an angle provided in radians. It is commonly used in trigonometry to calculate the cosine of an angle. The function takes one parameter, the angle in radians.
TANfunction returns the tangent of an angle specified in radians. Tangent is the ratio of the length of the opposite side to the length of the adjacent side of a right-angled triangle. This function is commonly used in trigonometry and geometry calculations.
You can learn more about the
DEGREES Google Sheets function on Google Support.