TRUNC
TRUNC(value, [places])
Truncates a number to a certain number of significant digits by omitting less significant digits. 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.
369 formule trovate · pagina 5 di 8
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
ADD
ADD(value1, value2)
Returns the sum of two numbers. Equivalent to the `+` operator. Learn more
Produttivita
Apri schedaCONCAT
CONCAT(value1, value2)
Returns the concatenation of two values. Equivalent to the `&` operator. Learn more
Produttivita
Apri schedaDIVIDE
DIVIDE(dividend, divisor)
Returns one number divided by another. Equivalent to the `/` operator. Learn more
Produttivita
Apri schedaEQ
EQ(value1, value2)
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more
Produttivita
Apri schedaGT
GT(value1, value2)
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more
Produttivita
Apri schedaGTE
GTE(value1, value2)
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn more
Produttivita
Apri schedaISBETWEEN
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn more
Produttivita
Apri schedaLT
LT(value1, value2)
Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more
Produttivita
Apri schedaLTE
LTE(value1, value2)
Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn more
Produttivita
Apri schedaMINUS
MINUS(value1, value2)
Returns the difference of two numbers. Equivalent to the `-` operator. Learn more
Produttivita
Apri schedaMULTIPLY
MULTIPLY(factor1, factor2)
Returns the product of two numbers. Equivalent to the `*` operator. Learn more
Produttivita
Apri schedaNE
NE(value1, value2)
Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn more
Produttivita
Apri schedaPOW
POW(base, exponent)
Returns a number raised to a power. Learn more
Produttivita
Apri schedaUMINUS
UMINUS(value)
Returns a number with the sign reversed. Learn more
Produttivita
Apri schedaUNARY_PERCENT
UNARY_PERCENT(percentage)
Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more
Produttivita
Apri schedaUPLUS
UPLUS(value)
Returns a specified number, unchanged. Learn more
Produttivita
Apri schedaAVEDEV
AVEDEV(value1, [value2, ...])
Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more
Analisi dati
Apri schedaAVERAGE.WEIGHTED
AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more.
Analisi dati
Apri schedaAVERAGEA
AVERAGEA(value1, [value2, ...])
Returns the numerical average value in a dataset. Learn more
Analisi dati
Apri schedaAVERAGEIF
AVERAGEIF(criteria_range, criterion, [average_range])
Returns the average of a range depending on criteria. Learn more
Analisi dati
Apri schedaAVERAGEIFS
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the average of a range depending on multiple criteria. Learn more
Analisi dati
Apri schedaBETA.DIST
BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)
Returns the probability of a given value as defined by the beta distribution function. Learn more.
Analisi dati
Apri schedaBETA.INV
BETA.INV(probability, alpha, beta, lower_bound, upper_bound)
Returns the value of the inverse beta distribution function for a given probability. Learn more.
Analisi dati
Apri schedaBETADIST
BETADIST(value, alpha, beta, lower_bound, upper_bound)
See BETA.DIST.
Analisi dati
Apri schedaBETAINV
BETAINV(probability, alpha, beta, lower_bound, upper_bound)
See BETA.INV
Analisi dati
Apri schedaBINOM.DIST
BINOM.DIST(num_successes, num_trials, prob_success, cumulative)
See BINOMDIST
Analisi dati
Apri schedaBINOM.INV
BINOM.INV(num_trials, prob_success, target_prob)
See CRITBINOM
Analisi dati
Apri schedaBINOMDIST
BINOMDIST(num_successes, num_trials, prob_success, cumulative)
Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more
Analisi dati
Apri schedaCHIDIST
CHIDIST(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHIINV
CHIINV(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.DIST
CHISQ.DIST(x, degrees_freedom, cumulative)
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHISQ.DIST.RT
CHISQ.DIST.RT(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHISQ.INV
CHISQ.INV(probability, degrees_freedom)
Calculates the inverse of the left-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.INV.RT
CHISQ.INV.RT(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.TEST
CHISQ.TEST(observed_range, expected_range)
See CHITEST
Analisi dati
Apri schedaCHITEST
CHITEST(observed_range, expected_range)
Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more
Analisi dati
Apri schedaCONFIDENCE
CONFIDENCE(alpha, standard_deviation, pop_size)
See CONFIDENCE.NORM
Analisi dati
Apri schedaCONFIDENCE.NORM
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a normal distribution. Learn more.
Analisi dati
Apri schedaCONFIDENCE.T
CONFIDENCE.T(alpha, standard_deviation, size)
Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more.
Analisi dati
Apri schedaCORREL
CORREL(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaCOVAR
COVAR(data_y, data_x)
Calculates the covariance of a dataset. Learn more
Analisi dati
Apri schedaCOVARIANCE.P
COVARIANCE.P(data_y, data_x)
See COVAR
Analisi dati
Apri schedaCOVARIANCE.S
COVARIANCE.S(data_y, data_x)
Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more.
Analisi dati
Apri schedaCRITBINOM
CRITBINOM(num_trials, prob_success, target_prob)
Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more
Analisi dati
Apri schedaDEVSQ
DEVSQ(value1, value2)
Calculates the sum of squares of deviations based on a sample. Learn more
Analisi dati
Apri schedaEXPON.DIST
EXPON.DIST(x, LAMBDA, cumulative)
Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. Learn more.
Analisi dati
Apri schedaEXPONDIST
EXPONDIST(x, LAMBDA, cumulative)
See EXPON.DIST
Analisi dati
Apri scheda