Type in Google’s function list
Engineering functions
Functions for engineering and complex-number work. Google prints 47 Engineering function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| BIN2DEC | BIN2DEC(signed_binary_number) | Converts a signed binary number to decimal format. |
| BIN2HEX | BIN2HEX(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed hexadecimal format. |
| BIN2OCT | BIN2OCT(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed octal format. |
| BITAND | BITAND(value1, value2) | Bitwise boolean AND of two numbers. |
| BITLSHIFT | BITLSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the left. |
| BITOR | BITOR(value1, value2) | Bitwise boolean OR of 2 numbers. |
| BITRSHIFT | BITRSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the right. |
| BITXOR | BITXOR(value1, value2) | Bitwise XOR (exclusive OR) of 2 numbers. |
| COMPLEX | COMPLEX(real_part, imaginary_part, [suffix]) | Creates a complex number given real and imaginary coefficients. |
| DEC2BIN | DEC2BIN(decimal_number, [significant_digits]) | Converts a decimal number to signed binary format. |
| DEC2HEX | DEC2HEX(decimal_number, [significant_digits]) | Converts a decimal number to signed hexadecimal format. |
| DEC2OCT | DEC2OCT(decimal_number, [significant_digits]) | Converts a decimal number to signed octal format. |
| DELTA | DELTA(number1, [number2]) | Compare two numeric values, returning 1 if they're equal. |
| ERF | ERF(lower_bound, [upper_bound]) | The ERF function returns the integral of the Gauss error function over an interval of values. |
| ERF.PRECISE | ERF.PRECISE(lower_bound, [upper_bound]) | See ERF |
| GESTEP | GESTEP(value, [step]) | Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used. |
| HEX2BIN | HEX2BIN(signed_hexadecimal_number, [significant_digits]) | Converts a signed hexadecimal number to signed binary format. |
| HEX2DEC | HEX2DEC(signed_hexadecimal_number) | Converts a signed hexadecimal number to decimal format. |
| HEX2OCT | HEX2OCT(signed_hexadecimal_number, significant_digits) | Converts a signed hexadecimal number to signed octal format. |
| IMABS | IMABS(number) | Returns absolute value of a complex number. |
| IMAGINARY | IMAGINARY(complex_number) | Returns the imaginary coefficient of a complex number. |
| IMARGUMENT | IMARGUMENT(number) | The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. |
| IMCONJUGATE | IMCONJUGATE(number) | Returns the complex conjugate of a number. |
| IMCOS | IMCOS(number) | The IMCOS function returns the cosine of the given complex number. |
| IMCOSH | IMCOSH(number) | Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." |
| IMCOT | IMCOT(number) | Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." |
| IMCOTH | IMCOTH(number) | Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." |
| IMCSC | IMCSC(number) | Returns the cosecant of the given complex number. |
| IMCSCH | IMCSCH(number) | Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." |
| IMDIV | IMDIV(dividend, divisor) | Returns one complex number divided by another. |
| IMEXP | IMEXP(exponent) | Returns Euler's number, e (~2.718) raised to a complex power. |
| IMLOG | IMLOG(value, base) | Returns the logarithm of a complex number for a specified base. |
| IMLOG10 | IMLOG10(value) | Returns the logarithm of a complex number with base 10. |
| IMLOG2 | IMLOG2(value) | Returns the logarithm of a complex number with base 2. |
| IMPRODUCT | IMPRODUCT(factor1, [factor2, ...]) | Returns the result of multiplying a series of complex numbers together. |
| IMREAL | IMREAL(complex_number) | Returns the real coefficient of a complex number. |
| IMSEC | IMSEC(number) | Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." |
| IMSECH | IMSECH(number) | Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." |
| IMSIN | IMSIN (number) | Returns the sine of the given complex number. |
| IMSINH | IMSINH(number) | Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." |
| IMSUB | IMSUB(first_number, second_number) | Returns the difference between two complex numbers. |
| IMSUM | IMSUM(value1, [value2, ...]) | Returns the sum of a series of complex numbers. |
| IMTAN | IMTAN(number) | Returns the tangent of the given complex number. |
| IMTANH | IMTANH(number) | Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." |
| OCT2BIN | OCT2BIN(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed binary format. |
| OCT2DEC | OCT2DEC(signed_octal_number) | Converts a signed octal number to decimal format. |
| OCT2HEX | OCT2HEX(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed hexadecimal format. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.