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

ArgumentRequired?What it does
xYesThe value to evaluate the function at.
nYesThe 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)
ABC
1xnBESSELJ
21.920.3299
3100.7652
42.510.4971
52.404800.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.
Kyle Stott

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.