Excel Tutorial

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.

Excel RADIANS 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