engineering functions
unit conversion, bases, complex numbers and bitwise operations.
| function | signature | what it does | tests |
|---|---|---|---|
| BESSELI | BESSELI(x, n) | returns modified Bessel function In(x) | — |
| BESSELJ | BESSELJ(x, n) | returns Bessel function Jn(x) | — |
| BESSELK | BESSELK(x, n) | returns modified Bessel function Kn(x) | — |
| BESSELY | BESSELY(x, n) | returns Bessel function Yn(x) | — |
| BIN2DEC | BIN2DEC(number) | converts binary number to decimal | 1 |
| BIN2HEX | BIN2HEX(number, [places]) | converts binary number to hexadecimal | — |
| BIN2OCT | BIN2OCT(number, [places]) | converts binary number to octal | — |
| BITAND | BITAND(number1, number2) | returns bitwise AND of two numbers | 1 |
| BITLSHIFT | BITLSHIFT(number, shift_amount) | returns number shifted left by bits | — |
| BITOR | BITOR(number1, number2) | returns bitwise OR of two numbers | — |
| BITRSHIFT | BITRSHIFT(number, shift_amount) | returns number shifted right by bits | — |
| BITXOR | BITXOR(number1, number2) | returns bitwise XOR of two numbers | — |
| COMPLEX | COMPLEX(real_num, i_num, [suffix]) | converts real and imaginary to complex | 2 |
| CONVERT | CONVERT(number, from_unit, to_unit) | converts number between measurement units | — |
| DEC2BIN | DEC2BIN(number, [places]) | converts decimal number to binary | 1 |
| DEC2HEX | DEC2HEX(number, [places]) | converts decimal number to hexadecimal | 1 |
| DEC2OCT | DEC2OCT(number, [places]) | converts decimal number to octal | — |
| DELTA | DELTA(number1, [number2]) | tests if two values are equal | 3 |
| ERF | ERF(lower_limit, [upper_limit]) | returns the error function | — |
| ERF.PRECISE | ERF.PRECISE(x) | returns the error function integrated from 0 | — |
| ERFC | ERFC(x) | returns complementary error function | — |
| ERFC.PRECISE | ERFC.PRECISE(x) | returns complementary error function from x | — |
| GESTEP | GESTEP(number, [step]) | tests if number is greater than threshold | — |
| HEX2BIN | HEX2BIN(number, [places]) | converts hexadecimal number to binary | — |
| HEX2DEC | HEX2DEC(number) | converts hexadecimal number to decimal | 1 |
| HEX2OCT | HEX2OCT(number, [places]) | converts hexadecimal number to octal | — |
| IMABS | IMABS(inumber) | returns absolute value of complex number | — |
| IMAGINARY | IMAGINARY(inumber) | returns imaginary coefficient of complex number | — |
| IMARGUMENT | IMARGUMENT(inumber) | returns argument theta of complex number | — |
| IMCONJUGATE | IMCONJUGATE(inumber) | returns complex conjugate of complex number | — |
| IMCOS | IMCOS(inumber) | returns cosine of a complex number | — |
| IMCOSH | IMCOSH(inumber) | returns hyperbolic cosine of complex number | — |
| IMCOT | IMCOT(inumber) | returns cotangent of a complex number | — |
| IMCSC | IMCSC(inumber) | returns cosecant of a complex number | — |
| IMCSCH | IMCSCH(inumber) | returns hyperbolic cosecant of complex number | — |
| IMDIV | IMDIV(inumber1, inumber2) | returns quotient of two complex numbers | — |
| IMEXP | IMEXP(inumber) | returns exponential of a complex number | — |
| IMLN | IMLN(inumber) | returns natural logarithm of complex number | — |
| IMLOG10 | IMLOG10(inumber) | returns base-10 logarithm of complex number | — |
| IMLOG2 | IMLOG2(inumber) | returns base-2 logarithm of complex number | — |
| IMPOWER | IMPOWER(inumber, number) | returns complex number raised to power | — |
| IMPRODUCT | IMPRODUCT(inumber1, inumber2) | returns product of complex numbers | — |
| IMREAL | IMREAL(inumber) | returns real coefficient of complex number | — |
| IMSEC | IMSEC(inumber) | returns secant of a complex number | — |
| IMSECH | IMSECH(inumber) | returns hyperbolic secant of complex number | — |
| IMSIN | IMSIN(inumber) | returns sine of a complex number | — |
| IMSINH | IMSINH(inumber) | returns hyperbolic sine of complex number | — |
| IMSQRT | IMSQRT(inumber) | returns square root of complex number | — |
| IMSUB | IMSUB(inumber1, inumber2) | returns difference of two complex numbers | — |
| IMSUM | IMSUM(inumber1, inumber2) | returns sum of complex numbers | — |
| IMTAN | IMTAN(inumber) | returns tangent of a complex number | — |
| OCT2BIN | OCT2BIN(number, [places]) | converts octal number to binary | — |
| OCT2DEC | OCT2DEC(number) | converts octal number to decimal | — |
| OCT2HEX | OCT2HEX(number, [places]) | converts octal number to hexadecimal | — |
| SUBTOTAL | SUBTOTAL(function_num, ref…) | returns subtotal using specified function | — |