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

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

Chart Showing Modified Bessel Function Yn(x) of Order 1
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

Occurs if either:

  • the supplied value of x is ≤ 0
  • the supplied value of n is < 0
#VALUE!-Occurs if any of the supplied arguments are non-numeric

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.

  +   Show How to Do This in Excel 2003:

  +   Show How to Do This in Excel 2007:

  +   Show How to Do This in Excel 2010 or Excel 2013: