Excel’s trig functions work in radians, not degrees — the #1 gotcha. Wrap your angle in RADIANS first, and you can compute heights, distances, and angles.
The example
SIN(30°) = 0.5.
| A | B | |
|---|---|---|
| 1 | Angle | SIN |
| 2 | 30° | 0.5 |
| 3 | 90° | 1.0 |
The formula
The formula:
How it works
How it works:
- Excel’s
SIN,COS,TANexpect the angle in radians. - Wrap a degree value in
RADIANS(degrees)first —SIN(RADIANS(30))= 0.5. - To convert a radian result back to degrees, use
DEGREES(radians). - Inverse functions (
ASIN,ACOS,ATAN) return radians — wrap them in DEGREES for a degree answer.
Forgetting RADIANS is the classic error. =SIN(30) computes the sine of 30 radians (about −0.99), not 30 degrees. Always convert degree inputs first, and use DEGREES on inverse results.
Try it: interactive demo
Angle in degrees.
Variations
Inverse (degrees)
Angle from a ratio:
Triangle height
opp = hyp×sin:
Pi
Constant:
Pitfalls & errors
RADIANS first. Trig functions use radians; feed degrees through RADIANS or the result is wrong.
TAN at 90°. Tangent is undefined at 90° (cos = 0) and returns a huge number.
Inverse returns radians. Wrap ASIN/ACOS/ATAN in DEGREES for a degree answer.
Practice workbook
Frequently asked questions
How do I use SIN, COS, TAN with degrees in Excel?
Why is SIN(30) wrong?
How do I get an angle in degrees from ASIN?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class