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 · pagina 1 di 3
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 scheda