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 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.
99 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 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 scheda