How to use BESSELJ Function in Excel

The BESSELJ function returns the Bessel function Jn(x).

Syntax: =BESSELJ(X, N)

The BESSELJ function syntax has the following arguments:

  • x: required.  This is the value at which to evaluate the function
  • n: also required.  This represents the order of the Bessel function.  If n is not an integer, it is truncated accordingly.

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

Syntax:  =BESSELJ(A2,B2)

Result:

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

Syntax: =BESSELJ(A3,B3)
Result: 0.114903485

Syntax: =BESSELJ(A4,B4)
Result: 0.576724808

Syntax: =BESSELJ(A5,B5)
Result: 0.576724808

Syntax: =BESSELJ(A6,B6)
Result: 0.477685497

Syntax: =BESSELJ(A7,B7)
Result: 0.352834208

Syntax: =BESSELJ(A8,B8)
Result: 0.329925829

Syntax: =BESSELJ(A9,B9)
Result: -0.557936508

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

Note:

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

Add a Comment

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