AI
AI() or Gemini()
Generates text, summarizes information, categorizes information, and accesses real-time information. Learn moreThis function is a Google Workspace with Gemini feature
Automazione
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.
113 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
ARRAY_CONSTRAIN
ARRAY_CONSTRAIN(input_range, num_rows, num_cols)
Constrains an array result to a specified size. Learn more
Automazione
Apri schedaBYCOL
BYCOL(array_or_range, LAMBDA)
Groups an array by columns by application of a LAMBDA function to each column. Learn more
Automazione
Apri schedaBYROW
BYROW(array_or_range, LAMBDA)
Groups an array by rows by application of a LAMBDA function to each row. Learn more
Automazione
Apri schedaCHOOSECOLS
CHOOSECOLS(array, col_num1, [col_num2])
Creates a new array from the selected columns in the existing range. Learn more
Automazione
Apri schedaCHOOSEROWS
CHOOSEROWS(array, row_num1, [row_num2])
Creates a new array from the selected rows in the existing range. Learn more
Automazione
Apri schedaFLATTEN
FLATTEN(range1,[range2,...])
Flattens all the values from one or more ranges into a single column. Learn more
Automazione
Apri schedaFREQUENCY
FREQUENCY(data, classes)
Calculates the frequency distribution of a one-column array into specified classes. Learn more
Automazione
Apri schedaGROWTH
GROWTH(known_data_y, [known_data_x], [new_data_x], [b])
Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more
Automazione
Apri schedaHSTACK
HSTACK(range1; [range2, …])
Appends ranges horizontally and in sequence to return a larger array. Learn more
Automazione
Apri schedaLINEST
LINEST(known_data_y, [known_data_x], [calculate_b], [verbose])
Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more
Automazione
Apri schedaLOGEST
LOGEST(known_data_y, [known_data_x], [b], [verbose])
Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more
Automazione
Apri schedaMAKEARRAY
MAKEARRAY(rows, columns, LAMBDA)
Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn more
Automazione
Apri schedaMAP
MAP(array1, [array2, ...], LAMBDA)
Maps each value in the given arrays to a new value by application of a LAMBDA function to each value. Learn more
Automazione
Apri schedaMDETERM
MDETERM(square_matrix)
Returns the matrix determinant of a square matrix specified as an array or range. Learn more
Automazione
Apri schedaMINVERSE
MINVERSE(square_matrix)
Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more
Automazione
Apri schedaMMULT
MMULT(matrix1, matrix2)
Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
Automazione
Apri schedaREDUCE
REDUCE(initial_value, array_or_range, LAMBDA)
Reduces an array to an accumulated result by application of a LAMBDA function to each value. Learn more
Automazione
Apri schedaSCAN
SCAN(initial_value, array_or_range, LAMBDA)
Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step. Learn more
Automazione
Apri schedaSUMPRODUCT
SUMPRODUCT(array1, [array2, ...])
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more
Automazione
Apri schedaSUMX2MY2
SUMX2MY2(array_x, array_y)
Calculates the sum of the differences of the squares of values in two arrays. Learn more
Automazione
Apri schedaSUMX2PY2
SUMX2PY2(array_x, array_y)
Calculates the sum of the sums of the squares of values in two arrays. Learn more
Automazione
Apri schedaSUMXMY2
SUMXMY2(array_x, array_y)
Calculates the sum of the squares of differences of values in two arrays. Learn more
Automazione
Apri schedaTOCOL
TOCOL(array_or_range, [ignore], [scan_by_column])
Transforms an array or range of cells into a single column. Learn more
Automazione
Apri schedaTOROW
TOROW(array_or_range, [ignore], [scan_by_column])
Transforms an array or range of cells into a single row. Learn more
Automazione
Apri schedaTRANSPOSE
TRANSPOSE(array_or_range)
Transposes the rows and columns of an array or range of cells. Learn more
Automazione
Apri schedaTREND
TREND(known_data_y, [known_data_x], [new_data_x], [b])
Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more
Automazione
Apri schedaVSTACK
VSTACK(range1; [range2, …])
Appends ranges vertically and in sequence to return a larger array. Learn more
Automazione
Apri schedaWRAPCOLS
WRAPCOLS(range, wrap_count, [pad_with])
Wraps the provided row or column of cells by columns after a specified number of elements to form a new array. Learn more
Automazione
Apri schedaWRAPROWS
WRAPROWS(range, wrap_count, [pad_with])
Wraps the provided row or column of cells by rows after a specified number of elements to form a new array. Learn more
Automazione
Apri schedaDAVERAGE
DAVERAGE(database, field, criteria)
Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDCOUNT
DCOUNT(database, field, criteria)
Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDCOUNTA
DCOUNTA(database, field, criteria)
Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDGET
DGET(database, field, criteria)
Returns a single value from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDMAX
DMAX(database, field, criteria)
Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDMIN
DMIN(database, field, criteria)
Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDPRODUCT
DPRODUCT(database, field, criteria)
Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDSTDEV
DSTDEV(database, field, criteria)
Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDSTDEVP
DSTDEVP(database, field, criteria)
Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDSUM
DSUM(database, field, criteria)
Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDVAR
DVAR(database, field, criteria)
Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDVARP
DVARP(database, field, criteria)
Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaBIN2DEC
BIN2DEC(signed_binary_number)
Converts a signed binary number to decimal format. Learn more
Automazione
Apri schedaBIN2HEX
BIN2HEX(signed_binary_number, [significant_digits])
Converts a signed binary number to signed hexadecimal format. Learn more
Automazione
Apri schedaBIN2OCT
BIN2OCT(signed_binary_number, [significant_digits])
Converts a signed binary number to signed octal format. Learn more
Automazione
Apri schedaBITAND
BITAND(value1, value2)
Bitwise boolean AND of two numbers. Learn more.
Automazione
Apri schedaBITLSHIFT
BITLSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the left. Learn more.
Automazione
Apri schedaBITOR
BITOR(value1, value2)
Bitwise boolean OR of 2 numbers. Learn more.
Automazione
Apri schedaBITRSHIFT
BITRSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the right. Learn more.
Automazione
Apri schedaBITXOR
BITXOR(value1, value2)
Bitwise XOR (exclusive OR) of 2 numbers. Learn more.
Automazione
Apri schedaCOMPLEX
COMPLEX(real_part, imaginary_part, [suffix])
Creates a complex number given real and imaginary coefficients. Learn more
Automazione
Apri schedaDEC2BIN
DEC2BIN(decimal_number, [significant_digits])
Converts a decimal number to signed binary format. Learn more
Automazione
Apri schedaDEC2HEX
DEC2HEX(decimal_number, [significant_digits])
Converts a decimal number to signed hexadecimal format. Learn more
Automazione
Apri schedaDEC2OCT
DEC2OCT(decimal_number, [significant_digits])
Converts a decimal number to signed octal format. Learn more
Automazione
Apri schedaDELTA
DELTA(number1, [number2])
Compare two numeric values, returning 1 if they're equal. Learn more
Automazione
Apri schedaERF
ERF(lower_bound, [upper_bound])
The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.
Automazione
Apri schedaERF.PRECISE
ERF.PRECISE(lower_bound, [upper_bound])
See ERF
Automazione
Apri schedaGESTEP
GESTEP(value, [step])
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used. Learn more.
Automazione
Apri schedaHEX2BIN
HEX2BIN(signed_hexadecimal_number, [significant_digits])
Converts a signed hexadecimal number to signed binary format. Learn more
Automazione
Apri schedaHEX2DEC
HEX2DEC(signed_hexadecimal_number)
Converts a signed hexadecimal number to decimal format. Learn more
Automazione
Apri schedaHEX2OCT
HEX2OCT(signed_hexadecimal_number, significant_digits)
Converts a signed hexadecimal number to signed octal format. Learn more
Automazione
Apri schedaIMABS
IMABS(number)
Returns absolute value of a complex number. Learn more
Automazione
Apri schedaIMAGINARY
IMAGINARY(complex_number)
Returns the imaginary coefficient of a complex number. Learn more
Automazione
Apri schedaIMARGUMENT
IMARGUMENT(number)
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more.
Automazione
Apri schedaIMCONJUGATE
IMCONJUGATE(number)
Returns the complex conjugate of a number. Learn more
Automazione
Apri schedaIMCOS
IMCOS(number)
The IMCOS function returns the cosine of the given complex number. Learn more.
Automazione
Apri schedaIMCOSH
IMCOSH(number)
Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.
Automazione
Apri schedaIMCOT
IMCOT(number)
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.
Automazione
Apri schedaIMCOTH
IMCOTH(number)
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.
Automazione
Apri schedaIMCSC
IMCSC(number)
Returns the cosecant of the given complex number. Learn more.
Automazione
Apri schedaIMCSCH
IMCSCH(number)
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.
Automazione
Apri schedaIMDIV
IMDIV(dividend, divisor)
Returns one complex number divided by another. Learn more
Automazione
Apri schedaIMEXP
IMEXP(exponent)
Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
Automazione
Apri schedaIMLOG
IMLOG(value, base)
Returns the logarithm of a complex number for a specified base. Learn more.
Automazione
Apri schedaIMLOG10
IMLOG10(value)
Returns the logarithm of a complex number with base 10. Learn more.
Automazione
Apri schedaIMLOG2
IMLOG2(value)
Returns the logarithm of a complex number with base 2. Learn more.
Automazione
Apri schedaIMPRODUCT
IMPRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of complex numbers together. Learn more
Automazione
Apri schedaIMREAL
IMREAL(complex_number)
Returns the real coefficient of a complex number. Learn more
Automazione
Apri schedaIMSEC
IMSEC(number)
Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.
Automazione
Apri schedaIMSECH
IMSECH(number)
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.
Automazione
Apri schedaIMSIN
IMSIN (number)
Returns the sine of the given complex number. Learn more.
Automazione
Apri schedaIMSINH
IMSINH(number)
Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more.
Automazione
Apri schedaIMSUB
IMSUB(first_number, second_number)
Returns the difference between two complex numbers. Learn more
Automazione
Apri schedaIMSUM
IMSUM(value1, [value2, ...])
Returns the sum of a series of complex numbers. Learn more
Automazione
Apri schedaIMTAN
IMTAN(number)
Returns the tangent of the given complex number. Learn more.
Automazione
Apri schedaIMTANH
IMTANH(number)
Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more.
Automazione
Apri schedaOCT2BIN
OCT2BIN(signed_octal_number, [significant_digits])
Converts a signed octal number to signed binary format. Learn more
Automazione
Apri schedaOCT2DEC
OCT2DEC(signed_octal_number)
Converts a signed octal number to decimal format. Learn more
Automazione
Apri schedaOCT2HEX
OCT2HEX(signed_octal_number, [significant_digits])
Converts a signed octal number to signed hexadecimal format. Learn more
Automazione
Apri schedaARRAYFORMULA
ARRAYFORMULA(array_formula)
Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more
Automazione
Apri schedaGOOGLEFINANCE
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Fetches current or historical securities information from Google Finance. Learn more
Automazione Finance
Apri schedaQUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Automazione Marketing Analisi dati
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 schedaINDIRECT
INDIRECT(cell_reference_as_string, [is_A1_notation])
Returns a cell reference specified by a string. 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 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 schedaREGEXEXTRACT
REGEXEXTRACT(text, regular_expression)
Extracts matching substrings according to a regular expression. Learn more
Marketing
Apri schedaREGEXMATCH
REGEXMATCH(text, regular_expression)
Whether a piece of text matches a regular expression. Learn more
Marketing
Apri schedaREGEXREPLACE
REGEXREPLACE(text, regular_expression, replacement)
Replaces part of a text string with a different text string using regular expressions. Learn more
Marketing
Apri schedaENCODEURL
ENCODEURL(text)
Encodes a string of text for the purpose of using in a URL query. Learn more.
Automazione
Apri schedaHYPERLINK
HYPERLINK(url, [link_label])
Creates a hyperlink inside a cell. Learn more
Automazione
Apri schedaIMPORTDATA
IMPORTDATA(url)
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more
Automazione
Apri schedaIMPORTFEED
IMPORTFEED(url, [query], [headers], [num_items])
Imports a RSS or ATOM feed. Learn more
Automazione
Apri schedaIMPORTHTML
IMPORTHTML(url, query, index)
Imports data from a table or list within an HTML page. Learn more
Automazione
Apri schedaIMPORTRANGE
IMPORTRANGE(spreadsheet_url, range_string)
Imports a range of cells from a specified spreadsheet. Learn more
Automazione
Apri schedaIMPORTXML
IMPORTXML(url, xpath_query)
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more
Automazione Marketing
Apri schedaISURL
ISURL(value)
Checks whether a value is a valid URL. Learn more
Automazione
Apri scheda