ROUNDDOWN
ROUNDDOWN(value, [places])
Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. 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.
515 formule trovate · pagina 7 di 11
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
ROUNDUP
ROUNDUP(value, [places])
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more
Analisi dati
Apri schedaSEC
SEC(angle)
The SEC function returns the secant of an angle, measured in radians. Learn more.
Analisi dati
Apri schedaSECH
SECH(value)
The SECH function returns the hyperbolic secant of an angle. Learn more
Analisi dati
Apri schedaSEQUENCE
SEQUENCE(rows, columns, start, step)
Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.
Analisi dati
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
Analisi dati
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
Analisi dati
Apri schedaSIN
SIN(angle)
Returns the sine of an angle provided in radians. Learn more
Analisi dati
Apri schedaSINH
SINH(value)
Returns the hyperbolic sine of any real number. Learn more
Analisi dati
Apri schedaSQRT
SQRT(value)
Returns the positive square root of a positive number. Learn more
Analisi dati
Apri schedaSQRTPI
SQRTPI(value)
Returns the positive square root of the product of Pi and the given positive number. Learn more
Analisi dati
Apri schedaSUBTOTAL
SUBTOTAL(function_code, range1, [range2, ...])
Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
Analisi dati
Apri schedaSUM
SUM(value1, [value2, ...])
Returns the sum of a series of numbers and/or cells. Learn more
Analisi dati
Apri schedaSUMIF
SUMIF(range, criterion, [sum_range])
Returns a conditional sum across a range. Learn more
Analisi dati Finance
Apri schedaSUMIFS
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the sum of a range depending on multiple criteria. Learn more
Analisi dati Finance
Apri schedaSUMSQ
SUMSQ(value1, [value2, ...])
Returns the sum of the squares of a series of numbers and/or cells. Learn more
Analisi dati
Apri schedaTAN
TAN(angle)
Returns the tangent of an angle provided in radians. Learn more
Analisi dati
Apri schedaTANH
TANH(value)
Returns the hyperbolic tangent of any real number. Learn more
Analisi dati
Apri schedaTRUNC
TRUNC(value, [places])
Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more
Analisi dati
Apri schedaADD
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 schedaUNIQUE
UNIQUE(range, by_column, exactly_once)
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more
Marketing Analisi dati
Apri schedaUPLUS
UPLUS(value)
Returns a specified number, unchanged. Learn more
Produttivita
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 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
AVERAGE(value1, [value2, ...])
Returns the numerical average value in a dataset, ignoring text. 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 scheda