BESSELK Function (LibreOffice Calc)
The BESSELK function returns the modified Bessel function of the second kind, Kₙ(x). It is used in engineering, physics, probability, and differential equation modeling involving exponential decay and cylindrical symmetry.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✖ |
| Libreoffice | ✔ |
| Numbers | ✖ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the BESSELK Function Does ▾
- Computes Kₙ(x), the modified Bessel function of the second kind
- Supports real values of x > 0
- Supports integer orders n
- Used in heat transfer, diffusion, EM fields, and probability distributions
Syntax ▾
BESSELK(x; n)
Arguments
-
x:
The input value (real number > 0). -
n:
The order of the Bessel function (integer ≥ 0).
Basic Examples ▾
Compute K₀(x)
=BESSELK(1; 0)
→ 0.421024438
Compute K₁(x)
=BESSELK(2; 1)
→ 0.113893872
Using a cell reference
=BESSELK(A1; B1)
Advanced Examples ▾
Heat conduction in cylindrical coordinates
=BESSELK(r / k; 0)
Radial diffusion model
=BESSELK(A1 * B1; 1)
Probability: Laplace distribution kernel
=BESSELK(ABS(A1); 0)
Combine with BESSELI for general solutions
=C1 * BESSELI(A1; 0) + C2 * BESSELK(A1; 0)
Normalize for large x (avoid underflow)
=BESSELK(A1; 0) * EXP(A1)
Use in modified Bessel differential equation
=BESSELK(A1; 1) + A1 * BESSELK(A1; 0)
Edge Cases and Behavior Details ▾
BESSELK returns a numeric value
Accepts:
- Real x > 0
- Integer n ≥ 0
Behavior details
- Order n must be an integer
- Kₙ(x) → ∞ as x → 0⁺
- Kₙ(x) → 0 as x → ∞
- K₀(x) has a logarithmic singularity at x = 0
- BESSELK decays exponentially for large x
Invalid input → Err:502
BESSELK of an error → error propagates
Common Errors and Fixes ▾
Err:502 — Invalid argument
Cause:
- x ≤ 0
- n is not an integer
- Non-numeric input
Fix:
- Ensure x > 0
- Wrap n with INT()
- Validate numeric input
Underflow for large x
Cause:
- Kₙ(x) becomes extremely small
Fix:
- Multiply by EXP(x) to stabilize
Best Practices ▾
- Use BESSELK for exponential-decay and radial-diffusion models
- Combine with BESSELI for full differential-equation solutions
- Normalize large x values to avoid underflow
- Use INT(n) to enforce integer order
- Pair with EXP, LN, and POWER for analytic transformations
BESSELK is essential for modeling diffusion, heat transfer, EM fields, and any system governed by modified Bessel differential equations with exponential decay.
Related Patterns and Alternatives ▾
- Use BESSELI for complementary modified Bessel solutions
- Use BESSELJ and BESSELY for ordinary Bessel functions
- Use EXP, LN, and POWER for analytic transformations
By mastering BESSELK and its companion functions, you can build powerful engineering, physics, and mathematical models in LibreOffice Calc.