BESSELJ Function
Returns the Bessel function Jn(x).
Category
Engineering
Available in
All versions, Microsoft 365
Returns
A number
Want to practice BESSELJ in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
BESSELJ returns the Bessel function of the first kind, Jn(x) — a wave-like curve that fades as x grows.
Bessel functions describe vibrations and waves in round things: a drum skin, a pipe, signals in a cable. J₀(x) first hits zero at x ≈ 2.4048, which sets a drum's lowest note.
Syntax
=BESSELJ(x, n) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value to evaluate the function at. |
| n | Yes | The order — a whole number of 0 or more. Decimals are dropped (2.7 is treated as 2). |
Examples
Example 1 — Values at different orders
Column A holds x and column B the order n. Results are rounded to 4 decimal places here.
C2fx=BESSELJ(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | x | n | BESSELJ |
| 2 | 1.9 | 2 | 0.3299 |
| 3 | 1 | 0 | 0.7652 |
| 4 | 2.5 | 1 | 0.4971 |
| 5 | 2.4048 | 0 | 0.0000 |
=BESSELJ(A2,B2) Explain
Common mistakes
- #NUM! n is negative.
- #VALUE! x or n is text.
Notes
- Excel calculates Bessel functions with a series approximation, so the last few of the 15 digits can differ slightly from scientific software.
- Related functions: BESSELY, BESSELI, BESSELK.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.