Exceljet

Quick, clean, and to the point

Excel DEGREES Function

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

500 Formula Examples, thoughtfully explained.