Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > SQRTPI
 

SQRTPI(number)

 
 Returns the square root of a number multiplied by PI.

 numberThe number by which PI is multiplied.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• If "number" < 0, then #NUM! is returned.
     
  		• If "number" is not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=SQRTPI(4) = 3.545
    2=SQRT(4*PI()) = 3.545
    3=SQRTPI(16) = 7.090
    4=SQRT(16*PI()) = 7.090
    5=SQRTPI(2) = 2.507
    6=SQRTPI(0) = 0
    7=SQRTPI(-10) = #NUM!
    8=SQRTPI("some text") = #VALUE!
    		 
     Functions - S | Index - S | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top