BESSELK Function in Excel: Modified Bessel Function Kn(x)

BESSELK Function in Excel: Modified Bessel Function Kn(x) 1
⏱ 1 min readUpdated 5 October 2026

EngineeringLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. BESSELK in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

BESSELK returns the modified Bessel function of the second kind, Kn(x).

Advertisement

Syntax

=BESSELK(x, n)
Argument What it means
x Positive value
n Order

Examples

Example 1

=ROUND(BESSELK(A2,B2),5)

Result: 0.27739. See the worked example table below for more cases.

BESSELK in practice

Where you will use it

  • Heat and diffusion problems
  • Electromagnetics
  • Engineering coursework

Worked example

xnFormulaResult
1.51=ROUND(BESSELK(A2,B2),5)0.27739
20=ROUND(BESSELK(A3,B3),5)0.11389
32=ROUND(BESSELK(A4,B4),5)0.06151

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
x of 0 or less#NUM!
Negative n#NUM!

BESSELI

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZOR Function in Excel: TRUE When Any Condition Is MetExcel Functions A–ZAND Function in Excel: TRUE Only When All Conditions Are MetExcel Functions A–ZIF Function in Excel: Make Decisions in a Formula
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong