BESSELK function
BESSELK evaluates the modified Bessel function of the second kind, found in heat-flow and field problems. The x value must be positive or it returns #NUM!.
Example
Read it as a sentence: find the modified Bessel function Kn(x) at x of 1 with order 0.
A
B
C
D
1
0.421024421083418
2
3
Syntax
BESSELK(x, n)
-
x(required) - The value at which to evaluate the function.
-
n(required) - The order of the function; truncated to an integer, must be 0 or greater.
Returns: The modified Bessel function Kn(x).
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=BESSELK(1.5,1) | 0.277387804 | X 1.5, n 1 |
=BESSELK(1.5,0) | 0.213805569 | N 0 |
=BESSELK(1.5,2.9) | 0.583655974 | N 2.9 truncates |
=BESSELK(100,1) | 4.67985E-45 | Large x |
=BESSELK("1.5","1") | 0.277387804 | Text number |
=BESSELK({0.5,1,2},1) | 1.656441128 | Spill |
=BESSELK(1.5,-1) | #NUM! | N negative |
=BESSELK(0,1) | #NUM! | X 0 |
Watch out for
- x must be positive or you get #NUM!.
Where it works
- Excel
- BESSELK is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .