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 3 di 8
SWITCH(expression, case1, value1, [default or case2, value2], …)
Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more
Produttivita
Apri schedaTRUE()
Returns the logical value `TRUE`. Learn more
Produttivita
Apri schedaXOR(logical_expression1, [logical_expression2, ...])
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more.
Produttivita
Apri schedaADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Returns a cell reference as a string. Learn more
Analisi dati
Apri schedaCHOOSE(index, choice1, [choice2, ...])
Returns an element from a list of choices based on index. Learn more
Analisi dati
Apri schedaCOLUMN([cell_reference])
Returns the column number of a specified cell, with `A=1`. Learn more
Analisi dati
Apri schedaCOLUMNS(range)
Returns the number of columns in a specified array or range. Learn more
Analisi dati
Apri schedaFORMULATEXT(cell)
Returns the formula as a string. Learn more.
Analisi dati
Apri schedaGETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Learn more
Analisi dati
Apri schedaHLOOKUP(search_key, range, index, [is_sorted])
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more
Analisi dati
Apri schedaINDEX(reference, [row], [column])
Returns the content of a cell, specified by row and column offset. Learn more
Analisi dati
Apri schedaLOOKUP(search_key, search_range|search_result_array, [result_range])
Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more
Analisi dati
Apri schedaMATCH(search_key, range, [search_type])
Returns the relative position of an item in a range that matches a specified value. Learn more
Analisi dati
Apri schedaROW([cell_reference])
Returns the row number of a specified cell. Learn more
Analisi dati
Apri schedaROWS(range)
Returns the number of rows in a specified array or range. Learn more
Analisi dati
Apri schedaSHEET(value)
Returns the sheet number of the specified sheet or other reference. Learn more about the SHEET function.
Analisi dati
Apri schedaVLOOKUP(search_key, range, index, [is_sorted])
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more
Analisi dati
Apri schedaXLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match. Learn more
Analisi dati
Apri schedaABS(value)
Returns the absolute value of a number. Learn more
Analisi dati
Apri schedaACOS(value)
Returns the inverse cosine of a value, in radians. Learn more
Analisi dati
Apri schedaACOSH(value)
Returns the inverse hyperbolic cosine of a number. Learn more
Analisi dati
Apri schedaACOT(value)
Returns the inverse cotangent of a value, in radians. Learn more.
Analisi dati
Apri schedaACOTH(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(value)
Returns the inverse sine of a value, in radians. Learn more
Analisi dati
Apri schedaASINH(value)
Returns the inverse hyperbolic sine of a number. Learn more
Analisi dati
Apri schedaATAN(value)
Returns the inverse tangent of a value, in radians. Learn more
Analisi dati
Apri schedaATAN2(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(value)
Returns the inverse hyperbolic tangent of a number. Learn more
Analisi dati
Apri schedaBASE(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(value, [factor])
Rounds a number up to the nearest integer multiple of specified significance. Learn more
Analisi dati
Apri schedaCEILING.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(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(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(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(angle)
Returns the cosine of an angle provided in radians. Learn more
Analisi dati
Apri schedaCOSH(value)
Returns the hyperbolic cosine of any real number. Learn more
Analisi dati
Apri schedaCOT(angle)
Cotangent of an angle provided in radians. Learn more.
Analisi dati
Apri schedaCOTH(value)
Returns the hyperbolic cotangent of any real number. Learn more.
Analisi dati
Apri schedaCOUNTIF(range, criterion)
Returns a conditional count across a range. Learn more
Analisi dati Marketing
Apri schedaCOUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the count of a range depending on multiple criteria. Learn more
Analisi dati Marketing
Apri schedaCOUNTUNIQUE(value1, [value2, ...])
Counts the number of unique values in a list of specified values and ranges. Learn more
Analisi dati
Apri schedaCSC(angle)
Returns the cosecant of an angle provided in radians. Learn more.
Analisi dati
Apri schedaCSCH(value)
The CSCH function returns the hyperbolic cosecant of any real number. Learn more.
Analisi dati
Apri schedaDECIMAL(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(angle)
Converts an angle value in radians to degrees. Learn more
Analisi dati
Apri schedaERFC(z)
Returns the complementary Gauss error function of a value. Learn more
Analisi dati
Apri schedaERFC.PRECISE(z)
See ERFC
Analisi dati
Apri schedaEVEN(value)
Rounds a number up to the nearest even integer. Learn more
Analisi dati
Apri scheda