EXCEL BESSELY FUNCTION

For a given order and value of x, the Excel Bessely function yields the Bessel function, Yn(x), (also known as the Weber function or the Neumann function).

Synatax :

=BESSELLY ( x, n )

Parameters :

x – The point at which the function will be evaluated.

n – A positive number indicating the Bessel function’s order.

(If the provided value of n is a decimal, Excel truncates it to an integer.)

Examples :

The order 1 Bessel function, Y1, is depicted in the chart on the right (x). If you wish to determine the value of this function for x = 0.05, use the Excel formula =BESSELY(0.05, 1), which yields-12.78985516.

  • #NUM! – Occurs when either the supplied value of x or the supplied value of n is 0.
  • #VALUE! – This error occurs if any of the supplied parameters is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now