Excel BESSELI Function
If you want to follow along with this tutorial, please download the example spreadsheet.
Description
The Excel BESSELI function calculates the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
Syntax and arguments
Formula syntax
Arguments
|
Return Value
The BESSELI function returns a numeric value.
Remark
The n-th order modified Bessel function of the variable x is:
Error
1. When any arguments of BESSELI function are nonnumeric values, #VALUE! value will be returned.
2. When argument n is less than zero, #NUM! value will be returned.
Version
Excel 2003 and later
Usage and Examples
Example
To calculate the modified Bessel function at 5 with an order of 2, please use the formula:
=BESSELI(B4,C4)
Or directly type the values in the function
=BESSELI(5,2)
Press Enter key to get the result.
Relative Functions:
-
Excel DEC2BIN Function
The Excel DEC2BIN function converts a decimal number to a binary number.
-
Excel DEC2HEX.S Function
The Excel DEC2BIN function converts a decimal number to a hex number.
-
Excel DEC2OCT Function
The Excel DEC2OCT function converts a decimal number to an octal number
-
Excel HEX2DEC Function
The Excel HEX2DEC function converts a hexadecimal number to a decimal integer number.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
