RADIANS in WPS Spreadsheet: Convert Degree Angles Without Losing Turns

• Introduced: documented by 2019-05-31 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated in the edition metadata.
• Scope: exact current supported builds remain unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no native WPS test was performed.

=RADIANS(angle)

The WPS lesson defines angle as the degree value to convert. RADIANS changes the numeric representation of the angle; it does not merely attach a unit label.

Examples use English function names and ordinary numeric cells. Rounded displayed expectations below are separate from native precision or format settings. Use DEGREES for the opposite direction.

Enter 0, 30, 90, 180, 360 and −45 in A2:A7. Put Degrees in A1, then enter =RADIANS(A2) in B2 and fill down.

The 360-degree value becomes 2*pi, rather than zero. Conversion does not erase the number of complete turns represented by the input.

=SIN(RADIANS(30))

Expected result: 0.5. The inner function converts 30 degrees; the outer SIN receives the radian value it requires.

A separate =SIN(30) call would mean 30 radians. Double conversion is also wrong: if a cell already contains pi/6 radians, use SIN on that value directly rather than passing it through RADIANS again.

For 450 degrees:

=RADIANS(450)

Expected result: approximately 7.853981634, or 5*pi/2 radians. The orientation is equivalent to 90 degrees after one full turn, but the accumulated rotation is larger.

If the task explicitly asks for a nonnegative orientation within one turn, a separate policy can use =RADIANS(MOD(450,360)), giving pi/2, approximately 1.570796327. The normalization comes from MOD, not from RADIANS itself.

The distinction matters in a record of rotations: throwing away complete turns can lose meaningful information even when a trigonometric function produces the same final orientation.

In a mathematical circle of radius 6 units, an arc subtends 75 degrees. Arc length equals radius times the radian angle:

=6*RADIANS(75)

Expected arc length: approximately 7.853981634 units. Multiplying six directly by 75 would omit the required degree conversion and give an unrelated value.

The corresponding sector area is =0.5*6^2*RADIANS(75), approximately 23.561944902 square units. Radius is squared for area but not for arc length. Keep the output units visible.

For a fictional constant rate of 120 revolutions per minute, the angular rate in radians per second is:

=RADIANS(120*360)/60

Expected result: approximately 12.566370614 radians per second. The factor 360 converts revolutions to degrees before RADIANS; division by 60 changes the time denominator from minutes to seconds.

This unit calculation does not infer an actual device’s operating limits. It simply shows that an angle conversion and a time conversion are separate steps.

=DEGREES(RADIANS(-45)) has mathematical expectation −45 degrees. Keep full-precision intermediate values instead of retyping a rounded −0.7854.

The direct WPS lesson documents the conversion, but not every current build’s text coercion, extreme-magnitude handling or native error labels. A degree symbol embedded in imported text is not automatically the same as the numeric input used in these controls.

• WPS Academy: RADIANS lesson, 2019-05-31 (Chinese; Windows Personal scope).
• Editorial testing standards.

The direct WPS product lesson supports the stated function scope. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.