Excel BESSELJ Function

If you want to follow along with this tutorial, please download the example spreadsheet.
Description
The Excel BESSELJ function returns the Bessel function, for a specified value x and order.
Syntax and arguments
Formula syntax
Arguments
|
Return Value
The BESSELJ function returns a numeric value.
Remark
The n-th order Bessel function of the variable x is:
where
is the Gamma function.
Error
1. If any arguments of BESSELJ function are nonnumeric values, #VALUE! value will be returned.
2. If argument n is less than zero, #NUM! value will be returned.
Version
Excel 2003 and later
Usage and Examples
Example
To calculate the Bessel function at 5 with an order of 2, please use the formula:
=BESSELJ(B4,C4)
Or directly type the values in the function
=BESSELJ(5,2)
Press Enter key to get the result.
Relative Functions:
Excel BESSELI Function
The Excel BESSELI function calculates the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
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.