SQRTPI Excel function is a Math and Trigonometry formula that can calculate and return the square root of a number multiplied by pi (π, the constant number). The multiplication with pi when using this formula occurs before taking the square root of the number argument. In this guide, we’re going to show you how to use the SQRTPI Excel function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
SQRTPI Excel Function Syntax
SQRTPI(number)
Arguments
| number | The positive numeric value that you want to multiply by pi, before calculating the square root of the product. |
Example
The SQRTPI function requires only a single argument, number, which is essentially the number to be multiplied by pi, and its square root to be calculated. Please note that you must enter a positive number for to run function without any errors. You can use a static value, a cell reference, or the result of another formula.
Tips
- =SQRTPI(number) is equal to =SQRT(number * PI())
- If you have a negative number, use the ABS function in conjunction to eliminate the direction of the number. For example,
=SQRTPI(ABS(A1))
- Although this function doesn't see frequent use, the SQRTPI function can be helpful to normalize the area under a bell curve. There is a discussion page on the chandoo.org forums about other sample use cases.
Issues
- The function will return a #NUM! error if the number is negative.
