DEGREES in WPS Spreadsheet: Convert Radian Results to Readable Angles

• Introduced: documented by 2019-06-11 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.

=DEGREES(angle)

The WPS lesson defines angle as a radian value. Do not pass a value that is already measured in degrees unless you intentionally want to interpret that number as radians.

The lesson explicitly demonstrates DEGREES(PI()). Its walkthrough mentions Excel while the course metadata identifies WPS Office for Windows Personal. That narrative wording is not used here as proof of universal Excel/WPS equivalence.

Enter the following controls in separate cells:

=DEGREES(0)
=DEGREES(PI()/6)
=DEGREES(PI()/2)
=DEGREES(PI())
=DEGREES(-PI()/4)

Expected degree results are 0, 30, 90, 180 and −45. Use PI() rather than typing a short approximation such as 3.14 if subsequent arithmetic depends on the conversion.

A numeric radian input of one gives =DEGREES(1), approximately 57.295779513 degrees. One radian and one degree are different angle sizes.

=DEGREES(ASIN(0.5))
=DEGREES(ACOS(0.5))
=DEGREES(ATAN(1))

Expected outputs are 30, 60 and 45 degrees. Each inner function returns its own principal radian angle. DEGREES converts that result; it does not change the branch selected by the inverse function.

The input 0.5 is a ratio for ASIN or ACOS, not a degree angle. Converting the ratio before applying the inverse function would change the calculation.

For a circle of radius 2 units and an arc length of 3 units, the radian angle is arc length divided by radius:

=DEGREES(3/2)

Expected angle: approximately 85.943669270 degrees. Arc length and radius must use the same length unit so their ratio is dimensionless.

For the same radius, a complete circumference is 4*pi units. =DEGREES((4*PI())/2) has expected result 360 degrees, a full-turn control for the model.

=DEGREES(5*PI()/2)
=DEGREES(-3*PI())

Expected results are 450 and −540 degrees. DEGREES is a unit conversion, not an automatic reduction to an orientation between zero and 360.

For a separately stated nonnegative-orientation policy, =MOD(DEGREES(5*PI()/2),360) has mathematical result 90. The loss of complete turns is caused by MOD and is intentional only if the task wants orientation rather than accumulated rotation.

A fictional angular rate of pi/2 radians per second corresponds to:

=DEGREES(PI()/2)

Expected result: 90 degrees per second when the original quantity’s per-second unit is retained. To express the same rate in degrees per minute, multiply by 60, giving 5400.

DEGREES does not change seconds into minutes. Conversion of an angle’s unit and conversion of the time denominator must be handled explicitly, even when both are stored as plain numbers in a worksheet.

=RADIANS(DEGREES(0.75)) has mathematical expectation 0.75 radians. Use the full calculated intermediate result when checking; rounding it for display is different from manually replacing it with a shortened value.

Check whether a source is already in degrees, whether its value is numeric and whether an inverse function’s branch is appropriate. See RADIANS, ASIN and ATAN2 for the corresponding input and direction conventions.

The selected lesson does not establish complete current-build error, imported-type or extreme-value behavior. All worked outputs are independent mathematical expectations from the documented conversion.

• WPS Academy: DEGREES lesson, 2019-06-11 (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.