Sunday, 23 April 2017

Excel - Microsoft Excel Sqrtpi Function

Description

The Excel SQRTPI function returns the square root of a supplied number multiplied by p. 
I.e. 

SQRTPI( number ) = SQRT( number * p ) 

The syntax of the Sqrtpi function is :

SQRTPI( number ) 

Where the number argument is a positive numeric value, to multiply by pi, before calculating the square root. 

Sqrtpi Function Examples
The following spreadsheet shows four examples of the sqrtpi function. 

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 


Sqrtpi Function Errors
If you get an error from the Excel Sqrtpi Function, this is likely to be one of the following: 

Common Errors 

No comments:

Post a Comment