Engineering functions
The 54 engineering functions in Sheets, with the usual names, arguments and results.
| Function | What it does | Syntax |
|---|---|---|
| BESSELI | Modified Bessel function In(x) | BESSELI(x, n) |
| BESSELJ | Bessel function Jn(x) | BESSELJ(x, n) |
| BESSELK | Modified Bessel function Kn(x) | BESSELK(x, n) |
| BESSELY | Bessel function Yn(x) | BESSELY(x, n) |
| BIN2DEC | Binary to decimal | BIN2DEC(number) |
| BIN2HEX | Binary to hexadecimal | BIN2HEX(number, [places]) |
| BIN2OCT | Binary to octal | BIN2OCT(number, [places]) |
| BITAND | Bitwise AND of two numbers | BITAND(number1, number2) |
| BITLSHIFT | Number shifted left by N bits | BITLSHIFT(number, shift_amount) |
| BITOR | Bitwise OR of two numbers | BITOR(number1, number2) |
| BITRSHIFT | Number shifted right by N bits | BITRSHIFT(number, shift_amount) |
| BITXOR | Bitwise XOR of two numbers | BITXOR(number1, number2) |
| COMPLEX | Complex number from real and imaginary parts | COMPLEX(real_num, i_num, [suffix]) |
| CONVERT | Convert between units of measurement | CONVERT(number, from_unit, to_unit) |
| DEC2BIN | Decimal to binary | DEC2BIN(number, [places]) |
| DEC2HEX | Decimal to hexadecimal | DEC2HEX(number, [places]) |
| DEC2OCT | Decimal to octal | DEC2OCT(number, [places]) |
| DELTA | 1 if two numbers are equal, else 0 | DELTA(number1, [number2]) |
| ERF | Error function | ERF(lower_limit, [upper_limit]) |
| ERF.PRECISE | Error function from 0 to x | ERF.PRECISE(x) |
| ERFC | Complementary error function | ERFC(x) |
| ERFC.PRECISE | Complementary error function | ERFC.PRECISE(x) |
| GESTEP | 1 if number >= step, else 0 | GESTEP(number, [step]) |
| HEX2BIN | Hexadecimal to binary | HEX2BIN(number, [places]) |
| HEX2DEC | Hexadecimal to decimal | HEX2DEC(number) |
| HEX2OCT | Hexadecimal to octal | HEX2OCT(number, [places]) |
| IMABS | Absolute value of a complex number | IMABS(inumber) |
| IMAGINARY | Imaginary part of a complex number | IMAGINARY(inumber) |
| IMARGUMENT | Angle of a complex number in radians | IMARGUMENT(inumber) |
| IMCONJUGATE | Complex conjugate | IMCONJUGATE(inumber) |
| IMCOS | Cosine of a complex number | IMCOS(inumber) |
| IMCOSH | Hyperbolic cosine of a complex number | IMCOSH(inumber) |
| IMCOT | Cotangent of a complex number | IMCOT(inumber) |
| IMCSC | Cosecant of a complex number | IMCSC(inumber) |
| IMCSCH | Hyperbolic cosecant of a complex number | IMCSCH(inumber) |
| IMDIV | Quotient of two complex numbers | IMDIV(inumber1, inumber2) |
| IMEXP | Exponential of a complex number | IMEXP(inumber) |
| IMLN | Natural logarithm of a complex number | IMLN(inumber) |
| IMLOG10 | Base-10 logarithm of a complex number | IMLOG10(inumber) |
| IMLOG2 | Base-2 logarithm of a complex number | IMLOG2(inumber) |
| IMPOWER | Complex number raised to a power | IMPOWER(inumber, number) |
| IMPRODUCT | Product of complex numbers | IMPRODUCT(inumber1, [inumber2, ...]) |
| IMREAL | Real part of a complex number | IMREAL(inumber) |
| IMSEC | Secant of a complex number | IMSEC(inumber) |
| IMSECH | Hyperbolic secant of a complex number | IMSECH(inumber) |
| IMSIN | Sine of a complex number | IMSIN(inumber) |
| IMSINH | Hyperbolic sine of a complex number | IMSINH(inumber) |
| IMSQRT | Square root of a complex number | IMSQRT(inumber) |
| IMSUB | Difference of two complex numbers | IMSUB(inumber1, inumber2) |
| IMSUM | Sum of complex numbers | IMSUM(inumber1, [inumber2, ...]) |
| IMTAN | Tangent of a complex number | IMTAN(inumber) |
| OCT2BIN | Octal to binary | OCT2BIN(number, [places]) |
| OCT2DEC | Octal to decimal | OCT2DEC(number) |
| OCT2HEX | Octal to hexadecimal | OCT2HEX(number, [places]) |