BESSELJ function
BESSELJ evaluates the ordinary Bessel function of the first kind, which is used for wave and vibration problems. It returns a #NUM! error if the order is negative.
Example
Read it as a sentence: find the Bessel function Jn(x) at x of 1 with order 0.
A
B
C
D
1
0.765197683754859
2
3
Syntax
BESSELJ(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 Bessel function Jn(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 |
|---|---|---|
=BESSELJ(1.5,1) | 0.557936508 | X 1.5, n 1 |
=BESSELJ(1.5,0) | 0.511827671 | N 0 |
=BESSELJ(1.5,2.9) | 0.232087679 | N 2.9 truncates |
=BESSELJ(0,1) | 0 | X 0 |
=BESSELJ(-1.5,1) | -0.557936508 | X negative |
=BESSELJ(100,1) | -0.077145352 | Large x |
=BESSELJ(1.5,-1) | #NUM! | N negative |
=BESSELJ("a",1) | #VALUE! | Text |
Watch out for
- A negative n gives #NUM!.
Where it works
- Excel
- BESSELJ 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 .