How to Change Google Sheets from Radians to Degrees (2024)

Google Sheets Radians to Degrees

In Google Sheets, to convert radians to degrees, you can use the formula:

‍

=DEGREES(angle_in_radians)

‍

This formula takes an angle in radians as the input and returns its equivalent in degrees. 

How to Change Google Sheets from Radians to Degrees

Follow the steps below to easily convert radians to degrees in Google Sheets. 

1. Select a Cell for Conversion

For our example, the radian values that we want to convert to degrees are listed under column A. Click on cell B2. This is where you'll input the formula to convert the first radian value from cell A2.

2. Enter the Conversion Formula

In cell B2, type =DEGREES(A2). This formula converts the radian value in cell A2 from radians to degrees.

3. Execute the Formula

Press Enter to apply the formula. Cell B2 will now display the conversion of 0.785 radians (a quarter turn) into degrees.

4. Copy the Formula for Multiple Conversions

To convert the rest of the radian values, click on cell B2 again. Then drag the fill handle (the small square at the bottom-right corner of cell B2) down through to cell B9. This action copies the formula to each cell, automatically adjusting the formula to reference the correct cell in column A.

5. Verify the Converted Values

Review the degree values in column B to ensure they accurately reflect the conversion from the radians listed in column A. Each cell from B2 to B9 should now show the degrees equivalent of the radians from A2 to A9.

We hope that you now have a better understanding of how to change Google Sheets from radians to degrees. If you enjoyed this article, you might also like our article on the NPV formula in Google Sheets or our article on setting up Google Sheets dot product.