Contact
12 programs
Explore the site

BESSELI Function (LibreOffice Calc)

Mathematical Advanced LibreOffice Calc Introduction not established

The BESSELI function returns the modified Bessel function of the first kind, Iₙ(x). It is used in engineering, physics, signal processing, and differential equation modeling.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **BESSELI** function returns the **modified Bessel function of the first kind**, denoted Iₙ(x). This special function appears in engineering, physics, probability, and solutions to differential equations involving cylindrical or radial symmetry.

What the BESSELI Function Does

  • Computes Iₙ(x), the modified Bessel function of the first kind
  • Supports real values of x
  • Supports integer orders n
  • Used in heat transfer, wave propagation, diffusion, and statistical distributions

Syntax

BESSELI(x; n)

Arguments

  • x:
    The input value (real number).

  • n:
    The order of the Bessel function (integer ≥ 0).

Basic Examples

Compute I₀(x)

=BESSELI(1; 0)
→ 1.266065878

Compute I₁(x)

=BESSELI(2; 1)
→ 1.590636855

Using a cell reference

=BESSELI(A1; B1)

Advanced Examples

Engineering: cylindrical heat conduction

=BESSELI(R / K; 0)

Probability: Rice distribution component

=BESSELI(A1 * B1; 0)

Differential equation solution (modified Bessel form)

=EXP(-A1) * BESSELI(A1; 0)

Compute a series expansion approximation

=BESSELI(A1; 0) + BESSELI(A1; 1)

Normalize for large x to avoid overflow

=BESSELI(A1; 0) / EXP(A1)

Use with BESSELK for complementary solutions

=BESSELI(A1; 1) + BESSELK(A1; 1)

Edge Cases and Behavior Details

BESSELI returns a numeric value

Accepts:

  • Real x
  • Integer n ≥ 0

Behavior details

  • Order n must be an integer
  • For large x, BESSELI grows exponentially
  • For x = 0:
    • I₀(0) = 1
    • Iₙ(0) = 0 for n > 0
  • BESSELI is always non‑negative for real x

Invalid input → Err:502

BESSELI of an error → error propagates

Common Errors and Fixes

Err:502 — Invalid argument

Cause:

  • n is not an integer
  • x or n is non-numeric

Fix:

  • Wrap n with INT()
  • Validate numeric input

Overflow or extremely large values

Cause:

  • BESSELI grows exponentially for large x

Fix:

  • Normalize using EXP: BESSELI(x; n) / EXP(x)

Best Practices

  • Use BESSELI for modified Bessel solutions in engineering and physics
  • Normalize large x values to avoid overflow
  • Combine with BESSELK for full solution sets
  • Use INT(n) to enforce integer order
  • Use EXP and LN for stable transformations
BESSELI is essential for modeling diffusion, heat transfer, cylindrical systems, and any problem involving modified Bessel differential equations.
  • Use BESSELJ for ordinary Bessel functions
  • Use BESSELK for modified Bessel functions of the second kind
  • Use BESSELY for Bessel functions of the second kind
  • Use EXP, LN, and POWER for analytic transformations

By mastering BESSELI and its companion functions, you can build powerful engineering, physics, and mathematical models in LibreOffice Calc.