
π This article includes 1 downloadable practice file β
In this article
DEGREES converts radians back to degrees.
Syntax
=DEGREES(angle)
| Argument | What it means |
|---|---|
angle |
In radians. |
Examples
Example 1
=DEGREES(ATAN(B2/A2))
Slope angle of a ramp from rise and run.
DEGREES in practice
Where you will use it
- Convert ATAN or ACOS results to degrees
- Roof pitch from rise and run
- Angles for charts
Worked example
| Radians | Formula | Result |
|---|---|---|
| 3.141592654 | =ROUND(DEGREES(A2),2) | 180 |
| 0.785398163 | =ROUND(DEGREES(A3),2) | 45 |
| 1 | =ROUND(DEGREES(A4),2) | 57.3 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Using it on degrees | DEGREES converts FROM radians |
| Rounding errors | ROUND for display |
Related functions
π Part of the free Excel course: Beginner β Expert Β· Try it in the Formula Lab or ask the AI Helper.
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
π Practice files for this article
- πPractice workbook: Math & rounding24 tasks on realistic sales data β type your formula, the Check column turns green when it is right. Answers sheet included.β¬ XLSX Β· 35 KB
Free to use for learning. Files with macros (.bas) are plain text β import them with Alt+F11 β File β Import File, and always test on a copy.
Atul (AJ) builds office-automation and local-first AI tools as Atulya AI, and works with Excel, SAP and Oracle EPM every day. He writes about the shortcuts, macros and automations that actually save time β plus the occasional wacky fact. Videos on YouTube: Lazy Automator AI (@LazyAutomatorAI).
More posts by Atul βBuild this skill next
This page is a quick function reference. Use it for syntax, then practise the function in a broader workflow.
Stuck on a step? Ask a question and the AI answers using this article.