Modalità esperto · accesso rapido

Formula reference avanzata

Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.

Digita almeno 2 lettere per vedere i suggerimenti.

Azzera

47 formule trovate

Non sai da dove partire? Percorsi per livello e use case
Base Intermedio Avanzato Use case Sfida del giorno
Engineering Avanzato

BIN2DEC

BIN2DEC(signed_binary_number)

Converts a signed binary number to decimal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

BIN2HEX

BIN2HEX(signed_binary_number, [significant_digits])

Converts a signed binary number to signed hexadecimal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

BIN2OCT

BIN2OCT(signed_binary_number, [significant_digits])

Converts a signed binary number to signed octal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

BITAND

BITAND(value1, value2)

Bitwise boolean AND of two numbers. Learn more. 

Automazione

Apri scheda
Engineering Avanzato

BITLSHIFT

BITLSHIFT(value, shift_amount)

Shifts the bits of the input a certain number of places to the left. Learn more. 

Automazione

Apri scheda
Engineering Avanzato

BITOR

BITOR(value1, value2)

Bitwise boolean OR of 2 numbers. Learn more. 

Automazione

Apri scheda
Engineering Avanzato

BITRSHIFT

BITRSHIFT(value, shift_amount)

Shifts the bits of the input a certain number of places to the right. Learn more. 

Automazione

Apri scheda
Engineering Avanzato

BITXOR

BITXOR(value1, value2)

Bitwise XOR (exclusive OR) of 2 numbers. Learn more. 

Automazione

Apri scheda
Engineering Avanzato

COMPLEX

COMPLEX(real_part, imaginary_part, [suffix])

Creates a complex number given real and imaginary coefficients. Learn more

Automazione

Apri scheda
Engineering Avanzato

DEC2BIN

DEC2BIN(decimal_number, [significant_digits])

Converts a decimal number to signed binary format. Learn more

Automazione

Apri scheda
Engineering Avanzato

DEC2HEX

DEC2HEX(decimal_number, [significant_digits])

Converts a decimal number to signed hexadecimal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

DEC2OCT

DEC2OCT(decimal_number, [significant_digits])

Converts a decimal number to signed octal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

DELTA

DELTA(number1, [number2])

Compare two numeric values, returning 1 if they're equal. Learn more

Automazione

Apri scheda
Engineering Avanzato

ERF

ERF(lower_bound, [upper_bound])

The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.

Automazione

Apri scheda
Engineering Avanzato

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. Learn more. 

Automazione

Apri scheda
Engineering Avanzato

HEX2BIN

HEX2BIN(signed_hexadecimal_number, [significant_digits])

Converts a signed hexadecimal number to signed binary format. Learn more

Automazione

Apri scheda
Engineering Avanzato

HEX2DEC

HEX2DEC(signed_hexadecimal_number)

Converts a signed hexadecimal number to decimal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

HEX2OCT

HEX2OCT(signed_hexadecimal_number, significant_digits)

Converts a signed hexadecimal number to signed octal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMABS

IMABS(number)

Returns absolute value of a complex number. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMAGINARY

IMAGINARY(complex_number)

Returns the imaginary coefficient of a complex number. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMARGUMENT

IMARGUMENT(number)

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

Automazione

Apri scheda
Engineering Avanzato

IMCONJUGATE

IMCONJUGATE(number)

Returns the complex conjugate of a number. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMCOS

IMCOS(number)

The IMCOS function returns the cosine of the given complex number. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMCOSH

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.

Automazione

Apri scheda
Engineering Avanzato

IMCOT

IMCOT(number)

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

Automazione

Apri scheda
Engineering Avanzato

IMCOTH

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.

Automazione

Apri scheda
Engineering Avanzato

IMCSC

IMCSC(number)

Returns the cosecant of the given complex number. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMCSCH

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.

Automazione

Apri scheda
Engineering Avanzato

IMDIV

IMDIV(dividend, divisor)

Returns one complex number divided by another. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMEXP

IMEXP(exponent)

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

Automazione

Apri scheda
Engineering Avanzato

IMLOG

IMLOG(value, base)

Returns the logarithm of a complex number for a specified base. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMLOG10

IMLOG10(value)

Returns the logarithm of a complex number with base 10. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMLOG2

IMLOG2(value)

Returns the logarithm of a complex number with base 2. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMPRODUCT

IMPRODUCT(factor1, [factor2, ...])

Returns the result of multiplying a series of complex numbers together. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMREAL

IMREAL(complex_number)

Returns the real coefficient of a complex number. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMSEC

IMSEC(number)

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

Automazione

Apri scheda
Engineering Avanzato

IMSECH

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.

Automazione

Apri scheda
Engineering Avanzato

IMSIN

IMSIN (number)

Returns the sine of the given complex number. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMSINH

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.

Automazione

Apri scheda
Engineering Avanzato

IMSUB

IMSUB(first_number, second_number)

Returns the difference between two complex numbers. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMSUM

IMSUM(value1, [value2, ...])

Returns the sum of a series of complex numbers. Learn more

Automazione

Apri scheda
Engineering Avanzato

IMTAN

IMTAN(number)

Returns the tangent of the given complex number. Learn more.

Automazione

Apri scheda
Engineering Avanzato

IMTANH

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.

Automazione

Apri scheda
Engineering Avanzato

OCT2BIN

OCT2BIN(signed_octal_number, [significant_digits])

Converts a signed octal number to signed binary format. Learn more

Automazione

Apri scheda
Engineering Avanzato

OCT2DEC

OCT2DEC(signed_octal_number)

Converts a signed octal number to decimal format. Learn more

Automazione

Apri scheda
Engineering Avanzato

OCT2HEX

OCT2HEX(signed_octal_number, [significant_digits])

Converts a signed octal number to signed hexadecimal format. Learn more

Automazione

Apri scheda