Excel Tutorial

Excel DEGREES Function



The Excel DEGREES function converts an angle measured in radians into angle measured in degrees.

The DEGREES function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the DEGREES function can be used as part of a formula in a worksheet cell.

Syntax

DEGREES(angle)

Parameters

angle Required. Specify an angle in radians.

Return Value

Returns the angle measured in degrees.

Notes

  • If the argument is a non-numeric value, DEGREES returns #VALUE! error.

Example: Using as Worksheet Function

The example below shows how to use the DEGREES function as worksheet function.

Excel DEGREES function

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=DEGREES(C5)
Result: 0

=DEGREES(C6)
Result: 45

=DEGREES(C7)
Result: 90

=DEGREES(C8)
Result: 135

=DEGREES(C9)
Result: 180

=DEGREES(C10)
Result: 225

=DEGREES(C11)
Result: 270

=DEGREES(C12)
Result: 315

=DEGREES(C13)
Result: 360

Example: Converting Degrees to Radians

A half-rotation (180°) in radians is equal to 3.142.. or 𝜋. An angle in degrees can be converted into radians by multiply it by PI()/180 or by using the RADIANS function. For example, to convert 60 degrees into radians, the following formula can be used:

=60 * PI()/180
Result: 1.0471975511966

=RADIANS(60)
Result: 1.0471975511966

❮ Excel Functions