SQRTPI in WPS Spreadsheet: Take the Square Root of a Pi-Scaled Value

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

=SQRTPI(number)

The official June 2019 WPS Windows Personal lesson states that a negative argument returns #NUM!. The examples stay strictly positive to keep the real square-root model clear. Zero’s mathematical value is zero, but a separate native zero-boundary test was not performed.

The function’s name does not mean pi multiplied by a square root taken earlier. Keep pi inside the root in the expanded expression. English names and ordinary numeric cells are used throughout.

=SQRTPI(9)
=SQRT(9*PI())
=PI()*SQRT(9)

The first two expected results are approximately 5.317361553. The third is approximately 9.424777961. Mathematically, the first expression is 3 times the square root of pi, while the last is 3 times pi.

PI provides the constant and SQRT provides the ordinary positive root. The expanded formula is useful when explaining SQRTPI’s grouping to another reader.

Put numeric 1, 4, 9, 16 in A2:A5 and fill:

=SQRTPI(A2)

Expected values, rounded to nine decimals, are 1.772453851, 3.544907702, 5.317361553 and 7.089815404. They equal one, two, three and four times the square root of pi.

Multiplying the input by four doubles the output. This is a square-root scaling relationship, not a linear relationship between the input and result. Doubling the input alone does not double the result.

For a circle of area A, its radius is the square root of A/pi. Substituting that radius into circumference 2pir gives 2*SQRTPI(A).

For area 25 square units:

=2*SQRTPI(25)
=SQRT(25/PI())

Expected circumference is approximately 17.724538509 length units, and expected radius is approximately 2.820947918 length units. The circumference can be checked independently with =2*PI()*SQRT(25/PI()).

The SQRTPI argument in the circumference expression is area, not radius. Entering radius 25 as though it were area 25 would answer a different problem. Keep the units in headings so square units and length units remain distinct.

Areas 4 and 16 differ by a factor of four. Their SQRTPI values are approximately 3.544907702 and 7.089815404, whose ratio is two.

=SQRTPI(16)/SQRTPI(4)

Independent expected result: 2. Multiplying both results by two to obtain corresponding circumferences preserves the same ratio. Geometric size scaling should be checked before treating a larger area as a proportionally identical change in perimeter.

In the exact mathematical model:

=SQRTPI(9)^2/PI()

Expected result: 9. Squaring removes the square root and division by pi recovers the input. Native floating-point evaluation may differ in its last digits, so this identity is an independent reasoning check rather than a promise of bit-for-bit reconstruction.

To represent the negative mathematical root of 9*pi, negate the positive result: =-SQRTPI(9) has expected value approximately -5.317361553. A negative input is a different operation and falls under the lesson’s historical #NUM! rule.

The historical source does not establish every current WPS build, text conversion, extreme-magnitude behavior or cross-client error. Its explicit negative-input rule is retained with that limited scope rather than expanded into a universal compatibility claim.

Check parentheses, numeric input type and geometric units before diagnosing a disagreement as a precision issue. Keep the unrounded result for later arithmetic; retyping a short decimal approximation can create an avoidable reconstruction difference.

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