Excel RADIANS Function
The Excel RADIANS function converts an angle measured in degrees into angle measured in radians.
The RADIANS function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the RADIANS function can be used as part of a formula in a worksheet cell.
Syntax
RADIANS(angle)
Parameters
angle |
Required. Specify an angle in degrees. |
Return Value
Returns the angle measured in radians.
Notes
- If the argument is a non-numeric value, RADIANS returns #VALUE! error.
Example: Using as Worksheet Function
The example below shows how to use the RADIANS function as worksheet function.
Based on the Excel spreadsheet above, the output of the following worksheet formula will be:
=RADIANS(B5) Result: 0 =RADIANS(B6) Result: 0.785 =RADIANS(B7) Result: 1.571 =RADIANS(B8) Result: 2.356 =RADIANS(B9) Result: 3.142 =RADIANS(B10) Result: 3.927 =RADIANS(B11) Result: 4.712 =RADIANS(B12) Result: 5.498 =RADIANS(B13) Result: 6.283
Example: PI() Function
A half-rotation (180°) in radians is equal to 3.142.. or 𝜋. A full-rotation (360°) in radians is equal to 6.283.. or 2𝜋. To get the value of 𝜋, Excel PI function can be used.
=RADIANS(180) Result: 3.14159265358979 =PI() Result: 3.14159265358979 =(RADIANS(180) = PI()) Result: TRUE
Example: Converting Radians to Degrees
An angle in radians can be converted into degrees by multiply it by 180/PI() or by using the DEGREES function. For example, to convert 2 radians into degrees, the following formula can be used:
=2 * 180/PI() Result: 114.591559026165 =DEGREES(2) Result: 114.591559026165
❮ Excel Functions