Today I’m going to show you how to use an another engineering function in Excel. This new function is called Besselj. It returns the Bessel function Jn(x).
Syntax of the function is BESSELJ(x,n). So we need to input two parameters (x and n) for this function. Both are required to return a value. When you input those two arguments, function will be evaluated at x. And n is the order of the Bessel function. You can use this function in Excel like this.
Here I have used cell addresses to input the arguments. But you can also use values directly like this as well.
So now let’s find the Jn(x) values for x values from -5 to 5 when the order of the function is 1.
If we draw a graph of Jn(x) for the above values it will look like this.
If we change the order of the Bessel function to 2, then we will get the following result.
This is the graph for the above table.
