BESSELI Excel Formula

Author Zaheer    Category Formulas     Tags , ,

There are a lot of helpful functions in Excel. For starter, an Excel function is an already written formula that takes a value and can perform an operation when inputted. These functions are simplified for easy use and application. These are also useful for long formulas when using Excel.

One of the useful functions is the BESSELI function which means Bessel Imaginary function. This function returns a solution to the first kind of the Bessel function which are pure imaginary numbers. The Bessel function can also be realistically be applied to heat conduction and electromagnetism.

The syntax or series of formula is BESSELI(x, n). Wherein X represents the value which will evaluate the function. The letter N in the syntax is the BESSELI function order; if the value of N is not an integer then it will be immediately changed to an integer if needed. After learning the syntax of the BESSELI function, you are now to interpret the values returned by BESSELI, which are in error. If one of the arguments is nonnumeric then the return error value is #VALUE. If the value is less than zero then the BESSELI function will return the #NUM!

First, click on the Tools on the menu bar and select Add-Ins. Once you have selected the Add-Ins find the list of Add-Ins Available and select the ToolPak box and hit OK. To view the formula and the formulas with the result you can press Ctrl + ` (grave accent). You can also view this by selecting the Formulas tab, select the Formula Auditing group, and then click the button which says Show Formula.

Take heed that if the value of the X is nonnumeric then the BESSELI formula will return the number which is an error. Same with the N, if its value is nonnumeric then the BESSELI formula will also return the value which is an error. In addition, if the value of N is lesser than zero the BESSELI formula will return the number error value.

The evaluation of the BESSELI function with imaginary numbers would be I(x) = (i) ^ (-n) J (ix). This means that l(x) is the modified Bessel function of N which is a linear independent solution. The I here represent the square root of -1. Moreover, J(ix) for the order of N it is the unmodified Bessel function which is for ix. Cos(nT-ixsinT) dT/pi is the integral of the order n which is over the zero interval to pi wherein the gamma function is T.

Try this example; open first a new document in Excel. Click on cell A1 and input the formula =BESSELI(1.5,1) the function will return to 0.981666. The evaluation of this BESSELI function is for xi and not x.

Post comment