Google Sheets DEGREES Function: Syntax, Examples & Tips

The DEGREES function converts radians to degrees, allowing for easier interpretation of angular measurements in degrees.
Google Sheets
DEGREES(angle)

One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.

On this page
  1. Parameters
  2. What is the DEGREES Function?
  3. A Practical Example
  4. DEGREES Formula
  5. Result of the Formula
  6. Why Use DEGREES?
  7. Key Takeaways:
  8. Example use case

Parameters

angle:
The angle in radians that you want to convert to degrees. This can be a number, a cell reference, or a formula that returns a radian value.

What is the DEGREES Function?

The DEGREES function in Google Sheets is a simple yet useful tool that converts an angle measured in radians into degrees. This function is particularly helpful in various mathematical calculations, especially in trigonometry, where angles are often expressed in radians.

In simpler terms, DEGREES allows you to take a value in radians and convert it to its equivalent in degrees, making it easier to interpret and use in calculations.

A Practical Example

Imagine you are working on a project that involves calculating angles for a design. You have some angles measured in radians and need to convert them to degrees for better understanding.

Radians Table:

Angle (Radians)
0
1.57
3.14
4.71

DEGREES Formula

To convert the angles from radians to degrees, you would use the DEGREES function as follows:

Google Sheets
=DEGREES(A2)

In this formula:

  • A2 is the cell containing the angle in radians that you want to convert.

Result of the Formula

When you apply the DEGREES formula to the Radians Table, the output would look like this:

Angle (Radians)Angle (Degrees)
00
1.5790
3.14180
4.71270

As you can see, each angle in radians has been successfully converted to its corresponding degree value.

Why Use DEGREES?

The DEGREES function is beneficial because it simplifies the process of converting radians to degrees, which is a common requirement in many mathematical and engineering applications. It allows for quick and accurate conversions without the need for manual calculations.

Key Takeaways:

  • DEGREES: A Google Sheets function that converts radians to degrees.
  • Simplicity: Provides an easy way to perform angle conversions, enhancing usability.
  • Common Use Cases: Ideal for trigonometric calculations, engineering projects, and any scenario where angle measurement is necessary.

The DEGREES function is an essential tool for anyone working with angles in Google Sheets, providing a straightforward way to enhance calculations and data analysis.

Happy spreadsheeting!

Example use case

You have a table with angles in radians in Column A. To convert these angles to degrees for better readability, you can use the DEGREES formula in Column B. This allows for quick conversions, making it easier to analyze and present angle data.

Need more help with Google Sheets formulas?

Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis.

Explore all Google Sheets formulas

Browse our complete library of Google Sheets formula guides

Compare your options

Decide with evidence, not a sales pitch.

Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.

  1. 01ChatGPTOpen a balanced comparison prompt in ChatGPT.
  2. 02ClaudeOpen the same research prompt in Claude.
  3. 03PerplexityResearch the comparison with linked web sources.

AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.