Excel SQRTPI Function

What is SQRTPI Function in Excel?

The SQRTPI function is one of the math functions of Excel.

It Returns the square root of (number* Pi).

We can find this function in Math&trig of insert function Tab.

How to use SQRTPI function in excel

  1. Click on an empty cell (like F5 )
 empty cell in excel

2. Click on fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

fx icon in excel

4. Select math and trig category

5. Select SQRTPI function

6. Then select ok

excel SQRTPI function

7. In the function arguments Tab you will see SQRTPI function

8. Number section is the number by which p is multiplied

9. You will see results in the formula result section

How to use SQRTPI function in excel

Examples of SQRTPI function in excel

Example 1:

How to use SQRTPI function in excel

You can see examples of SQRTPI function below:

Examples of SQRTPI function in excel
sqrtpi(2) ----->>>>answer is  2.506

sqrtpi(5) ----->>>>answer is  3.963

sqrtpi(8) ----->>>>answer is  5.013

sqrtpi(10) ----->>>>answer is  5.604

sqrtpi(14) ----->>>>answer is  6.631

What is the purpose of SQRTPI function?

It Returns the square root of (number* Pi).

What is the Return value of SQRTPI function?

It returns a number.

How many arguments does SQRTPI function have?

This function has just 1 Argument.

The argument of SQRTPI function is number.

Number section is the number by which p is multiplied.

The argument of SQRTPI function is required and not optional.

SQRTPI(number) = number

Which version of excel supports SQRTPI function?

This function is available for all excel versions (2003-2019)

Errors in SQRTPI function

SQRTPI related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *