SQRTPI
TheSQRTPI
function returns the square root of the product of a supplied number (value) and pi (3.14159265359). This function is useful in geometry and trigonometry calculations where the area and circumference of circles are used.
 How to use
SQRTPI
formula?  Examples of using
SQRTPI
formula SQRTPI
formula not working? Similar formulas to
SQRTPI
Usage
Use the SQRTPI
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The number to be multiplied by pi and then the square root taken.
Examples
Here are a few example use cases that explain how to use theSQRTPI
formula in Google Sheets.
Calculate the circumference of a circle
To calculate the circumference of a circle, multiply the diameter by pi. The SQRTPI
function can be used to simplify this calculation by taking the square root of the product of the diameter and pi: =2*SQRTPI(diameter/2)
.
Calculate the area of a circle
To calculate the area of a circle, square the radius and multiply by pi. The SQRTPI
function can be used to simplify this calculation by taking the square root of the product of the radius squared and pi: =SQRTPI(radius^2)
.
Calculate the standard deviation of a set of values
The SQRTPI
function can be used to calculate the standard deviation of a set of values. The formula for the standard deviation is the square root of the variance. The variance is the average of the squared differences from the mean. Therefore, the standard deviation can be calculated as follows: =SQRTPI(AVERAGE((values  AVERAGE(values))^2))
.
Common Mistakes
SQRTPI
not working? Here are some common mistakes people make when using the SQRTPI
Google Sheets Formula:
Not multiplying the input by pi
One common mistake when using the SQRTPI
function is forgetting to multiply the input by pi before taking the square root.
Providing a negative input
The SQRTPI
function only works with positive inputs. Providing a negative input will result in an error.
Related Formulas
The following functions are similar to SQRTPI
or are often used with it in a formula:

PI
The
PI()
function returns the value of pi to 10 decimal places, which is approximately 3.1415926536. This function is often used in geometry and trigonometry calculations. 
SIN
The
SIN
function in Google Sheets returns the sine of a given angle in radians. Sine is a mathematical function that describes a smooth repetitive oscillation. It is commonly used in trigonometry, physics, and engineering to model phenomena such as waves, oscillations, and periodic motion. 
COS
The
COS
function in Google Sheets returns the cosine of an angle provided in radians. It is commonly used in trigonometry to calculate the cosine of an angle. The function takes one parameter, the angle in radians.
Learn More
You can learn more about the SQRTPI
Google Sheets function on Google Support.