BESSELY Function in Excel: Bessel Function Yn(x)

BESSELY Function in Excel: Bessel Function Yn(x) 1
⏱ 1 min readUpdated 5 October 2026

EngineeringLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. BESSELY in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

BESSELY returns the Bessel function of the second kind (Weber/Neumann), Yn(x).

Advertisement

Syntax

=BESSELY(x, n)
Argument What it means
x Positive value
n Order

Examples

Example 1

=ROUND(BESSELY(A2,B2),5)

Result: 0.14592. See the worked example table below for more cases.

BESSELY in practice

Where you will use it

  • Wave problems with two solutions
  • Acoustics
  • Coursework

Worked example

xnFormulaResult
2.51=ROUND(BESSELY(A2,B2),5)0.14592
10=ROUND(BESSELY(A3,B3),5)0.08826
52=ROUND(BESSELY(A4,B4),5)0.36766

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
x of 0 or less#NUM!
Negative n#NUM!

BESSELJ

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZRANK.EQ Function in Excel: Rank a Number in a ListExcel Functions A–ZDETECTLANGUAGE Function in Excel: Which Language Is This?Excel Functions A–ZCHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong