Excel BESSELY Function

What is BESSELY function in Excel?


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

It Returns the Bessel function Yn(x).

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

How to use BESSELY 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 BESSELY function.

6. Then select ok.

excel BESSELY function

7. In the function arguments Tab you will see BESSELY 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 BESSELY function in excel

Examples of BESSELY function in Excel

Example 1:

How to use BESSELY function in excel

You can see examples of BESSELY function below:

bessely(A2,B2) ----->>>>answer is  -87.14

bessely(A3,B3) ----->>>>answer is  -0.55

bessely(A4,B4) ----->>>>answer is  0.39

bessely(A5,B5) ----->>>>answer is  0.01

bessely(A6,B6) ----->>>>answer is  0.32

Purpose of BESSELY function

It Returns the modified Bessel function In(x).

Return value of BESSELY function

It returns a number.

Arguments of BESSELY function

This function has just 2 Argument.

The argument of BESSELY 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 BESSELY function is required and not optional.

BESSELY(number) = number

Version of excel supports BESSELY function

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

Errors in BESSELY function

BESSELY related functions 

Leave a Reply

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