How to use the Excel DEGREES function

Summary

The Excel DEGREES function converts angles (expressed in radians) to degrees. For example, the formula =DEGREES(PI()) returns 180.

Purpose

Converts radians to degrees

Return value

Degrees

Syntax

=DEGREES (angle)

Arguments

angle - Angle in radians that you want to convert to degrees.

Usage notes

The DEGREES function takes an angle in radians and converts it to degrees.

Converting degrees to radians

Because Pi = 180°, you can use the general formula degrees * PI()/180 to get radians. For example, to convert 45° to radians, the Excel formula would be 45*PI( )/180 which equals 0.7854 radians. More examples in the table below:

Formula	Degrees
=2*PI()	360
=PI()	180
=90*PI()/180	90
=45*PI()/180	45
=30*PI()/180	30
=20*PI()/180	20

Related functions

Excel RADIANS Function

The Excel RADIANS function converts degrees to radians. For example, =RADIANS(360) returns 3.1415 (the value of Pi).

Excel PI Function

The Excel PI function returns the value of pi. For example, the formula =2*PI() * 3 returns the circumference of a circle with a radius of 3.

Good links

Microsoft DEGREES function documentation

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.