BESSELI Function

Returns the modified Bessel function In(x).

Category

Engineering

Available in

All versions, Microsoft 365

Returns

A number

Want to practice BESSELI 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

BESSELI returns the modified Bessel function of the first kind, In(x). Instead of oscillating, it grows steadily, like an exponential.

It shows up in heat-transfer and electromagnetics problems, and in statistics (the von Mises distribution for angles).

Syntax

=BESSELI(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=BESSELI(A2,B2)
ABC
1xnBESSELI
21.510.9817
3101.2661
4202.2796
=BESSELI(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: BESSELK, BESSELJ, BESSELY.
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.