November 30, 2023

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 BIN2DEC Function in Excel

Leave a Reply

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