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:

BESSELY Function - How to use BESSELY Function in Excel

Syntax:  =BESSELY(A2,B2)

Result:

BESSELY Function in Excel 1 - How to use BESSELY Function in Excel

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: BESSELY Function in Excel - How to use BESSELY Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *