HEX2OCT
HEX2OCT(signed_hexadecimal_number, significant_digits)
Converts a signed hexadecimal number to signed octal format. Learn more
Automazione
Apri schedaFormula 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.
99 formule trovate · pagina 2 di 3
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
IMABS
IMABS(number)
Returns absolute value of a complex number. Learn more
Automazione
Apri schedaIMAGINARY
IMAGINARY(complex_number)
Returns the imaginary coefficient of a complex number. Learn more
Automazione
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.
Automazione
Apri schedaIMCONJUGATE
IMCONJUGATE(number)
Returns the complex conjugate of a number. Learn more
Automazione
Apri schedaIMCOS
IMCOS(number)
The IMCOS function returns the cosine of the given complex number. Learn more.
Automazione
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.
Automazione
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.
Automazione
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.
Automazione
Apri schedaIMCSC
IMCSC(number)
Returns the cosecant of the given complex number. Learn more.
Automazione
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.
Automazione
Apri schedaIMDIV
IMDIV(dividend, divisor)
Returns one complex number divided by another. Learn more
Automazione
Apri schedaIMEXP
IMEXP(exponent)
Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
Automazione
Apri schedaIMLOG
IMLOG(value, base)
Returns the logarithm of a complex number for a specified base. Learn more.
Automazione
Apri schedaIMLOG10
IMLOG10(value)
Returns the logarithm of a complex number with base 10. Learn more.
Automazione
Apri schedaIMLOG2
IMLOG2(value)
Returns the logarithm of a complex number with base 2. Learn more.
Automazione
Apri schedaIMPRODUCT
IMPRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of complex numbers together. Learn more
Automazione
Apri schedaIMREAL
IMREAL(complex_number)
Returns the real coefficient of a complex number. Learn more
Automazione
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.
Automazione
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.
Automazione
Apri schedaIMSIN
IMSIN (number)
Returns the sine of the given complex number. Learn more.
Automazione
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.
Automazione
Apri schedaIMSUB
IMSUB(first_number, second_number)
Returns the difference between two complex numbers. Learn more
Automazione
Apri schedaIMSUM
IMSUM(value1, [value2, ...])
Returns the sum of a series of complex numbers. Learn more
Automazione
Apri schedaIMTAN
IMTAN(number)
Returns the tangent of the given complex number. Learn more.
Automazione
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.
Automazione
Apri schedaOCT2BIN
OCT2BIN(signed_octal_number, [significant_digits])
Converts a signed octal number to signed binary format. Learn more
Automazione
Apri schedaOCT2DEC
OCT2DEC(signed_octal_number)
Converts a signed octal number to decimal format. Learn more
Automazione
Apri schedaOCT2HEX
OCT2HEX(signed_octal_number, [significant_digits])
Converts a signed octal number to signed hexadecimal format. Learn more
Automazione
Apri schedaFILTER
FILTER(range, condition1, [condition2])
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
Analisi dati Marketing Automazione
Apri schedaARRAYFORMULA
ARRAYFORMULA(array_formula)
Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more
Automazione
Apri schedaDETECTLANGUAGE
DETECTLANGUAGE(text_or_range)
Identifies the language used in text within the specified range. Learn more
Automazione
Apri schedaGOOGLEFINANCE
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Fetches current or historical securities information from Google Finance. Learn more
Automazione Finance
Apri schedaGOOGLETRANSLATE
GOOGLETRANSLATE(text, [source_language], [target_language])
Translates text from one language into another Learn more
Automazione
Apri schedaIMAGE
IMAGE(url, [mode], [height], [width])
Inserts an image into a cell. Learn more
Automazione
Apri schedaQUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Automazione Marketing Analisi dati
Apri schedaSPARKLINE
SPARKLINE(data, [options])
Creates a miniature chart contained within a single cell. Learn more
Automazione
Apri schedaCONVERT
CONVERT(value, start_unit, end_unit)
Converts a numeric value to a different unit of measure. Learn more
Automazione
Apri schedaTO_DATE
TO_DATE(value)
Converts a provided number to a date. Learn more
Automazione
Apri schedaTO_DOLLARS
TO_DOLLARS(value)
Converts a provided number to a dollar value. Learn more
Automazione
Apri schedaTO_PERCENT
TO_PERCENT(value)
Converts a provided number to a percentage. Learn more
Automazione
Apri schedaTO_PURE_NUMBER
TO_PURE_NUMBER(value)
Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting. Learn more
Automazione
Apri schedaTO_TEXT
TO_TEXT(value)
Converts a provided numeric value to a text value. Learn more
Automazione
Apri schedaENCODEURL
ENCODEURL(text)
Encodes a string of text for the purpose of using in a URL query. Learn more.
Automazione
Apri schedaHYPERLINK
HYPERLINK(url, [link_label])
Creates a hyperlink inside a cell. Learn more
Automazione
Apri schedaIMPORTDATA
IMPORTDATA(url)
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more
Automazione
Apri schedaIMPORTFEED
IMPORTFEED(url, [query], [headers], [num_items])
Imports a RSS or ATOM feed. Learn more
Automazione
Apri schedaIMPORTHTML
IMPORTHTML(url, query, index)
Imports data from a table or list within an HTML page. Learn more
Automazione
Apri scheda