SQRTPI
Returns the positive square root of the product of Pi and the given positive number.
Sample Usage​
SQRTPI(9)
SQRTPI(A2)
Syntax​
SQRTPI(value)
value
- The number which will be multiplied by Pi and have the product's square root returnedvalue
must be positive; if it is negative,SQRTPI
will return the#NUM!
error.
Notes​
- To find the negative root of
value
* Pi, simply multiply the result of theSQRTPI
function call by-1
. SQRTPI
is used for certain types of analysis or as a component to other functions (e.g. an estimation of the Gamma function) and is rarely used by itself.
See Also​
SQRT
: Returns the positive square root of a positive number.
POWER
: Returns a number raised to a power.
LOG10
: Returns the logarithm of a number, base 10.
LOG
: Returns the logarithm of a number given a base.
LN
: Returns the logarithm of a number, base e (Euler's number).
GAMMALN
: Returns the logarithm of a specified Gamma function, base e (Euler's number).
EXP
: Returns Euler's number, e (~2.718) raised to a power.