Excel BESSELK Function
If you want to follow along with this tutorial, please download the example spreadsheet.
Description
The Excel BESSELK function returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
Syntax and arguments
Formula syntax
Arguments
|
Return Value
The BESSELK function returns a numeric value.
Remark
The n-th order modified Bessel function of the variable x is:
Where Jn and Yn are the J and Y Bessel functions respectively.
Error
1. If any arguments of BESSELK 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 modified Bessel function at 5 with an order of 2, please use the formula:
=BESSELK(B4,C4)
Or directly type the values in the function
=BESSELK(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 BESSELJ Function
The Excel BESSELJ function returns the Bessel function, for a specified value x and order.
-
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.
