June 18, 2021

# How to use BESSELY Function in Excel

The BESSELY () is an engineering function which takes x, n as argument and returns the Bessel function, Yn(x) for a specified order and value of x.

Syntax: BESSELY(X, N)

The BESSELY function syntax has the following arguments:

• X    Required. The value at which to evaluate the function.
• N    Required. The order of the function. If n is not an integer, it is truncated.

Example: Let’s look at some Excel BESSELY function examples and explore how to use the BESSELY function as a worksheet function in Microsoft Excel:

Syntax:  =BESSELY(A2,B2)

Result:

Based on the Excel spreadsheet above, the following BESSELY examples would return:

Syntax: =BESSELY(A3,B3)
Result: -0.412308627

Syntax: =BESSELY(A4,B4)
Result: -0.781212821

Syntax: =BESSELY(A5,B5)
Result: -0.107032432

Syntax: =BESSELY(A6,B6)
Result: -0.412308627

Syntax: =BESSELY(A7,B7)
Result: 0.146267163

Syntax: =BESSELY(A8,B8)
Result: -12.78985516

Syntax: =BESSELY(A9,B9)
Result: #NUM!

Syntax: =BESSELY(A10,B10)
Result: #NUM!

Note:

• If x is nonnumeric, BESSELY returns the #VALUE! error value.
• If n is nonnumeric, BESSELY returns the #VALUE! error value.
• If n < 0, BESSELY returns the #NUM! error value.
• The n-th order Bessel function of the variable x is:

READ:  How to use DELTA Function in Excel

#### Excel

View all posts by Excel →