PI in WPS Spreadsheet: Use Pi in Circle and Angle Calculations

• Introduced: documented by 2019-06-10 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated. This is documentation evidence, not an installed-build guarantee.
• Scope: exact 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.

=PI()

Keep the parentheses even though there is no argument inside. The WPS lesson prints 3.14159265358979 and describes fourteen decimal places. That is a statement from the dated reference, not a new native precision benchmark or a guarantee about every current WPS build.

The examples use English names and ordinary numeric cells. PI returns a constant, rather than reading an angle or interpreting a unit label. Rounded expected outputs below are independent mathematical calculations using pi.

Put numeric 6 in A2, with a separate heading Radius. Use:

=2*PI()*A2
=PI()*A2^2

Expected results are approximately 37.699111843 for circumference and 113.097335529 for area. If radius is in centimeters, circumference is in centimeters and area is in square centimeters.

The radius factor must appear in the circumference formula. 2*PI() alone is approximately 6.283185307 and gives the circumference only for a unit-radius circle. Omitting the radius can produce a plausible-looking constant while answering the wrong geometric question.

For diameter 12 in C2:

=PI()*C2
=PI()*(C2/2)^2

These have the same expected circumference and area as the radius-six example. The first uses C=pi times diameter; the second converts diameter to radius before squaring.

Treating the diameter 12 as a radius instead would produce area approximately 452.389342117, four times the correct 113.097335529. The distinction is a model issue, not a precision or formatting problem.

For a circular ring with outer radius 5 and inner radius 3:

=PI()*(5^2-3^2)

Expected area: approximately 50.265482457, from 16 times pi. Subtract the squared radii inside the area formula. Squaring their difference would instead give 4 times pi, approximately 12.566370614, a different area.

The radii must use the same unit and describe concentric circles for this ring interpretation. PI does not inspect the physical geometry or decide whether an inner radius is valid.

A full turn measures 2*pi radians. For a 135-degree angle:

=135*PI()/180

Expected radians: approximately 2.356194490, or three quarters of pi. Conversely, =(PI()/3)*180/PI() has independently expected value 60 degrees.

Degrees and radians are different representations of an angle. The conversion factors follow the mathematical relationship; they do not imply that every WPS trigonometric function accepts degree inputs directly. Check the function-specific unit requirement before passing the converted value onward.

For a known area of 100 square units, =SQRT(100/PI()) has expected radius approximately 5.641895835. SQRT takes the positive square root after division by pi.

Substituting that full-precision radius into pi times radius squared reconstructs 100 in the mathematical model. Rounding the radius first can alter the reconstructed area, so keep numeric precision until the final display step.

A displayed 3.14 is not an instruction to replace PI with the literal 3.14. That approximation gives a radius-six circumference of 37.68, about 0.019111843 below the pi-based expectation.

The historical WPS lesson provides the zero-argument syntax and circle formula; the added controls are independent calculations. Current build support, last-bit precision, every imported formula and other WPS clients remain unverified. Validate the geometry and units separately from the formula’s arithmetic.

• WPS Academy: PI lesson, 2019-06-10 (Chinese; Windows Personal scope).
• Editorial testing standards.

The cited WPS product lesson was read directly. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.