Converting trigonometric outputs in Excel can be frustrating when raw radians obscure your data's real-world meaning. While standard data sources-such as CAD software or physics engines-typically export angular measurements in radians, interpreting them for business reporting requires familiar units. Fortunately, Excel's calculation engine grants you an immediate, effortless conversion mechanism. Under the stipulation that your source cell contains strictly numeric data, the DEGREES formula seamlessly translates these complex values. For instance, converting =DEGREES(PI()) yields a perfect 180. Below, we outline the exact formula syntax and step-by-step application to streamline your workflow.

Excel Formula to Convert Radians to Degrees

When working with geometry, trigonometry, engineering, or physics in Microsoft Excel, you will quickly notice a fundamental characteristic of the software: Excel performs all of its trigonometric calculations using radians rather than degrees.

While mathematicians and scientists often prefer radians for calculations, most people find degrees (ranging from 0 to 360) much easier to visualize and interpret. If you feed an angle in degrees directly into Excel's SIN, COS, or TAN functions, or if you receive an output from inverse functions like ASIN or ACOS, the results will not be what you expect unless you perform a conversion.

In this comprehensive guide, we will explore the two primary ways to convert radians to degrees in Excel: using the built-in DEGREES function, and using a manual mathematical formula with the PI() function. We will also cover real-world use cases, troubleshooting common errors, and formatting your output with the degree symbol (°).

Understanding Radians vs. Degrees

Before diving into the formulas, it helps to understand the relationship between these two units of measurement:

• Degree (°): A unit of measurement where a full rotation around a circle is divided into 360 equal parts.
• Radian (rad): A unit of measurement based on the radius of a circle. One radian is the angle subtended at the center of a circle by an arc equal in length to the radius. A full circle is 2π radians (approximately 6.28318 radians).

Because 360 degrees equals 2π radians, we can simplify this ratio to:

180 Degrees = π Radians

This fundamental mathematical relationship is the basis for both methods of conversion in Excel.

Method 1: Using the Built-In DEGREES Function

The easiest, most efficient, and highly recommended way to convert radians to degrees in Excel is by using the native DEGREES function. This function exists specifically to eliminate the need for manual mathematical equations.

Syntax

=DEGREES(angle)

Arguments

• angle: (Required) The angle in radians that you want to convert into degrees. This can be a hardcoded number, a cell reference containing a number, or another formula that returns a numeric value.

Step-by-Step Example

Let's say you have a radian value of 1.047197551 (which is equivalent to π/3) in cell A2, and you want to convert it to degrees in cell B2.

1. Click on cell B2.
2. Type the formula: =DEGREES(A2)
3. Press Enter.

Excel will instantly return the value 60, which is the equivalent angle in degrees.

Method 2: Using the Mathematical Formula (PI Function)

If you prefer to understand the underlying math or need to write a formula that is highly portable to other programming languages or legacy systems that might not support the DEGREES function, you can use basic algebra.

To convert radians to degrees manually, you multiply the radian value by 180 and then divide the result by π (pi). In Excel, π is represented by the PI() function, which returns the mathematical constant 3.14159265358979 accurate to 15 digits.

Syntax

=angle * 180 / PI()

Step-by-Step Example

Using the same value in cell A2 (1.047197551):

1. Select an empty cell (e.g., C2).
2. Input the following formula: =A2 * 180 / PI()
3. Press Enter.

Just like Method 1, this formula will yield the result of 60.

Comparison of Conversion Methods

Below is a quick reference table demonstrating both methods across common radian values:

Practical Application: Nesting Formulas with Trigonometric Functions

In real-world spreadsheets, you rarely convert standalone radian values. Instead, you typically use conversion formulas alongside Excel's built-in trigonometric and inverse trigonometric functions.

Example 1: Converting the Result of Arcsine (ASIN)

The ASIN function calculates the arcsine (inverse sine) of a number. If you input 0.5 into the ASIN function, Excel calculates the angle whose sine is 0.5. The output is provided in radians.

To get this result immediately in degrees, nest the ASIN function inside the DEGREES function:

=DEGREES(ASIN(0.5))

Result: 30 (representing 30 degrees).

Example 2: Finding an Angle from a Triangle's Sides

Imagine you have a right-angled triangle where the opposite side is in cell H2 (3 units) and the hypotenuse is in cell I2 (6 units). To find the angle in degrees using sine ratio (Opposite/Hypotenuse):

=DEGREES(ASIN(H2/I2))

This allows you to move seamlessly from raw geometric lengths to practical degree readings without intermediate conversion steps.

How to Display the Degree Symbol (°) in Excel

Once you convert your numbers to degrees, they will display as raw decimals or integers. To make your reports look professional, you can append the degree symbol (°) using two different approaches:

Approach A: Text Concatenation (Changes cell to Text)

You can force Excel to display the degree symbol by joining the formula output with the character code for degrees (CHAR(176)) or a hardcoded string:

=DEGREES(A2) & "°"

Note: This turns the cell value into a text string, meaning you cannot easily use this output in subsequent mathematical calculations.

Approach B: Custom Number Formatting (Preserves Numeric Value)

To keep the number as a functional numeric value while displaying the degree symbol visually, use custom formatting:

1. Select the cells containing your converted degree values.
2. Press Ctrl + 1 (Windows) or Cmd + 1 (Mac) to open the Format Cells dialog.
3. Go to the Number tab and select the Custom category.
4. In the Type text box, enter: 0"°" (or 0.0"°" if you want to display one decimal place).
5. Click OK.

Troubleshooting & Common Errors

If your formula isn't working as expected, check for these common issues:

• #VALUE! Error: This occurs if the cell you are referencing contains text instead of a number. Ensure there are no hidden spaces, letters, or special characters in your input cells.
• #NAME? Error: This typically happens if you misspell a formula name (e.g., typing DEGREE() instead of DEGREES(), or forgetting the parenthesis in PI()).
• Unexpectedly Large Outputs: If you convert a value that is already in degrees using the DEGREES function, Excel will attempt to convert it again, resulting in an unnaturally large number. Double-check whether your input source is truly in radians.

Summary: Going the Other Way

If you ever need to perform the reverse operation-converting degrees back into radians so you can plug them into Excel's SIN, COS, or TAN functions-Excel offers the inverse function: RADIANS.

=RADIANS(angle_in_degrees)
=angle_in_degrees * PI() / 180

By mastering both DEGREES and RADIANS, along with their mathematical equivalents, you can confidently tackle any trigonometric calculations in Microsoft Excel with precision and clarity.