BESSELY Function

Returns the Bessel function Yn(x) (Weber or Neumann function).

Category

Engineering

Available in

All versions, Microsoft 365

Returns

A number

Want to practice BESSELY in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

BESSELY returns the Bessel function of the second kind, Yn(x). It heads to minus infinity near zero, then oscillates like BESSELJ.

Engineers combine it with BESSELJ when a problem has a hole in the middle — for example heat flow through the wall of a pipe.

Syntax

=BESSELY(x, n) Explain

Arguments

ArgumentRequired?What it does
xYesThe value to evaluate the function at.
nYesThe order — a whole number of 0 or more. Decimals are dropped (2.7 is treated as 2).

Examples

Example 1 — Values at different orders

Column A holds x and column B the order n. Results are rounded to 4 decimal places here.

C2fx=BESSELY(A2,B2)
ABC
1xnBESSELY
22.510.1459
3100.0883
4300.3769
=BESSELY(A2,B2) Explain

Common mistakes

  • #NUM! n is negative, or x is 0 or less (the function is undefined there).
  • #VALUE! x or n is text.

Notes

  • Excel calculates Bessel functions with a series approximation, so the last few of the 15 digits can differ slightly from scientific software.
  • Related functions: BESSELJ, BESSELK, BESSELI.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.