BESSELI Function

Basic Description

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.

Syntax: 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)


Chart Showing Modified Bessel Functions, In(x), of Order 1, 2 and 3

Order 1, 2 & 3 Modified Bessel Functions In(x)


Besseli Function Example

The 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:

=BESSELI( 4.5, 1 )

which gives the result 15.38922293.


Besseli Function Errors

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
#NAME? Occurs when Analysis ToolPak add-in is not enabled in your Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment