The SQRTPI function returns the square root of the product of π (3.1415...) and a specified value.
This is a useful function in mathematics, especially in geometry and statistics.
Syntax
SQRTPI(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Value that is multiplied by Pi to calculate the square root |
Positive number or a reference to a cell containing a number |
Examples of use
Use with a constant
=SQRTPI(1)
This formula will return the value √(π × 1), which is approximately equal to 1.772.
Use with reference to cell
If cell A1 contains the number 6:
=SQRTPI(A1)
Result: approximately 4.34.
Notes
Make sure that the value argument is a positive number, otherwise the function will return the #NUM! error.