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.

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)

 

Chart Showing Modified Bessel Function Yn(x) of Order 1

Order 1 Bessel Function Yn(x)

 

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:

=BESSELY( 0.05, 1 )

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.

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>

*

code

clearPost Comment