The Excel Besseli function calculates the modified Bessel functions, In(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:
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). |
The above chart on the right shows the order 1, 2 and 3 modified Bessel functions, In(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:
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:
#NUM! | - | Occurs if the supplied value of n is < 0. |
#VALUE! | - | Occurs if any of the supplied arguments are non-numeric. |