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 :
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)
The 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:
which gives the result -12.78985516.
Further examples of the Excel Bessely function can be found on the Microsoft Office website.
If you get an error from the Excel Bessely function this is likely to be one of the following :
Occurs if either:
|#VALUE!||-||Occurs if any of the supplied arguments are non-numeric|
Occurs when Analysis ToolPak add-in is not enabled in your Excel.