ExcelFlux

BESSELK function

the modified Bessel function Kn(x).

Engineering

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Compare Modified Bessel K values by argument and order. Keep the order an integer.

A worked example from the workbook

RowAB
6ArgumentOrder
710
821
932
Record 1
=BESSELK(A7,B7)

Expected result0.4210244382

See the inputs and instructions for all 3 examples

Syntax

BESSELK(X, N)

Copyable formulas

English Excel · en-US
=BESSELK(A7,B7)
Turkish Excel · tr-TR
=BESSELK(A7;B7)

Worked examples

Compare Modified Bessel K values by argument and order. Keep the order an integer.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Argument Order
7 1 0
8 2 1
9 3 2
Case Formula Expected result
Record 1 =BESSELK(A7,B7) 0.4210244382
Record 2 =BESSELK(A8,B8) 0.1398658818
Record 3 =BESSELK(A9,B9) 0.06151045847
Microsoft Excel reference