Excel functions / Math
DEGREES function
Turns radians into degrees.
Syntax
=DEGREES(angle)
Arguments
angle: The angle in radians.
When to use it
DEGREES turns an angle in radians into degrees. The inverse trigonometric functions (ASIN, ACOS, ATAN, ATAN2) answer in radians, so DEGREES is what makes their results readable.
Examples
π radians is half a turn
A B C 1 Radians 2 =PI() 180 In C2:
=DEGREES(A2)→ 180The angle whose tangent is 1
A B C 1 Tangent 2 1 45 In C2:
=DEGREES(ATAN(A2))→ 45
Common mistakes
- Converting twice. An angle already in degrees must not go through DEGREES again.
DEGREES in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DEGREES
- Danish: GRADER
- Dutch: GRADEN
- Finnish: ASTEET
- French: DEGRES
- German: GRAD
- Hungarian: FOK
- Italian: GRADI
- Norwegian: GRADER
- Polish: STOPNIE
- Portuguese (Brazil): GRAUS
- Portuguese (Portugal): GRAUS
- Russian: ГРАДУСЫ
- Spanish: GRADOS
- Swedish: GRADER
- Turkish: DERECE
Related functions
- RADIANS: Turns degrees into radians, which is what SIN, COS and TAN take.
- ATAN2: The angle, in radians, from the x-axis to the point (x, y). Unlike ATAN it knows which quarter of the circle the point is in.
- ASIN: The angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
- PI: The number π (3.14159…).