SQRTPI in Google Sheets: Square Roots of Pi-Scaled Values

• Introduced: first service launch date is not established by the official history reviewed; no numbered desktop introduction is assigned.
• Availability: documented in the rolling Google Sheets service. Examples use ordinary web-spreadsheet numeric cells; other clients and imported files are not separately certified.
• Checked: October 14, 2026; official SQRTPI reference. Documentation and independent calculations, without native Sheets execution.

=SQRTPI(value)

Google describes a positive input and explicitly says a negative input returns #NUM!. The dedicated page does not clearly resolve zero: its prose says positive, while the stated error condition refers to negative numbers. Zero is therefore not presented here as an established native boundary result.

Use a numeric value or numeric-cell reference. The worked examples stay strictly positive. Text conversion, extreme magnitudes and cross-client behavior have not been tested in Sheets.

Compare:

=SQRTPI(16)
=SQRT(16*PI())
=PI()*SQRT(16)

The first two independently expected results are approximately 7.089815404. The third is approximately 12.566370614. The difference is mathematical: √(16π)=4√π, while π√16=4π.

PI supplies the constant, and SQRT applies the ordinary square root. Writing the expanded formula is a useful check when SQRTPI is unfamiliar to a collaborator.

Enter 1, 4, 16 and 25 in A2:A5 and fill =SQRTPI(A2) down.

The values correspond to one, two, four and five times √π. Multiplying the input by four doubles the output; multiplying the input by two does not double it.

Changing display precision affects the shown decimal places, not the underlying operation. Keep calculations on numeric results rather than on manually retyped rounded text.

For a circle with area A, radius r satisfies A=πr². Its circumference is C=2πr, which simplifies to C=2√(Aπ).

For an area of 36 square units:

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

The independently expected circumference is approximately 21.269446211 units; the radius is approximately 3.385137501 units. Check the circumference another way with =2*PI()*SQRT(36/PI()).

The input to SQRTPI in the first formula is area, not radius or diameter. If the area is measured in square meters, the resulting circumference is measured in meters. A radius of 36 meters would be a completely different input problem.

Areas nine and 36 differ by a factor of four. Their SQRTPI results are approximately 5.317361553 and 10.634723105, so the second is twice the first.

In an exact mathematical model, squaring the result and dividing by pi recovers the input:

=SQRTPI(36)^2/PI()

The expected value is 36. This identity explains the calculation; it does not promise that every native floating-point reconstruction will display an identical last bit. Use an appropriate numeric tolerance rather than presenting this review as an exhaustive precision test.

Google explicitly recommends negating SQRTPI’s result when the negative root is needed. =-SQRTPI(16) has independently expected result approximately -7.089815404. The input stays positive; supplying -16 is not a way to request the negative root and instead falls under the documented #NUM! rule.

The guide intentionally does not claim a result for zero or certify exact errors for text. Confirm those boundaries in the actual destination Sheets environment if the workbook relies on them. For the ordinary real-valued geometric examples, validate that the source area is positive before interpreting the result.

• Google SQRTPI help.
• Editorial testing standards.

Inputs are fictional. Approximate numerical answers are independently calculated mathematical expectations rounded to nine places, not captured native results. Complete coercion, extreme-magnitude and cross-client behavior remain untested.