BIN2DEC
BIN2DEC(signed_binary_number)
Converts a signed binary number to decimal format. Learn more
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
BIN2HEX
BIN2HEX(signed_binary_number, [significant_digits])
Converts a signed binary number to signed hexadecimal format. Learn more
Apri schedaBIN2OCT
BIN2OCT(signed_binary_number, [significant_digits])
Converts a signed binary number to signed octal format. Learn more
Apri schedaBITAND
BITAND(value1, value2)
Bitwise boolean AND of two numbers. Learn more.
Apri schedaBITLSHIFT
BITLSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the left. Learn more.
Apri schedaBITOR
BITOR(value1, value2)
Bitwise boolean OR of 2 numbers. Learn more.
Apri schedaBITRSHIFT
BITRSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the right. Learn more.
Apri schedaBITXOR
BITXOR(value1, value2)
Bitwise XOR (exclusive OR) of 2 numbers. Learn more.
Apri schedaCOMPLEX
COMPLEX(real_part, imaginary_part, [suffix])
Creates a complex number given real and imaginary coefficients. Learn more
Apri schedaDEC2BIN
DEC2BIN(decimal_number, [significant_digits])
Converts a decimal number to signed binary format. Learn more
Apri schedaDEC2HEX
DEC2HEX(decimal_number, [significant_digits])
Converts a decimal number to signed hexadecimal format. Learn more
Apri schedaDEC2OCT
DEC2OCT(decimal_number, [significant_digits])
Converts a decimal number to signed octal format. Learn more
Apri schedaDELTA
DELTA(number1, [number2])
Compare two numeric values, returning 1 if they're equal. Learn more
Apri schedaERF
ERF(lower_bound, [upper_bound])
The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.
Apri schedaERF.PRECISE
ERF.PRECISE(lower_bound, [upper_bound])
See ERF
Apri schedaGESTEP
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. Learn more.
Apri schedaHEX2BIN
HEX2BIN(signed_hexadecimal_number, [significant_digits])
Converts a signed hexadecimal number to signed binary format. Learn more
Apri schedaHEX2DEC
HEX2DEC(signed_hexadecimal_number)
Converts a signed hexadecimal number to decimal format. Learn more
Apri schedaHEX2OCT
HEX2OCT(signed_hexadecimal_number, significant_digits)
Converts a signed hexadecimal number to signed octal format. Learn more
Apri schedaIMABS
IMABS(number)
Returns absolute value of a complex number. Learn more
Apri schedaIMAGINARY
IMAGINARY(complex_number)
Returns the imaginary coefficient of a complex number. Learn more
Apri schedaIMARGUMENT
IMARGUMENT(number)
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more.
Apri schedaIMCONJUGATE
IMCONJUGATE(number)
Returns the complex conjugate of a number. Learn more
Apri schedaIMCOS
IMCOS(number)
The IMCOS function returns the cosine of the given complex number. Learn more.
Apri schedaIMCOSH
IMCOSH(number)
Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.
Apri schedaIMCOT
IMCOT(number)
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.
Apri schedaIMCOTH
IMCOTH(number)
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.
Apri schedaIMCSC
IMCSC(number)
Returns the cosecant of the given complex number. Learn more.
Apri schedaIMCSCH
IMCSCH(number)
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.
Apri schedaIMDIV
IMDIV(dividend, divisor)
Returns one complex number divided by another. Learn more
Apri schedaIMEXP
IMEXP(exponent)
Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
Apri schedaIMLOG
IMLOG(value, base)
Returns the logarithm of a complex number for a specified base. Learn more.
Apri schedaIMLOG10
IMLOG10(value)
Returns the logarithm of a complex number with base 10. Learn more.
Apri schedaIMLOG2
IMLOG2(value)
Returns the logarithm of a complex number with base 2. Learn more.
Apri schedaIMPRODUCT
IMPRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of complex numbers together. Learn more
Apri schedaIMREAL
IMREAL(complex_number)
Returns the real coefficient of a complex number. Learn more
Apri schedaIMSEC
IMSEC(number)
Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.
Apri schedaIMSECH
IMSECH(number)
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.
Apri schedaIMSIN
IMSIN (number)
Returns the sine of the given complex number. Learn more.
Apri schedaIMSINH
IMSINH(number)
Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more.
Apri schedaIMSUB
IMSUB(first_number, second_number)
Returns the difference between two complex numbers. Learn more
Apri schedaIMSUM
IMSUM(value1, [value2, ...])
Returns the sum of a series of complex numbers. Learn more
Apri schedaIMTAN
IMTAN(number)
Returns the tangent of the given complex number. Learn more.
Apri schedaIMTANH
IMTANH(number)
Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more.
Apri schedaOCT2BIN
OCT2BIN(signed_octal_number, [significant_digits])
Converts a signed octal number to signed binary format. Learn more
Apri schedaOCT2DEC
OCT2DEC(signed_octal_number)
Converts a signed octal number to decimal format. Learn more
Apri schedaOCT2HEX
OCT2HEX(signed_octal_number, [significant_digits])
Converts a signed octal number to signed hexadecimal format. Learn more
Apri scheda