DEGREES Function

Converts radians to degrees.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

An angle in degrees

Want to practice DEGREES in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

DEGREES turns radians — what ASIN, ACOS, ATAN and ATAN2 return — into degrees people can read.

π radians is 180 degrees.

Syntax

=DEGREES(angle) Explain

Arguments

ArgumentRequired?What it does
angleYesAn angle in radians.

Examples

Example 1 — Readable angles

Radians converted to degrees.

B2fx=DEGREES(A2)
AB
1RadiansDegrees
23.14159265358979180
31.570796326794990
4157.2958
=DEGREES(A2) Explain

Example 2 — Angle of a ramp

A ramp rises 1 m over 12 m.

=DEGREES(ATAN(1/12)) Explain

About 4.8°.

Common mistakes

  • Already in degrees? Applying DEGREES twice gives nonsense. Only convert results of the inverse trig functions.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.