The Excel BESSELY Function

Basic Description

The Excel Bessely function returns the Bessel function, Yn(x), (also known as the Weber function or the Neumann function), for a specified order and value of x.

The syntax of the function is :

BESSELY( x, n )

where the function arguments are as follows:

 x - The value at which the function is to be evaluated n - A positive integer, denoting the order of the Bessel function(If the supplied value of n is a decimal, it is truncated to an integer by Excel)

Bessely Function Example

Order 1 Bessel Function Yn(x)

The above chart on the right shows the order 1 Bessel function, Yn(x).

If you want to calculate the value of this function at x = 0.05, this can be done using the following formula:

=BESSELY( 0.05, 1 )

which gives the result -12.78985516.

Further examples of the Excel Bessely function can be found on the Microsoft Office website.

Bessely Function Errors

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

Common Errors
 #NUM! - Occurs if either:the supplied value of x is ≤ 0the 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. You will need to enable the add-in if you want to use the Excel engineering functions.