TYPE
TYPE(value)
Returns a number associated with the type of data passed into the function. Learn more
Analisi dati
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
515 formule trovate · pagina 5 di 11
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
AND
AND(logical_expression1, [logical_expression2, ...])
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more
Produttivita
Apri schedaFALSE
FALSE()
Returns the logical value `FALSE`. Learn more
Produttivita
Apri schedaIF
IF(logical_expression, value_if_true, value_if_false)
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more
Produttivita
Apri schedaIFERROR
IFERROR(value, [value_if_error])
Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Learn more
Produttivita
Apri schedaIFNA
IFNA(value, value_if_na)
Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.
Produttivita
Apri schedaIFS
IFS(condition1, value1, [condition2, value2], …)
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.
Produttivita
Apri schedaLAMBDA
LAMBDA(name, formula_expression)
Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn more
Produttivita
Apri schedaLET
LET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression )
Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times. Learn more
Produttivita
Apri schedaNOT
NOT(logical_expression)
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more
Produttivita
Apri schedaOR
OR(logical_expression1, [logical_expression2, ...])
Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more
Produttivita
Apri schedaSWITCH
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
TRUE()
Returns the logical value `TRUE`. Learn more
Produttivita
Apri schedaXOR
XOR(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
ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Returns a cell reference as a string. Learn more
Analisi dati
Apri schedaCHOOSE
CHOOSE(index, choice1, [choice2, ...])
Returns an element from a list of choices based on index. Learn more
Analisi dati
Apri schedaCOLUMN
COLUMN([cell_reference])
Returns the column number of a specified cell, with `A=1`. Learn more
Analisi dati
Apri schedaCOLUMNS
COLUMNS(range)
Returns the number of columns in a specified array or range. Learn more
Analisi dati
Apri schedaFORMULATEXT
FORMULATEXT(cell)
Returns the formula as a string. Learn more.
Analisi dati
Apri schedaGETPIVOTDATA
GETPIVOTDATA(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
HLOOKUP(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
INDEX(reference, [row], [column])
Returns the content of a cell, specified by row and column offset. Learn more
Analisi dati
Apri schedaINDIRECT
INDIRECT(cell_reference_as_string, [is_A1_notation])
Returns a cell reference specified by a string. Learn more
Analisi dati
Apri schedaLOOKUP
LOOKUP(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
MATCH(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 schedaOFFSET
OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more
Analisi dati
Apri schedaROW
ROW([cell_reference])
Returns the row number of a specified cell. Learn more
Analisi dati
Apri schedaROWS
ROWS(range)
Returns the number of rows in a specified array or range. Learn more
Analisi dati
Apri schedaSHEET
SHEET(value)
Returns the sheet number of the specified sheet or other reference. Learn more about the SHEET function.
Analisi dati
Apri schedaVLOOKUP
VLOOKUP(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
XLOOKUP(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
ABS(value)
Returns the absolute value of a number. Learn more
Analisi dati
Apri schedaACOS
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 scheda