EXCEL BESSELK FUNCTION

The Excel Besselk function computes modified Bessel functions, Kn(x), commonly known as hyperbolic Bessel Functions. These are the Bessel functions evaluated using entirely fictitious arguments.

Syntax :

=BESSELK ( x, n )

Parameters :

x – The point at which the function will be evaluated.
n – A positive number indicating the modified Bessel function’s order.
(If the provided value of n is a decimal, Excel truncates it to an integer.)

Example :

The order 1 modified Bessel function, K1, is seen in the graph above (x). If you wish to compute the value of this function at x = 0.05, use the Excel Besselk function as shown below:
=BESSELK(0.05, 1) yields the value 19.90967433.

  • #NUM!- Happens if either the provided value of x or the supplied value of n is 0.
  • #VALUE!- This error occurs if any of the given parameters are not numeric.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now