Excel BESSELK function

What is BESSELK function in Excel?


The BESSELK function is one of the Engineering functions of Excel.

It Returns the modified BESSELK function Kn(x).

We can find this function in Engineering of insert function Tab.

How to use BESSELK function in excel

  1. Click on an empty cell (like F5 ).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Engineering category.

5. Select BESSELK function.

6. Then select ok.

excel BESSELK function

7. In the function arguments Tab you will see BESSELK function.

8. X section is the value at which to evaluate the function.

9. N section is the order of the Bessel function.

10. You will see the results in the formula result section.

How to use BESSELK function in excel

Examples of BESSELK function in Excel

Example 1:

How to use BESSELK function in excel

You can see examples of BESSELK function below:

Examples of BESSELK function in Excel
besselk(A2,B2) ----->>>>answer is  71.867

besselk(A3,B3) ----->>>>answer is  0.036

besselk(A4,B4) ----->>>>answer is  0.154

besselk(A5,B5) ----->>>>answer is  0.0006

besselk(A6,B6) ----->>>>answer is  0.040

Purpose of BESSELK function

It Returns the modified BESSELK function Kn(x).

Return value of BESSELK function

It returns a number.

Arguments of BESSELK function

This function has just 2 Argument.

The argument of BESSELK function is number.

X section is the value at which to evaluate the function.

N section is the order of the Bessel function.

The argument of BESSELK function is required and not optional.

BESSELK(number) = number

Version of excel supports BESSELK function

This function is available for all excel versions (2003-2019)

Errors in BESSELK function

BESSELK related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *