BESSELI function
BESSELI evaluates the modified Bessel function of the first kind. It shows up in physics and signal-processing models, rarely in business work, and a negative order returns #NUM!.
Example
Read it as a sentence: find the modified Bessel function In(x) at x of 1 with order 1.
A
B
C
D
1
0.565159097581943
2
3
Syntax
BESSELI(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 In(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 |
|---|---|---|
=BESSELI(1.5,1) | 0.981666428 | X 1.5, n 1 |
=BESSELI(1.5,0) | 1.646723202 | N 0 |
=BESSELI(1.5,2.9) | 0.337834621 | N 2.9 truncates |
=BESSELI(0,1) | 0 | X 0 |
=BESSELI(-1.5,1) | -0.981666428 | X negative |
=BESSELI(100,1) | 1.06837E+42 | Large x |
=BESSELI(1.5,-1) | #NUM! | N negative |
=BESSELI("a",1) | #VALUE! | Text |
Watch out for
- A negative n gives #NUM!.
- Non-numeric input gives #VALUE!.
Where it works
- Excel
- BESSELI 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 .