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
- Click on an empty cell (like F5 ).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Engineering category.
5. Select BESSELY function.
6. Then select ok.
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.
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.32Purpose 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)
