ExcelFunctions.net

Search Site:

The Excel Besseli function calculates the
modified Bessel functions, I_{n}(x), (also known as the hyperbolic Bessel Functions).
These functions are the equivalent of the
Bessel functions,
evaluated for purely imaginary arguments.

The syntax of the Besseli function is:

BESSELI( x, n )

where the function arguments are:

x | - | The value at which the function is to be evaluated. |

n | - |
A positive integer, representing the order of the function. (If the supplied value of n is a decimal, this is truncated to an integer by Excel). |

Order 1, 2 & 3 Modified Bessel Functions I

The above chart on the right
shows the order 1, 2 and 3 modified Bessel functions, I_{n}(x).

If you want to calculate the value of the order 1 modified Bessel function at x = 4.5, this can be done using the Excel Besseli function, as follows:

=BESSELI( 4.5, 1 )

which gives the result *15.38922293*.

See the Microsoft Office website for further details on the Excel Besseli function.

If you get an error from the Excel Besseli function this is likely to be one of the following:

Common Errors

#NUM! | - | Occurs if the supplied value of n is < 0. |

#VALUE! | - | Occurs if any of the supplied arguments are non-numeric. |