SIN in WPS Spreadsheet: Calculate Sine with Explicit Angle Units

• Introduced: documented by 2019-05-14 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; its walkthrough mentions WPS 2019 without identifying a build.
• 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.

=SIN(number)

The WPS lesson explicitly requires a radian angle and recommends multiplying degrees by PI()/180 or using RADIANS. Put a unit in the source-column heading; the cell’s numeric value alone does not reveal which convention was intended.

Examples use English function names and comma separators. Decimal outputs are rounded independent expectations, rather than a promise of exact native floating-point digits.

Enter 0, 30, 90, 150 and −30 in A2:A6, with Degrees in A1. In B2 enter:

=SIN(A2*PI()/180)

Fill down through B6. Expected results are 0, 0.5, 1, 0.5 and −0.5. The 30- and 150-degree angles share a sine value, while negating 30 degrees negates its sine.

The equivalent formula =SIN(RADIANS(A2)) makes the conversion more explicit. See RADIANS for a separately documented conversion guide.

In a fictional right-triangle model, a segment has length 5 and makes a 65-degree angle with a horizontal base. Its vertical component is:

=5*SIN(65*PI()/180)

Expected height: approximately 4.531538935 in the same length unit. The segment length is the hypotenuse, so sine gives the opposite side divided by that length. Using the horizontal distance as though it were the hypotenuse would change the model.

The corresponding horizontal component is =5*COS(65*PI()/180), approximately 2.113091309. Their squared values add to 25 mathematically. Keep unrounded results if you perform that reconstruction.

Enter the fractions 0, 0.25, 0.5, 0.75 and 1 in D2:D6. They represent positions through one complete cycle. In E2 enter and fill down:

=10+3*SIN(2*PI()*D2)

The expected sequence is 10, 13, 10, 7 and 10. The constant 10 is the vertical offset; 3 is amplitude; 2*pi converts a cycle fraction into a radian phase.

The signal’s mathematical range is 7 through 13. Its midpoint is 10, not zero. A cycle fraction of one returns to the same mathematical phase as zero, although native calculations may leave a tiny residual near a theoretical zero.

To shift the signal by a quarter cycle, replace D2 with D2+0.25. The corresponding expected sequence becomes 13, 10, 7, 10 and 13. That is a phase shift, rather than a change in amplitude.

The original angles 30 and 150 degrees both produce sine 0.5. =ASIN(0.5)*180/PI() has expected principal result 30, not both possible angles. ASIN documents its restricted branch.

Consequently, SIN followed by ASIN does not recover every original angle. Preserve the angle or quadrant if the downstream task needs information that sine alone discards.

A radian input of 0.2 has expected sine approximately 0.198669331. The short mathematical approximation 0.2−0.2³/6 is approximately 0.198666667; its error is about 0.000002664. A close approximation is still different from the defined sine function.

Check units before diagnosing a discrepancy as precision. This reference does not establish every extreme-angle reduction, text conversion or current-build error rule. The walkthrough mentions WPS 2019, but that is historical context rather than a proven first-support date or current support range.

• WPS Academy: SIN lesson, 2019-05-14 (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.