ABS
ABS(value)
Returns the absolute value of a number. Learn more
Analisi dati
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.
79 formule trovate · pagina 1 di 2
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
ACOS
ACOS(value)
Returns the inverse cosine of a value, in radians. Learn more
Analisi dati
Apri schedaACOSH
ACOSH(value)
Returns the inverse hyperbolic cosine of a number. Learn more
Analisi dati
Apri schedaACOT
ACOT(value)
Returns the inverse cotangent of a value, in radians. Learn more.
Analisi dati
Apri schedaACOTH
ACOTH(value)
Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more.
Analisi dati
Apri schedaASIN
ASIN(value)
Returns the inverse sine of a value, in radians. Learn more
Analisi dati
Apri schedaASINH
ASINH(value)
Returns the inverse hyperbolic sine of a number. Learn more
Analisi dati
Apri schedaATAN
ATAN(value)
Returns the inverse tangent of a value, in radians. Learn more
Analisi dati
Apri schedaATAN2
ATAN2(x, y)
Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more
Analisi dati
Apri schedaATANH
ATANH(value)
Returns the inverse hyperbolic tangent of a number. Learn more
Analisi dati
Apri schedaBASE
BASE(value, base, [min_length])
Converts a number into a text representation in another base, for example, base 2 for binary. Learn more.
Analisi dati
Apri schedaCEILING
CEILING(value, [factor])
Rounds a number up to the nearest integer multiple of specified significance. Learn more
Analisi dati
Apri schedaCEILING.MATH
CEILING.MATH(number, [significance], [mode])
Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more.
Analisi dati
Apri schedaCEILING.PRECISE
CEILING.PRECISE(number, [significance])
Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more.
Analisi dati
Apri schedaCOMBIN
COMBIN(n, k)
Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more
Analisi dati
Apri schedaCOMBINA
COMBINA(n, k)
Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. Learn more.
Analisi dati
Apri schedaCOS
COS(angle)
Returns the cosine of an angle provided in radians. Learn more
Analisi dati
Apri schedaCOSH
COSH(value)
Returns the hyperbolic cosine of any real number. Learn more
Analisi dati
Apri schedaCOT
COT(angle)
Cotangent of an angle provided in radians. Learn more.
Analisi dati
Apri schedaCOTH
COTH(value)
Returns the hyperbolic cotangent of any real number. Learn more.
Analisi dati
Apri schedaCOUNTIF
COUNTIF(range, criterion)
Returns a conditional count across a range. Learn more
Analisi dati Marketing
Apri schedaCOUNTIFS
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the count of a range depending on multiple criteria. Learn more
Analisi dati Marketing
Apri schedaCOUNTUNIQUE
COUNTUNIQUE(value1, [value2, ...])
Counts the number of unique values in a list of specified values and ranges. Learn more
Analisi dati
Apri schedaCSC
CSC(angle)
Returns the cosecant of an angle provided in radians. Learn more.
Analisi dati
Apri schedaCSCH
CSCH(value)
The CSCH function returns the hyperbolic cosecant of any real number. Learn more.
Analisi dati
Apri schedaDECIMAL
DECIMAL(value, base)
The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more.
Analisi dati
Apri schedaDEGREES
DEGREES(angle)
Converts an angle value in radians to degrees. Learn more
Analisi dati
Apri schedaERFC
ERFC(z)
Returns the complementary Gauss error function of a value. Learn more
Analisi dati
Apri schedaERFC.PRECISE
ERFC.PRECISE(z)
See ERFC
Analisi dati
Apri schedaEVEN
EVEN(value)
Rounds a number up to the nearest even integer. Learn more
Analisi dati
Apri schedaEXP
EXP(exponent)
Returns Euler's number, e (~2.718) raised to a power. Learn more
Analisi dati
Apri schedaFACT
FACT(value)
Returns the factorial of a number. Learn more
Analisi dati
Apri schedaFACTDOUBLE
FACTDOUBLE(value)
Returns the "double factorial" of a number. Learn more
Analisi dati
Apri schedaFLOOR
FLOOR(value, [factor])
Rounds a number down to the nearest integer multiple of specified significance. Learn more
Analisi dati
Apri schedaFLOOR.MATH
FLOOR.MATH(number, [significance], [mode])
Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more.
Analisi dati
Apri schedaFLOOR.PRECISE
FLOOR.PRECISE(number, [significance])
The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more.
Analisi dati
Apri schedaGAMMALN
GAMMALN(value)
Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more
Analisi dati
Apri schedaGAMMALN.PRECISE
GAMMALN.PRECISE(value)
See GAMMALN
Analisi dati
Apri schedaGCD
GCD(value1, value2)
Returns the greatest common divisor of one or more integers. Learn more
Analisi dati
Apri schedaIMLN
IMLN(complex_value)
Returns the logarithm of a complex number, base e (Euler's number). Learn more
Analisi dati
Apri schedaIMPOWER
IMPOWER(complex_base, exponent)
Returns a complex number raised to a power. Learn more
Analisi dati
Apri schedaIMSQRT
IMSQRT(complex_number)
Computes the square root of a complex number. Learn more
Analisi dati
Apri schedaINT
INT(value)
Rounds a number down to the nearest integer that is less than or equal to it. Learn more
Analisi dati
Apri schedaISEVEN
ISEVEN(value)
Checks whether the provided value is even. Learn more
Analisi dati
Apri schedaISO.CEILING
ISO.CEILING(number, [significance])
See CEILING.PRECISE
Analisi dati
Apri schedaISODD
ISODD(value)
Checks whether the provided value is odd. Learn more
Analisi dati
Apri schedaLCM
LCM(value1, value2)
Returns the least common multiple of one or more integers. Learn more
Analisi dati
Apri schedaLN
LN(value)
Returns the the logarithm of a number, base e (Euler's number). Learn more
Analisi dati
Apri scheda