- 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 - BESSELK Function
Description
The BESSELK function returns the modified Bessel function Kn(x), which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
These are also known as the hyperbolic Bessel Functions.
Syntax
BESSELK(X, N)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
X | The value at which to evaluate the function. | Required |
N | The order of the function. If n is not an integer, it is truncated. | Required |
Notes
If x is nonnumeric, BESSELK returns the #VALUE! Error value.
If n is nonnumeric, BESSELK returns the #VALUE! Error value.
If n < 0, BESSELK returns the #NUM! Error value.
The n-th order modified Bessel function of the variable x is −
$$K_n(x)=\frac{\pi}{2}i^{n+1}[J_n(ix)+iY_n(ix)]$$
Where Jn and Yn are the J and Y Bessel functions, respectively.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_engineering_functions.htm
Advertisements