ABS
ABS(value)
Returns the absolute value of a number. 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.
ACOS
ACOS(value)
Returns the inverse cosine of a value, in radians. Learn more
Apri schedaACOSH
ACOSH(value)
Returns the inverse hyperbolic cosine of a number. Learn more
Apri schedaACOT
ACOT(value)
Returns the inverse cotangent of a value, in radians. Learn more.
Apri schedaACOTH
ACOTH(value)
Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more.
Apri schedaASIN
ASIN(value)
Returns the inverse sine of a value, in radians. Learn more
Apri schedaASINH
ASINH(value)
Returns the inverse hyperbolic sine of a number. Learn more
Apri schedaATAN
ATAN(value)
Returns the inverse tangent of a value, in radians. Learn more
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
Apri schedaATANH
ATANH(value)
Returns the inverse hyperbolic tangent of a number. Learn more
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.
Apri schedaCEILING
CEILING(value, [factor])
Rounds a number up to the nearest integer multiple of specified significance. Learn more
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.
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.
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
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.
Apri schedaCOS
COS(angle)
Returns the cosine of an angle provided in radians. Learn more
Apri schedaCOSH
COSH(value)
Returns the hyperbolic cosine of any real number. Learn more
Apri schedaCOT
COT(angle)
Cotangent of an angle provided in radians. Learn more.
Apri schedaCOTH
COTH(value)
Returns the hyperbolic cotangent of any real number. Learn more.
Apri schedaCOUNTBLANK
COUNTBLANK(range)
Returns the number of empty cells in a given range. Learn more
Apri schedaCOUNTIF
COUNTIF(range, criterion)
Returns a conditional count across a range. Learn more
Apri schedaCOUNTIFS
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the count of a range depending on multiple criteria. Learn more
Apri schedaCOUNTUNIQUE
COUNTUNIQUE(value1, [value2, ...])
Counts the number of unique values in a list of specified values and ranges. Learn more
Apri schedaCSC
CSC(angle)
Returns the cosecant of an angle provided in radians. Learn more.
Apri schedaCSCH
CSCH(value)
The CSCH function returns the hyperbolic cosecant of any real number. Learn more.
Apri schedaDECIMAL
DECIMAL(value, base)
The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more.
Apri schedaDEGREES
DEGREES(angle)
Converts an angle value in radians to degrees. Learn more
Apri schedaERFC
ERFC(z)
Returns the complementary Gauss error function of a value. Learn more
Apri schedaERFC.PRECISE
ERFC.PRECISE(z)
See ERFC
Apri schedaEVEN
EVEN(value)
Rounds a number up to the nearest even integer. Learn more
Apri schedaEXP
EXP(exponent)
Returns Euler's number, e (~2.718) raised to a power. Learn more
Apri schedaFACT
FACT(value)
Returns the factorial of a number. Learn more
Apri schedaFACTDOUBLE
FACTDOUBLE(value)
Returns the "double factorial" of a number. Learn more
Apri schedaFLOOR
FLOOR(value, [factor])
Rounds a number down to the nearest integer multiple of specified significance. Learn more
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.
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.
Apri schedaGAMMALN
GAMMALN(value)
Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more
Apri schedaGAMMALN.PRECISE
GAMMALN.PRECISE(value)
See GAMMALN
Apri schedaGCD
GCD(value1, value2)
Returns the greatest common divisor of one or more integers. Learn more
Apri schedaIMLN
IMLN(complex_value)
Returns the logarithm of a complex number, base e (Euler's number). Learn more
Apri schedaIMPOWER
IMPOWER(complex_base, exponent)
Returns a complex number raised to a power. Learn more
Apri schedaIMSQRT
IMSQRT(complex_number)
Computes the square root of a complex number. Learn more
Apri schedaINT
INT(value)
Rounds a number down to the nearest integer that is less than or equal to it. Learn more
Apri schedaISEVEN
ISEVEN(value)
Checks whether the provided value is even. Learn more
Apri schedaISO.CEILING
ISO.CEILING(number, [significance])
See CEILING.PRECISE
Apri schedaISODD
ISODD(value)
Checks whether the provided value is odd. Learn more
Apri schedaLCM
LCM(value1, value2)
Returns the least common multiple of one or more integers. Learn more
Apri schedaLN
LN(value)
Returns the the logarithm of a number, base e (Euler's number). Learn more
Apri schedaLOG
LOG(value, base)
Returns the the logarithm of a number given a base. Learn more
Apri schedaLOG10
LOG10(value)
Returns the the logarithm of a number, base 10. Learn more
Apri schedaMOD
MOD(dividend, divisor)
Returns the result of the modulo operator, the remainder after a division operation. Learn more
Apri schedaMROUND
MROUND(value, factor)
Rounds one number to the nearest integer multiple of another. Learn more
Apri schedaMULTINOMIAL
MULTINOMIAL(value1, value2)
Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more
Apri schedaMUNIT
MUNIT(dimension)
Returns a unit matrix of size dimension x dimension. Learn more.
Apri schedaODD
ODD(value)
Rounds a number up to the nearest odd integer. Learn more
Apri schedaPI
PI()
Returns the value of Pi to 14 decimal places. Learn more
Apri schedaPOWER
POWER(base, exponent)
Returns a number raised to a power. Learn more
Apri schedaPRODUCT
PRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of numbers together. Learn more
Apri schedaQUOTIENT
QUOTIENT(dividend, divisor)
Returns one number divided by another. Learn more
Apri schedaRADIANS
RADIANS(angle)
Converts an angle value in degrees to radians. Learn more
Apri schedaRAND
RAND()
Returns a random number between 0 inclusive and 1 exclusive. Learn more
Apri schedaRANDARRAY
RANDARRAY(rows, columns)
Generates an array of random numbers between 0 and 1. Learn more.
Apri schedaRANDBETWEEN
RANDBETWEEN(low, high)
Returns a uniformly random integer between two values, inclusive. Learn more
Apri schedaROUND
ROUND(value, [places])
Rounds a number to a certain number of decimal places according to standard rules. Learn more
Apri schedaROUNDDOWN
ROUNDDOWN(value, [places])
Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more
Apri schedaROUNDUP
ROUNDUP(value, [places])
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more
Apri schedaSEC
SEC(angle)
The SEC function returns the secant of an angle, measured in radians. Learn more.
Apri schedaSECH
SECH(value)
The SECH function returns the hyperbolic secant of an angle. Learn more
Apri schedaSEQUENCE
SEQUENCE(rows, columns, start, step)
Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.
Apri schedaSERIESSUM
SERIESSUM(x, n, m, a)
Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`. Learn more
Apri schedaSIGN
SIGN(value)
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Learn more
Apri schedaSIN
SIN(angle)
Returns the sine of an angle provided in radians. Learn more
Apri schedaSINH
SINH(value)
Returns the hyperbolic sine of any real number. Learn more
Apri schedaSQRT
SQRT(value)
Returns the positive square root of a positive number. Learn more
Apri schedaSQRTPI
SQRTPI(value)
Returns the positive square root of the product of Pi and the given positive number. Learn more
Apri schedaSUBTOTAL
SUBTOTAL(function_code, range1, [range2, ...])
Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
Apri schedaSUM
SUM(value1, [value2, ...])
Returns the sum of a series of numbers and/or cells. Learn more
Apri schedaSUMIF
SUMIF(range, criterion, [sum_range])
Returns a conditional sum across a range. Learn more
Apri schedaSUMIFS
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the sum of a range depending on multiple criteria. Learn more
Apri schedaSUMSQ
SUMSQ(value1, [value2, ...])
Returns the sum of the squares of a series of numbers and/or cells. Learn more
Apri schedaTAN
TAN(angle)
Returns the tangent of an angle provided in radians. Learn more
Apri schedaTANH
TANH(value)
Returns the hyperbolic tangent of any real number. Learn more
Apri schedaTRUNC
TRUNC(value, [places])
Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more
Apri scheda