EXCEL BESSELI FUNCTION

The modified Bessel functions, In(x), are calculated by the Excel Besseli function (also known as the hyperbolic Bessel Functions). These functions are similar to the Bessel functions when evaluated for totally fictitious arguments.

Syntax:

=BESSELI( xn )

Parameter:

  • The function parameters are as follows:

X:

  • The parameter at which the function will be evaluated.

n:

  • A positive integer denoting the function’s orde 

               (If the given value of n is a decimal, Excel truncates it to an integer.)

Example:

The graphic on the right depicts the modified Bessel functions of orders 1, 2, and 3. (x).
If you wish to determine the value of the order 1 modified Bessel function at x = 4.5, use the Excel Besseli function as shown below:

=BESSELI( 4.5, 1 )

which gives the result 15.38922293.

  • NUM! – Occurs if the value of n given is 0.
  • VALUE! – This error occurs if any of the provided parameters are not numbers.

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