BESSELJ Function

Basic Description

The Excel Besselj function returns the Bessel function, Jn(x), for a specified order and a given value of x.

Syntax: BESSELJ( x, n )

where the function arguments are:

x The value at which the function is to be evaluated
n The order of the Bessel function (must be a positive integer)

(If the supplied value of n is a decimal, Excel truncates this value to an integer)


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

Order 1, 2 & 3 Bessel Functions, Jn(x)


Besselj Function Example

The chart on the right shows the Bessel functions, Jn(x), of order 1, 2 and 3.

The value of any of these functions at a given value of x, can be evaluated using the Excel Besselj function.

For example, the order 1 Bessel function, at x=2.5 is calculated by the following:

=BESSELJ( 2.5, 1 )

This gives the result 0.497094103.


Besselj Function Errors

If you get an error from the Excel Besselj 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