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