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.
Syntax: 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
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.
Bessely Function Errors
If you get an error from the Excel Bessely function this is likely to be one of the following :
|#NUM!||–||Occurs if either the supplied value of x is ≤ 0 or 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.|