- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Engineering - BESSELJ Function
Description
The BESSELJ function returns the Bessel function Jn(x).
Syntax
BESSELJ(X, N)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
X | The value at which to evaluate the function. | Required |
N | The order of the Bessel function. If n is not an integer, it is truncated. | Required |
Notes
If x is nonnumeric, BESSELJ returns the #VALUE! Error value.
If n is nonnumeric, BESSELJ returns the #VALUE! Error value.
If n < 0, BESSELJ returns the #NUM! Error value.
The n-th order Bessel function of the variable x is −
$$J_n(x)=\sum_{k=0}^{\infty}\frac{(-1)^k}{K!\Gamma (n+K+1)}\left ( \frac{x}{2} \right )^{n+2k}$$
Where −
$$\Gamma (n+K+1)=\int_{0}^{\infty}e^{-n}x^{n+k}dx$$
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_engineering_functions.htm
Advertisements