BESSELI Function (LibreOffice Calc)

Mathematical Advanced LibreOffice Calc Introduced in LibreOffice 3.0
math bessel engineering physics differential-equations special-functions

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.

Compatibility

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.

Related Patterns and Alternatives

  • 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.

Copyright 2026. All rights reserved.