DEGREES function
DEGREES converts an angle from radians to degrees and returns the result as a number. It is often used to make trigonometry results easier to read.
Example
A
B
C
D
1
180
2
3
Syntax
DEGREES(angle)
-
angle(required) - An angle in radians.
Returns: The angle in degrees.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=DEGREES(0.5) | 28.64788976 | Positive |
=DEGREES(0) | 0 | Zero |
=DEGREES(-0.5) | -28.64788976 | Negative |
=DEGREES(2) | 114.591559 | Larger value |
=DEGREES("0.5") | 28.64788976 | Text number "0.5" |
=DEGREES(TRUE) | 57.29577951 | TRUE |
=DEGREES("abc") | #VALUE! | Non-numeric text |
=DEGREES(Data!E4) | #DIV/0! | Error cell propagates |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
1
5
2
abc
3
TRUE
4
=1/0
Data
Where it works
- Excel
- DEGREES is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .