How to use BESSELI Function in Excel

The BESSELI function returns the modified Bessel function In (x), which is equivalent to the Bessel function evaluated for purely imaginary arguments.

Syntax: BESSELI( xn )

The BESSELI function syntax has the following arguments:

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

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

BESSELI Function - How to use BESSELI Function in Excel

Syntax:  =BESSELI(A2,B2)

Result:

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

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

Syntax: =BESSELI(A3,B3)
Result: 2.516716242

Syntax: =BESSELI(A4,B4)
Result: 0.565159098

Syntax: =BESSELI(A5,B5)
Result: 1.590636857

Syntax: =BESSELI(A6,B6)
Result: 1.590636857

Syntax: =BESSELI(A7,B7)
Result: 0.688948449

Syntax: =BESSELI(A8,B8)
Result: 0.981666428

Syntax: =BESSELI(A9,B9)
Result: -0.981666428

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

Note:

  • If x is nonnumeric, BESSELI returns the #VALUE! error value
  • If n is nonnumeric, BESSELI returns the #VALUE! error value
  • If n < 0, BESSELI returns the #NUM! error value
  • The nth order modified Bessel function of the variable x is:  BESSELI Function in Excel - How to use BESSELI Function in Excel
READ:  How to use ERFC Function in Excel

Add a Comment

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