Contact
12 programs
Explore the site

SQRTPI in ONLYOFFICE: Square Root of Pi Times a Number

Math and Trigonometry Beginner ONLYOFFICE Spreadsheet Editor

Understand SQRTPI(number), the pi-weighted square root, supported negative-input error, and reproducible examples.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in ONLYOFFICE Spreadsheet Editor. How formula examples are checked

Quick answer. =SQRTPI(number) computes the square root of π times its numeric argument: √(π × number). =SQRTPI(4) has the independently calculated expected result 3.54490770181, not √π plus 4. The official ONLYOFFICE reference documents this exact one-argument signature and explicitly states that a negative number returns #NUM!.

Verification: Examples are independently calculated mathematical expectations, not results observed in ONLYOFFICE.

Official syntax, argument, and defaults

=SQRTPI(number)
Argument (position) Required? Vendor description Default
number (1) Yes The numeric value to multiply by the pi constant before taking its square root None documented

No second/optional argument is documented. The vendor states that the pi constant used is approximately 3.14159265358979; mathematical examples below were independently checked using a high-precision value of π, so a displayed last digit may differ. The vendor expressly documents #NUM! for a negative numeric argument, but does not specify coercion for numeric-looking text, booleans or empty cells in this short reference.

Reproduce from a blank worksheet

  1. Create a new worksheet in ONLYOFFICE Spreadsheet Editor. In A1, type number and in B1 type sqrt(pi × number).
  2. Enter the six numeric values in A2:A7: 0, 1, 4, 9, 0.25, 100 (one number per row, in that order).
  3. In B2, enter =SQRTPI(A2). Fill the formula down through B7.
  4. Expected results, in order, are 0, 1.77245385091, 3.54490770181, 5.31736155272, 0.886226925453, and 17.7245385091. Compare several decimal places rather than demanding identical last digits.
  5. For an explicit documented error example, put −1 as a numeric value in A8 and type =SQRTPI(A8) in B8. The vendor specifically documents the #NUM! result for negative input; this is a documentation check, not an observed runtime test.

Formula-by-formula expected results

English-locale formula Expected result Independent reasoning / interpretation
=SQRTPI(0) 0 The radicand is 0×π.
=SQRTPI(1) 1.77245385091 The expected constant is √π.
=SQRTPI(4) 3.54490770181 The expected value is 2√π.
=SQRTPI(9) 5.31736155272 The expected value is 3√π.
=SQRTPI(0.25) 0.886226925453 The expected value is √π/2.
=SQRTPI(100) 17.7245385091 The expected value is 10√π.
=SQRTPI(2) 2.50662827463 The expected value is √(2π).
=1/SQRTPI(2) 0.398942280401 Normal-density peak factor.
=SQRTPI(4)/SQRTPI(1) 2 Ratio is √(4π)/√π.
=SQRTPI(16)/SQRTPI(4) 2 Positive radicals have a ratio of 2.
=SQRTPI(PI()) 3.14159265359 Mathematically √(π²)=π, subject to floating rounding.
=SQRTPI(A4) 3.54490770181 With A4=4 in the one-column input setup above.

Advanced examples and when the formula matters

Standard normal curve normalization. For a standardized normal density, its peak multiplier at zero is mathematically 1/√(2π). The formula =1/SQRTPI(2) is a compact way to express that factor, with expected value 0.398942280401. This says nothing about the range, precision, or statistical functions of a particular ONLYOFFICE installation.

Square root of circle area. If a circle has radius 3 units, its area is π × 3²; therefore =SQRTPI(3^2) returns the square root of the area, expected 5.31736155272 in units of length. This is not the radius and not the circumference. For circle area use =PI()*3^2 instead.

Mathematical simplification. For nonnegative n, SQRTPI(n)^2 = π×n in exact mathematics. A verification formula such as =SQRTPI(4)^2 should be close to =PI()*4, with small floating differences possible. Do not apply this identity to negative real inputs, where the documented #NUM! restriction applies.

Troubleshooting and limits

Symptom or trap Guidance
#NUM! on a negative numeric input Explicitly documented by ONLYOFFICE. SQRTPI is a real square-root function, so use nonnegative numbers for real results.
Formula returns an unexpected magnitude Check that you intended SQRT(PI()*number), not SQRT(PI())*number. The two differ unless number is 0 or 1.
Last displayed decimal differs from examples Output formatting and binary floating-point arithmetic may alter displayed precision. The vendor does not promise a given number of significant digits for this function.
Unknown function or translated name Confirm that your installed editor and chosen formula language expose the exact current English function; compare its version to the vendor help and changelogs.
Numeric-looking text, blank input, a boolean, or more than one argument The function page does not specify coercion or exact error messages for these conditions. Use true numeric cells and test locally; do not invent an error code.

Desktop, browser, historical releases, and locale accuracy

  • Documentation evidence, not native execution: The current English function catalogue lists the function and links to the signature described above. The documentation is for ONLYOFFICE Docs Spreadsheet Editor; it is not a function-by-function guarantee for every hosted Docs deployment or Desktop Editors version.
  • Desktop versus web: The Docs changelog and Desktop changelog are distinct release histories. Checked 2026-10-13 UTC, neither was used to establish the first-supported version of this function. Do not claim a minimum release number or tested parity without controlled execution on named versions.
  • Formula locale: The ONLYOFFICE function-entry guide demonstrates English function names, comma-separated arguments, parentheses, and an initial =. The regional settings guide documents configurable formula language, decimal/thousands separators, and region. These examples use English names, commas between arguments, and a dot for decimals. Recheck the user’s formula language and actual separator settings before copying to a localized workbook; no localized execution was performed.
  • Workbook formats: The presence of the formula in the help catalogue does not, by itself, verify Excel, Google Sheets, OpenDocument or earlier-format round trips. Avoid assuming that an identical spelling guarantees identical coercion, error codes or calculation precision elsewhere.
  • ONLYOFFICE SQRT computes an ordinary square root; =SQRT(PI()*4) has the same mathematical expectation as =SQRTPI(4).
  • ONLYOFFICE PI supplies the pi constant without arguments.
  • ONLYOFFICE POWER raises a base to a supplied power. These official reference URLs were checked on 2026-10-13 UTC.

Official sources and claims — verified 2026-10-13 UTC

Claim checked Official source What is—and is not—verified
Name, purpose, syntax, argument order ONLYOFFICE SQRTPI reference The vendor names this exact function; the English reference supplies its signature.
Presence in the current function menu ONLYOFFICE Insert Functions catalogue The function appears in a current, unversioned Docs list. This is documentation rather than execution evidence.
English entry and argument separators Inserting functions Documents typing =, function names, comma argument separators in English examples, and the Function Arguments wizard.
Locale and translated function names Spreadsheet Advanced Settings Documents configurable formula language and regional numeric separators; specific translated spellings were not verified.
Release-era limitations Docs changelog and Desktop changelog These document separate release tracks. First supported release of SQRTPI remains unconfirmed.

Verification limitations

Formula values are independently calculated mathematical expectations. Native ONLYOFFICE Desktop/web execution, localized parsing, undocumented coercion, error propagation and extreme-value precision were not tested.

Official references checked: 2026-10-13 UTC. Native release/edition testing: not performed.