Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Engineering
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Engineering

Instruction: BIN2DEC(signed_binary_number)
Returns: Converts a signed binary number to decimal format. Learn more

Instruction: BIN2HEX(signed_binary_number, [significant_digits])
Returns: Converts a signed binary number to signed hexadecimal format. Learn more

Instruction: BIN2OCT(signed_binary_number, [significant_digits])
Returns: Converts a signed binary number to signed octal format. Learn more

Instruction: BITAND(value1, value2)
Returns: Bitwise boolean AND of two numbers. Learn more.

Instruction: BITLSHIFT(value, shift_amount)
Returns: Shifts the bits of the input a certain number of places to the left. Learn more.

Instruction: BITOR(value1, value2)
Returns: Bitwise boolean OR of 2 numbers. Learn more.

Instruction: BITRSHIFT(value, shift_amount)
Returns: Shifts the bits of the input a certain number of places to the right. Learn more.

Instruction: BITXOR(value1, value2)
Returns: Bitwise XOR (exclusive OR) of 2 numbers. Learn more.

Instruction: COMPLEX(real_part, imaginary_part, [suffix])
Returns: Creates a complex number given real and imaginary coefficients. Learn more

Instruction: DEC2BIN(decimal_number, [significant_digits])
Returns: Converts a decimal number to signed binary format. Learn more

Instruction: DEC2HEX(decimal_number, [significant_digits])
Returns: Converts a decimal number to signed hexadecimal format. Learn more

Instruction: DEC2OCT(decimal_number, [significant_digits])
Returns: Converts a decimal number to signed octal format. Learn more

Instruction: DELTA(number1, [number2])
Returns: Compare two numeric values, returning 1 if they're equal. Learn more

Instruction: ERF(lower_bound, [upper_bound])
Returns: The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.

Instruction: ERF.PRECISE(lower_bound, [upper_bound])
Returns: See ERF

Instruction: GESTEP(value, [step])
Returns: 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. Learn more.

Instruction: HEX2BIN(signed_hexadecimal_number, [significant_digits])
Returns: Converts a signed hexadecimal number to signed binary format. Learn more

Instruction: HEX2DEC(signed_hexadecimal_number)
Returns: Converts a signed hexadecimal number to decimal format. Learn more

Instruction: HEX2OCT(signed_hexadecimal_number, significant_digits)
Returns: Converts a signed hexadecimal number to signed octal format. Learn more

Instruction: IMABS(number)
Returns: Returns absolute value of a complex number. Learn more

Instruction: IMAGINARY(complex_number)
Returns: Returns the imaginary coefficient of a complex number. Learn more

Instruction: IMARGUMENT(number)
Returns: The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more.

Instruction: IMCONJUGATE(number)
Returns: Returns the complex conjugate of a number. Learn more

Instruction: IMCOS(number)
Returns: The IMCOS function returns the cosine of the given complex number. Learn more.

Instruction: IMCOSH(number)
Returns: Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.

Instruction: IMCOT(number)
Returns: Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.

Instruction: IMCOTH(number)
Returns: Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.

Instruction: IMCSC(number)
Returns: Returns the cosecant of the given complex number. Learn more.

Instruction: IMCSCH(number)
Returns: Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.

Instruction: IMDIV(dividend, divisor)
Returns: Returns one complex number divided by another. Learn more

Instruction: IMEXP(exponent)
Returns: Returns Euler's number, e (~2.718) raised to a complex power. Learn more.

Instruction: IMLOG(value, base)
Returns: Returns the logarithm of a complex number for a specified base. Learn more.

Instruction: IMLOG10(value)
Returns: Returns the logarithm of a complex number with base 10. Learn more.

Instruction: IMLOG2(value)
Returns: Returns the logarithm of a complex number with base 2. Learn more.

Instruction: IMPRODUCT(factor1, [factor2, ...])
Returns: Returns the result of multiplying a series of complex numbers together. Learn more

Instruction: IMREAL(complex_number)
Returns: Returns the real coefficient of a complex number. Learn more

Instruction: IMSEC(number)
Returns: Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.

Instruction: IMSECH(number)
Returns: Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.

Instruction: IMSIN (number)
Returns: Returns the sine of the given complex number. Learn more.

Instruction: IMSINH(number)
Returns: Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more.

Instruction: IMSUB(first_number, second_number)
Returns: Returns the difference between two complex numbers. Learn more

Instruction: IMSUM(value1, [value2, ...])
Returns: Returns the sum of a series of complex numbers. Learn more

Instruction: IMTAN(number)
Returns: Returns the tangent of the given complex number. Learn more.

Instruction: IMTANH(number)
Returns: Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more.

Instruction: OCT2BIN(signed_octal_number, [significant_digits])
Returns: Converts a signed octal number to signed binary format. Learn more

Instruction: OCT2DEC(signed_octal_number)
Returns: Converts a signed octal number to decimal format. Learn more

Instruction: OCT2HEX(signed_octal_number, [significant_digits])
Returns: Converts a signed octal number to signed hexadecimal format. Learn more