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
| 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=BESSELK(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | x | n | BESSELK |
| 2 | 1.5 | 1 | 0.2774 |
| 3 | 1 | 0 | 0.4210 |
| 4 | 2 | 0 | 0.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.

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.