Documentation/Calc Functions/BESSELY

Function name:
BESSELY

Category:
Add-in

Summary:
Calculates the value of a Bessel function of the second kind, usually referred to as Yn(x). n is the order of the function and x is the value at which the function is to be calculated.

Syntax:
BESSELY(X; N)

Returns:
Returns a real number which is the value of the Bessel function of the second kind, with a specified order, for a given value of x.

Arguments:
X is a positive real number, or a reference to a cell containing that number, which is the value at which the Bessel function of the second kind is to be calculated.

N is a non-negative integer, or a reference to a cell containing that number, which is the order of the Bessel function of the second kind.


 * If either X or N is non-numeric, then BESSELY reports a #VALUE! error.
 * If X is not greater than 0, then BESSELY reports an invalid argument error (Err:502).
 * If N is a non-integer value, then BESSELY truncates it to an integer.
 * If N is negative, then BESSELY reports an invalid argument error (Err:502).

Details specific to BESSELY function
The following figure shows a plot of the Bessel functions of the second kind for orders 0, 1, 2, and 3. Bessel functions of the second kind are singular at the origin, x = 0.

ODF 1.2 indicates that the first argument to the BESSELY function should be an integer. However, this is considered an unnecessary limitation and Calc’s implementation caters for positive real values of X.

Related LibreOffice functions:
BESSELI

BESSELJ

BESSELK

ODF standard:
Section 6.16.15, part 2

Equivalent Excel functions:
BESSELY