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.
