BESSELK Function

Returns the modified Bessel function Kn(x).

Category

Engineering

Available in

All versions, Microsoft 365

Returns

A number

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

BESSELK returns the modified Bessel function of the second kind, Kn(x). It starts very large near zero and decays towards zero.

It's paired with BESSELI in heat-transfer and diffusion problems, such as heat loss from cooling fins.

Syntax

=BESSELK(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=BESSELK(A2,B2)
ABC
1xnBESSELK
21.510.2774
3100.4210
4200.1139
=BESSELK(A2,B2) Explain

Common mistakes

  • #NUM! n is negative, or x is 0 or less (the function is undefined there).
  • #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: BESSELI, BESSELY, BESSELJ.
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.