Google Sheets engineering functions
Engineering functions in Google Sheets, explained with live examples.
47 engineering functions in Google Sheets — 0 documented in depth so far, the rest indexed below and landing every week.
All Google Sheets engineering functions
The full set — deep dives on the way.
- BIN2DEC
- Converts a signed binary number to decimal format.
- BIN2HEX
- Converts a signed binary number to signed hexadecimal format.
- BIN2OCT
- Converts a signed binary number to signed octal format.
- BITAND
- Bitwise boolean AND of two numbers.
- BITLSHIFT
- Shifts the bits of the input a certain number of places to the left.
- BITOR
- Bitwise boolean OR of 2 numbers.
- BITRSHIFT
- Shifts the bits of the input a certain number of places to the right.
- BITXOR
- Bitwise XOR (exclusive OR) of 2 numbers.
- COMPLEX
- Creates a complex number given real and imaginary coefficients.
- DEC2BIN
- Converts a decimal number to signed binary format.
- DEC2HEX
- Converts a decimal number to signed hexadecimal format.
- DEC2OCT
- Converts a decimal number to signed octal format.
- DELTA
- Compare two numeric values, returning 1 if they're equal.
- ERF
- The ERF function returns the integral of the Gauss error function over an interval of values. .
- ERF.PRECISE
- See
- GESTEP
- 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
- Converts a signed hexadecimal number to signed binary format.
- HEX2DEC
- Converts a signed hexadecimal number to decimal format.
- HEX2OCT
- Converts a signed hexadecimal number to signed octal format.
- IMABS
- Returns absolute value of a complex number.
- IMAGINARY
- Returns the imaginary coefficient of a complex number.
- IMARGUMENT
- The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. .
- IMCONJUGATE
- Returns the complex conjugate of a number.
- IMCOS
- The IMCOS function returns the cosine of the given complex number. .
- IMCOSH
- Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." .
- IMCOT
- Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." .
- IMCOTH
- Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." .
- IMCSC
- Returns the cosecant of the given complex number. .
- IMCSCH
- Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." .
- IMDIV
- Returns one complex number divided by another.
- IMEXP
- Returns Euler's number, e (~2.718) raised to a complex power. .
- IMLOG
- Returns the logarithm of a complex number for a specified base. .
- IMLOG10
- Returns the logarithm of a complex number with base 10. .
- IMLOG2
- Returns the logarithm of a complex number with base 2. .
- IMPRODUCT
- Returns the result of multiplying a series of complex numbers together.
- IMREAL
- Returns the real coefficient of a complex number.
- IMSEC
- Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." .
- IMSECH
- Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." .
- IMSIN
- Returns the sine of the given complex number. .
- IMSINH
- Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." .
- IMSUB
- Returns the difference between two complex numbers.
- IMSUM
- Returns the sum of a series of complex numbers.
- IMTAN
- Returns the tangent of the given complex number. .
- IMTANH
- Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." .
- OCT2BIN
- Converts a signed octal number to signed binary format.
- OCT2DEC
- Converts a signed octal number to decimal format.
- OCT2HEX
- Converts a signed octal number to signed hexadecimal format.
More Google Sheets function categories