Excel functions / Math
RADIANS function
Turns degrees into radians, which is what SIN, COS and TAN take.
Syntax
=RADIANS(angle)
Arguments
angle: The angle in degrees.
When to use it
RADIANS turns an angle in degrees into radians, which is what SIN, COS and TAN expect. A full turn is 360 degrees or 2π radians, so 180 degrees is π.
DEGREES goes the other way, and is what you wrap round ASIN, ACOS and ATAN to read their answers in degrees.
Examples
Half a turn
A B C 1 Degrees 2 180 3.1416 In C2:
=RADIANS(A2)→ 3.1416The cosine of 60 degrees
A B C 1 Degrees 2 60 0.5 In C2:
=COS(RADIANS(A2))→ 0.5
Common mistakes
- Converting twice. RADIANS is for angles in degrees. An angle that is already in radians, such as PI()/2, must not be converted again.
- Forgetting it altogether. COS(60) is not 0.5. Whenever the angle comes from a protractor or a drawing, it is in degrees.
RADIANS 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: RADIANS
- Danish: RADIANER
- Dutch: RADIALEN
- Finnish: RADIAANIT
- French: RADIANS
- German: BOGENMASS
- Hungarian: RADIÁN
- Italian: RADIANTI
- Norwegian: RADIANER
- Polish: RADIANY
- Portuguese (Brazil): RADIANOS
- Portuguese (Portugal): RADIANOS
- Russian: РАДИАНЫ
- Spanish: RADIANES
- Swedish: RADIANER
- Turkish: RADYAN