How to use DEGREES Google Sheets formula?

The syntax for the DEGREES formula is =DEGREES(angle), it has 1 required parameter.

DEGREES

The DEGREES function 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 DEGREES formula?
Examples of using DEGREES formula
DEGREES formula not working?
Similar formulas to DEGREES

Usage

Use the DEGREES formula with the syntax shown below, it has 1 required parameter:

=DEGREES(angle)

Parameters:

angle (required):
The angle value in radians to be converted to degrees.

Examples

Here are a few example use cases that explain how to use the DEGREES formula in Google Sheets.

Converting radians to degrees

The 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

The 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

The 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.

Common Mistakes

DEGREES not working? Here are some common mistakes people make when using the DEGREES Google 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.

Missing argument

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:

RADIANS
The RADIANS formula 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.
SIN
The SIN function 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.
COS
The COS function 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.
TAN
The TAN function 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.

Learn More

You can learn more about the DEGREES Google Sheets function on Google Support.