SQRTPI()

Syntax. SQRTPI(number)

Definition. This function returns the root of a number multiplied by pi.

Argument

  • number (required) The number by which pi is multiplied

Background. The SQRTPI() function calculates the root of a positive number multiplied by pi. If number is less than zero, the function returns the #NUM! error. The following applies:

image with no caption

Examples. Some examples for this function are:

  • =SQRTPI(12) returns 6.13996025.

  • =SQRTPI(5) returns 3.9633273.

See Also

PI(), SQRT()

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.