Engineering

Built-in functions › Spreadsheet formulas › Engineering

33 functions in this category.

Engineering

Function	What it does
airy	Airy function Ai(z) or Bi(z) (and derivatives).
besseli	Modified Bessel function of the first kind, I_n(x).
besselj	Bessel function of the first kind, J_n(x).
besselk	Modified Bessel function of the second kind, K_n(x).
bessely	Bessel function of the second kind, Y_n(x).
beta	Beta function B(a, b).
betainc	Incomplete beta function (regularized).
betaincinv	Inverse of the regularized incomplete beta function.
betaln	Natural log of the beta function.
bin2dec	Convert a binary string to a decimal number.
bin2hex	Convert a binary string to a hexadecimal string.
bin2oct	Convert a binary string to an octal string.
bitand	Bitwise AND of two integers.
bitlshift	Left bit-shift.
bitor	Bitwise OR of two integers.
bitrshift	Right bit-shift.
bitxor	Bitwise XOR of two integers.
ellipj	Jacobi elliptic functions sn, cn, dn.
ellipke	Complete elliptic integrals of the first and second kind.
erf	Error function.
erfc	Complementary error function 1 - erf(x).
erfcinv	Inverse complementary error function.
erfcx	Scaled complementary error function exp(x²) · erfc(x).
erfinv	Inverse error function.
expint	Exponential integral E_n(x).
gamma	Gamma function Γ(x).
gammainc	Lower incomplete gamma function (regularized).
gammaincinv	Inverse of the regularized incomplete gamma function.
gammaln	Natural logarithm of the gamma function, ln(|Γ(x)|).
hankel	Hankel function, H_nu^(k)(z) = J_nu(z) ± i Y_nu(z).
hermite	Hermite polynomial H_n(x).
legendre	Associated Legendre functions P_n^m(x).
polygamma	Polygamma function ψ^(k)(x).