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.