Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Engineering > BESSELK
 

BESSELK(x, n)

 
 Returns the modified Bessel function represented by K(x).

 xThe value at which to evaluate the function.
 nThe order of the function.

 REMARKS
 
  		• In Excel 2007 (and later) this function has been removed from the Analysis ToolPak add-in and is available as standard.
     
  		• In Excel 2003 this function is only available when you have the Analysis ToolPak add-in loaded.
     
  		• In Excel 2007 the accuracy of this function has changed because the internal workings now use built-in functions to calculate the trigonometric operations.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "x" < 0, then #NUM! is returned.
     
  		• If "n" is not an integer, it is truncated.
     
  		• If "n" < 0, then #NUM! is returned.

     EXAMPLES
     
     A
    1=BESSELK(1,1) = 0.602
    2=BESSELK(1,2) = 1.625
    3=BESSELK(2,1) = 0.140
    4=BESSELK(2,2) = 0.254
    5=BESSELK(1.5,1) = 0.277
    6=BESSELK(1.5,1.9) = 0.277
    7=BESSELK(-1.5,1) = #NUM!
    8=BESSELK(1.5,-1) = #NUM!
    9=BESSELK("some text",1) = #VALUE!
    10=BESSELK(1.5,"some text") = #VALUE!
    		 
     Functions - B | Index - B | Office Online 2013 | 2010 | 2007 | 2003 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013