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.
515 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 schedaDATE
DATE(year, month, day)
Converts a provided year, month, and day into a date. Learn more
Produttivita
Apri schedaDATEDIF
DATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates. Learn more
Produttivita
Apri schedaDATEVALUE
DATEVALUE(date_string)
Converts a provided date string in a known format to a date value. Learn more
Produttivita
Apri schedaDAY
DAY(date)
Returns the day of the month that a specific date falls on, in numeric format. Learn more
Produttivita
Apri schedaDAYS
DAYS(end_date, start_date)
Returns the number of days between two dates. Learn more.
Produttivita
Apri schedaDAYS360
DAYS360(start_date, end_date, [method])
Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more
Produttivita
Apri schedaEDATE
EDATE(start_date, months)
Returns a date a specified number of months before or after another date. Learn more
Produttivita
Apri schedaEOMONTH
EOMONTH(start_date, months)
Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more
Produttivita
Apri schedaEPOCHTODATE
EPOCHTODATE(timestamp, [unit])
Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. Learn more
Produttivita
Apri schedaHOUR
HOUR(time)
Returns the hour component of a specific time, in numeric format. Learn more
Produttivita
Apri schedaISOWEEKNUM
ISOWEEKNUM(date)
Returns the number of the ISO week of the year where the provided date falls. Learn more
Produttivita
Apri schedaMINUTE
MINUTE(time)
Returns the minute component of a specific time, in numeric format. Learn more
Produttivita
Apri schedaMONTH
MONTH(date)
Returns the month of the year a specific date falls in, in numeric format. Learn more
Produttivita
Apri schedaNETWORKDAYS
NETWORKDAYS(start_date, end_date, [holidays])
Returns the number of net working days between two provided days. Learn more
Produttivita
Apri schedaNETWORKDAYS.INTL
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Returns the number of net working days between two provided days excluding specified weekend days and holidays. Learn more
Produttivita
Apri schedaNOW
NOW()
Returns the current date and time as a date value. Learn more
Produttivita
Apri schedaSECOND
SECOND(time)
Returns the second component of a specific time, in numeric format. Learn more
Produttivita
Apri schedaTIME
TIME(hour, minute, second)
Converts a provided hour, minute, and second into a time. Learn more
Produttivita
Apri schedaTIMEVALUE
TIMEVALUE(time_string)
Returns the fraction of a 24-hour day the time represents. Learn more
Produttivita
Apri schedaTODAY
TODAY()
Returns the current date as a date value. Learn more
Produttivita
Apri schedaWEEKDAY
WEEKDAY(date, [type])
Returns a number representing the day of the week of the date provided. Learn more
Produttivita
Apri schedaWEEKNUM
WEEKNUM(date, [type])
Returns a number representing the week of the year where the provided date falls. Learn more
Produttivita
Apri schedaWORKDAY
WORKDAY(start_date, num_days, [holidays])
Calculates the end date after a specified number of working days. Learn more
Produttivita
Apri schedaWORKDAY.INTL
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more
Produttivita
Apri schedaYEAR
YEAR(date)
Returns the year specified by a given date. Learn more
Produttivita
Apri schedaYEARFRAC
YEARFRAC(start_date, end_date, [day_count_convention])
Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more
Produttivita
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 schedaFILTER
FILTER(range, condition1, [condition2])
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
Analisi dati Marketing Automazione
Apri schedaSORT
SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])
Sorts the rows of a given array or range by the values in one or more columns. Learn more
Analisi dati
Apri schedaSORTN
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
Returns the first n items in a data set after performing a sort. Learn more
Analisi dati
Apri schedaACCRINT
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Calculates the accrued interest of a security that has periodic payments. Learn more
Finance
Apri schedaACCRINTM
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity. Learn more
Finance
Apri schedaAMORLINC
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more.
Finance
Apri schedaCOUPDAYBS
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more
Finance
Apri schedaCOUPDAYS
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more
Finance
Apri schedaCOUPDAYSNC
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more
Finance
Apri schedaCOUPNCD
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date. Learn more
Finance
Apri schedaCOUPNUM
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more
Finance
Apri schedaCOUPPCD
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date. Learn more
Finance
Apri schedaCUMIPMT
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaCUMPRINC
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaDB
DB(cost, salvage, life, period, [month])
Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more
Finance
Apri schedaDDB
DDB(cost, salvage, life, period, [factor])
Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more
Finance
Apri schedaDISC
DISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the discount rate of a security based on price. Learn more
Finance
Apri schedaDOLLARDE
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal fraction into a decimal value. Learn more
Finance
Apri schedaDOLLARFR
DOLLARFR(decimal_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction. Learn more
Finance
Apri schedaDURATION
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more
Finance
Apri schedaEFFECT
EFFECT(nominal_rate, periods_per_year)
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more
Finance
Apri schedaFV
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaFVSCHEDULE
FVSCHEDULE(principal, rate_schedule)
Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more
Finance
Apri schedaINTRATE
INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])
Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. Learn more
Finance
Apri schedaIPMT
IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaIRR
IRR(cashflow_amounts, [rate_guess])
Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more
Finance
Apri schedaISPMT
ISPMT(rate, period, number_of_periods, present_value)
The ISPMT function calculates the interest paid during a particular period of an investment. Learn more.
Finance
Apri schedaMDURATION
MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])
Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaMIRR
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more
Finance
Apri schedaNOMINAL
NOMINAL(effective_rate, periods_per_year)
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more
Finance
Apri schedaNPER
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaNPV
NPV(discount, cashflow1, [cashflow2, ...])
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more
Finance
Apri schedaPDURATION
PDURATION(rate, present_value, future_value)
Returns the number of periods for an investment to reach a specific value at a given rate. Learn more.
Finance
Apri schedaPMT
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaPPMT
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaPRICE
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaPRICEDISC
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more
Finance
Apri schedaPRICEMAT
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
Calculates the price of a security paying interest at maturity, based on expected yield. Learn more
Finance
Apri schedaPV
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaRATE
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more
Finance
Apri schedaRECEIVED
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more
Finance
Apri schedaRRI
RRI(number_of_periods, present_value, future_value)
Returns the interest rate needed for an investment to reach a specific value within a given number of periods. Learn more.
Finance
Apri schedaSLN
SLN(cost, salvage, life)
Calculates the depreciation of an asset for one period using the straight-line method. Learn more
Finance
Apri schedaSYD
SYD(cost, salvage, life, period)
Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more
Finance
Apri schedaTBILLEQ
TBILLEQ(settlement, maturity, discount)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLPRICE
TBILLPRICE(settlement, maturity, discount)
Calculates the price of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLYIELD
TBILLYIELD(settlement, maturity, price)
Calculates the yield of a US Treasury Bill based on price. Learn more
Finance
Apri schedaVDB
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Returns the depreciation of an asset for a particular period (or partial period). Learn more.
Finance
Apri schedaXIRR
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more
Finance
Apri schedaXNPV
XNPV(discount, cashflow_amounts, cashflow_dates)
Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more
Finance
Apri schedaYIELD
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more
Finance
Apri schedaYIELDDISC
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more
Finance
Apri schedaYIELDMAT
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Calculates the annual yield of a security paying interest at maturity, based on price. Learn more
Finance
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 schedaDETECTLANGUAGE
DETECTLANGUAGE(text_or_range)
Identifies the language used in text within the specified range. 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 schedaGOOGLETRANSLATE
GOOGLETRANSLATE(text, [source_language], [target_language])
Translates text from one language into another Learn more
Automazione
Apri schedaIMAGE
IMAGE(url, [mode], [height], [width])
Inserts an image into a cell. Learn more
Automazione
Apri schedaQUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Automazione Marketing Analisi dati
Apri schedaSPARKLINE
SPARKLINE(data, [options])
Creates a miniature chart contained within a single cell. Learn more
Automazione
Apri schedaCELL
CELL(info_type, reference)
Returns the requested information about the specified cell. Learn more
Analisi dati
Apri schedaERROR.TYPE
ERROR.TYPE(reference)
Returns a number corresponding to the error value in a different cell. Learn more
Analisi dati
Apri schedaISBLANK
ISBLANK(value)
Checks whether the referenced cell is empty. Learn more
Analisi dati
Apri schedaISDATE
ISDATE(value)
Returns whether a value is a date. Learn more.
Analisi dati
Apri schedaISEMAIL
ISEMAIL(value)
Checks whether a value is a valid email address. Learn more
Analisi dati
Apri schedaISERR
ISERR(value)
Checks whether a value is an error other than `#N/A`. Learn more
Analisi dati
Apri schedaISERROR
ISERROR(value)
Checks whether a value is an error. Learn more
Analisi dati
Apri schedaISFORMULA
ISFORMULA(cell)
Checks whether a formula is in the referenced cell. Learn more
Analisi dati
Apri schedaISLOGICAL
ISLOGICAL(value)
Checks whether a value is `TRUE` or `FALSE`. Learn more
Analisi dati
Apri schedaISNA
ISNA(value)
Checks whether a value is the error `#N/A`. Learn more
Analisi dati
Apri schedaISNONTEXT
ISNONTEXT(value)
Checks whether a value is non-textual. Learn more
Analisi dati
Apri schedaISNUMBER
ISNUMBER(value)
Checks whether a value is a number. Learn more
Analisi dati
Apri schedaISREF
ISREF(value)
Checks whether a value is a valid cell reference. Learn more
Analisi dati
Apri schedaISTEXT
ISTEXT(value)
Checks whether a value is text. Learn more
Analisi dati
Apri schedaN
N(value)
Returns the argument provided as a number. Learn more
Analisi dati
Apri schedaNA
NA()
Returns the "value not available" error, `#N/A`. Learn more
Analisi dati
Apri schedaSHEETS
SHEETS(reference)
Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
Analisi dati
Apri schedaTYPE
TYPE(value)
Returns a number associated with the type of data passed into the function. Learn more
Analisi dati
Apri schedaAND
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 schedaCOSH
COSH(value)
Returns the hyperbolic cosine of any real number. Learn more
Analisi dati
Apri schedaCOT
COT(angle)
Cotangent of an angle provided in radians. Learn more.
Analisi dati
Apri schedaCOTH
COTH(value)
Returns the hyperbolic cotangent of any real number. Learn more.
Analisi dati
Apri schedaCOUNTBLANK
COUNTBLANK(range)
Returns the number of empty cells in a given range. Learn more
Analisi dati
Apri schedaCOUNTIF
COUNTIF(range, criterion)
Returns a conditional count across a range. Learn more
Analisi dati Marketing
Apri schedaCOUNTIFS
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the count of a range depending on multiple criteria. Learn more
Analisi dati Marketing
Apri schedaCOUNTUNIQUE
COUNTUNIQUE(value1, [value2, ...])
Counts the number of unique values in a list of specified values and ranges. Learn more
Analisi dati
Apri schedaCSC
CSC(angle)
Returns the cosecant of an angle provided in radians. Learn more.
Analisi dati
Apri schedaCSCH
CSCH(value)
The CSCH function returns the hyperbolic cosecant of any real number. Learn more.
Analisi dati
Apri schedaDECIMAL
DECIMAL(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
DEGREES(angle)
Converts an angle value in radians to degrees. Learn more
Analisi dati
Apri schedaERFC
ERFC(z)
Returns the complementary Gauss error function of a value. Learn more
Analisi dati
Apri schedaERFC.PRECISE
ERFC.PRECISE(z)
See ERFC
Analisi dati
Apri schedaEVEN
EVEN(value)
Rounds a number up to the nearest even integer. Learn more
Analisi dati
Apri schedaEXP
EXP(exponent)
Returns Euler's number, e (~2.718) raised to a power. Learn more
Analisi dati
Apri schedaFACT
FACT(value)
Returns the factorial of a number. Learn more
Analisi dati
Apri schedaFACTDOUBLE
FACTDOUBLE(value)
Returns the "double factorial" of a number. Learn more
Analisi dati
Apri schedaFLOOR
FLOOR(value, [factor])
Rounds a number down to the nearest integer multiple of specified significance. Learn more
Analisi dati
Apri schedaFLOOR.MATH
FLOOR.MATH(number, [significance], [mode])
Rounds a number down 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 schedaFLOOR.PRECISE
FLOOR.PRECISE(number, [significance])
The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more.
Analisi dati
Apri schedaGAMMALN
GAMMALN(value)
Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more
Analisi dati
Apri schedaGAMMALN.PRECISE
GAMMALN.PRECISE(value)
See GAMMALN
Analisi dati
Apri schedaGCD
GCD(value1, value2)
Returns the greatest common divisor of one or more integers. Learn more
Analisi dati
Apri schedaIMLN
IMLN(complex_value)
Returns the logarithm of a complex number, base e (Euler's number). Learn more
Analisi dati
Apri schedaIMPOWER
IMPOWER(complex_base, exponent)
Returns a complex number raised to a power. Learn more
Analisi dati
Apri schedaIMSQRT
IMSQRT(complex_number)
Computes the square root of a complex number. Learn more
Analisi dati
Apri schedaINT
INT(value)
Rounds a number down to the nearest integer that is less than or equal to it. Learn more
Analisi dati
Apri schedaISEVEN
ISEVEN(value)
Checks whether the provided value is even. Learn more
Analisi dati
Apri schedaISO.CEILING
ISO.CEILING(number, [significance])
See CEILING.PRECISE
Analisi dati
Apri schedaISODD
ISODD(value)
Checks whether the provided value is odd. Learn more
Analisi dati
Apri schedaLCM
LCM(value1, value2)
Returns the least common multiple of one or more integers. Learn more
Analisi dati
Apri schedaLN
LN(value)
Returns the the logarithm of a number, base e (Euler's number). Learn more
Analisi dati
Apri schedaLOG
LOG(value, base)
Returns the the logarithm of a number given a base. Learn more
Analisi dati
Apri schedaLOG10
LOG10(value)
Returns the the logarithm of a number, base 10. Learn more
Analisi dati
Apri schedaMOD
MOD(dividend, divisor)
Returns the result of the modulo operator, the remainder after a division operation. Learn more
Analisi dati
Apri schedaMROUND
MROUND(value, factor)
Rounds one number to the nearest integer multiple of another. Learn more
Analisi dati
Apri schedaMULTINOMIAL
MULTINOMIAL(value1, value2)
Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more
Analisi dati
Apri schedaMUNIT
MUNIT(dimension)
Returns a unit matrix of size dimension x dimension. Learn more.
Analisi dati
Apri schedaODD
ODD(value)
Rounds a number up to the nearest odd integer. Learn more
Analisi dati
Apri schedaPI
PI()
Returns the value of Pi to 14 decimal places. Learn more
Analisi dati
Apri schedaPOWER
POWER(base, exponent)
Returns a number raised to a power. Learn more
Analisi dati
Apri schedaPRODUCT
PRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of numbers together. Learn more
Analisi dati
Apri schedaQUOTIENT
QUOTIENT(dividend, divisor)
Returns one number divided by another. Learn more
Analisi dati
Apri schedaRADIANS
RADIANS(angle)
Converts an angle value in degrees to radians. Learn more
Analisi dati
Apri schedaRAND
RAND()
Returns a random number between 0 inclusive and 1 exclusive. Learn more
Analisi dati
Apri schedaRANDARRAY
RANDARRAY(rows, columns)
Generates an array of random numbers between 0 and 1. Learn more.
Analisi dati
Apri schedaRANDBETWEEN
RANDBETWEEN(low, high)
Returns a uniformly random integer between two values, inclusive. Learn more
Analisi dati
Apri schedaROUND
ROUND(value, [places])
Rounds a number to a certain number of decimal places according to standard rules. Learn more
Analisi dati
Apri schedaROUNDDOWN
ROUNDDOWN(value, [places])
Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more
Analisi dati
Apri schedaROUNDUP
ROUNDUP(value, [places])
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more
Analisi dati
Apri schedaSEC
SEC(angle)
The SEC function returns the secant of an angle, measured in radians. Learn more.
Analisi dati
Apri schedaSECH
SECH(value)
The SECH function returns the hyperbolic secant of an angle. Learn more
Analisi dati
Apri schedaSEQUENCE
SEQUENCE(rows, columns, start, step)
Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.
Analisi dati
Apri schedaSERIESSUM
SERIESSUM(x, n, m, a)
Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`. Learn more
Analisi dati
Apri schedaSIGN
SIGN(value)
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Learn more
Analisi dati
Apri schedaSIN
SIN(angle)
Returns the sine of an angle provided in radians. Learn more
Analisi dati
Apri schedaSINH
SINH(value)
Returns the hyperbolic sine of any real number. Learn more
Analisi dati
Apri schedaSQRT
SQRT(value)
Returns the positive square root of a positive number. Learn more
Analisi dati
Apri schedaSQRTPI
SQRTPI(value)
Returns the positive square root of the product of Pi and the given positive number. Learn more
Analisi dati
Apri schedaSUBTOTAL
SUBTOTAL(function_code, range1, [range2, ...])
Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
Analisi dati
Apri schedaSUM
SUM(value1, [value2, ...])
Returns the sum of a series of numbers and/or cells. Learn more
Analisi dati
Apri schedaSUMIF
SUMIF(range, criterion, [sum_range])
Returns a conditional sum across a range. Learn more
Analisi dati Finance
Apri schedaSUMIFS
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the sum of a range depending on multiple criteria. Learn more
Analisi dati Finance
Apri schedaSUMSQ
SUMSQ(value1, [value2, ...])
Returns the sum of the squares of a series of numbers and/or cells. Learn more
Analisi dati
Apri schedaTAN
TAN(angle)
Returns the tangent of an angle provided in radians. Learn more
Analisi dati
Apri schedaTANH
TANH(value)
Returns the hyperbolic tangent of any real number. Learn more
Analisi dati
Apri schedaTRUNC
TRUNC(value, [places])
Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more
Analisi dati
Apri schedaADD
ADD(value1, value2)
Returns the sum of two numbers. Equivalent to the `+` operator. Learn more
Produttivita
Apri schedaCONCAT
CONCAT(value1, value2)
Returns the concatenation of two values. Equivalent to the `&` operator. Learn more
Produttivita
Apri schedaDIVIDE
DIVIDE(dividend, divisor)
Returns one number divided by another. Equivalent to the `/` operator. Learn more
Produttivita
Apri schedaEQ
EQ(value1, value2)
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more
Produttivita
Apri schedaGT
GT(value1, value2)
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more
Produttivita
Apri schedaGTE
GTE(value1, value2)
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn more
Produttivita
Apri schedaISBETWEEN
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn more
Produttivita
Apri schedaLT
LT(value1, value2)
Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more
Produttivita
Apri schedaLTE
LTE(value1, value2)
Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn more
Produttivita
Apri schedaMINUS
MINUS(value1, value2)
Returns the difference of two numbers. Equivalent to the `-` operator. Learn more
Produttivita
Apri schedaMULTIPLY
MULTIPLY(factor1, factor2)
Returns the product of two numbers. Equivalent to the `*` operator. Learn more
Produttivita
Apri schedaNE
NE(value1, value2)
Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn more
Produttivita
Apri schedaPOW
POW(base, exponent)
Returns a number raised to a power. Learn more
Produttivita
Apri schedaUMINUS
UMINUS(value)
Returns a number with the sign reversed. Learn more
Produttivita
Apri schedaUNARY_PERCENT
UNARY_PERCENT(percentage)
Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more
Produttivita
Apri schedaUNIQUE
UNIQUE(range, by_column, exactly_once)
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more
Marketing Analisi dati
Apri schedaUPLUS
UPLUS(value)
Returns a specified number, unchanged. Learn more
Produttivita
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 schedaAVEDEV
AVEDEV(value1, [value2, ...])
Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more
Analisi dati
Apri schedaAVERAGE
AVERAGE(value1, [value2, ...])
Returns the numerical average value in a dataset, ignoring text. Learn more
Analisi dati
Apri schedaAVERAGE.WEIGHTED
AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more.
Analisi dati
Apri schedaAVERAGEA
AVERAGEA(value1, [value2, ...])
Returns the numerical average value in a dataset. Learn more
Analisi dati
Apri schedaAVERAGEIF
AVERAGEIF(criteria_range, criterion, [average_range])
Returns the average of a range depending on criteria. Learn more
Analisi dati
Apri schedaAVERAGEIFS
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the average of a range depending on multiple criteria. Learn more
Analisi dati
Apri schedaBETA.DIST
BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)
Returns the probability of a given value as defined by the beta distribution function. Learn more.
Analisi dati
Apri schedaBETA.INV
BETA.INV(probability, alpha, beta, lower_bound, upper_bound)
Returns the value of the inverse beta distribution function for a given probability. Learn more.
Analisi dati
Apri schedaBETADIST
BETADIST(value, alpha, beta, lower_bound, upper_bound)
See BETA.DIST.
Analisi dati
Apri schedaBETAINV
BETAINV(probability, alpha, beta, lower_bound, upper_bound)
See BETA.INV
Analisi dati
Apri schedaBINOM.DIST
BINOM.DIST(num_successes, num_trials, prob_success, cumulative)
See BINOMDIST
Analisi dati
Apri schedaBINOM.INV
BINOM.INV(num_trials, prob_success, target_prob)
See CRITBINOM
Analisi dati
Apri schedaBINOMDIST
BINOMDIST(num_successes, num_trials, prob_success, cumulative)
Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more
Analisi dati
Apri schedaCHIDIST
CHIDIST(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHIINV
CHIINV(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.DIST
CHISQ.DIST(x, degrees_freedom, cumulative)
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHISQ.DIST.RT
CHISQ.DIST.RT(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHISQ.INV
CHISQ.INV(probability, degrees_freedom)
Calculates the inverse of the left-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.INV.RT
CHISQ.INV.RT(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.TEST
CHISQ.TEST(observed_range, expected_range)
See CHITEST
Analisi dati
Apri schedaCHITEST
CHITEST(observed_range, expected_range)
Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more
Analisi dati
Apri schedaCONFIDENCE
CONFIDENCE(alpha, standard_deviation, pop_size)
See CONFIDENCE.NORM
Analisi dati
Apri schedaCONFIDENCE.NORM
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a normal distribution. Learn more.
Analisi dati
Apri schedaCONFIDENCE.T
CONFIDENCE.T(alpha, standard_deviation, size)
Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more.
Analisi dati
Apri schedaCORREL
CORREL(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaCOUNT
COUNT(value1, [value2, ...])
Returns a count of the number of numeric values in a dataset. Learn more
Analisi dati
Apri schedaCOUNTA
COUNTA(value1, [value2, ...])
Returns a count of the number of values in a dataset. Learn more
Analisi dati
Apri schedaCOVAR
COVAR(data_y, data_x)
Calculates the covariance of a dataset. Learn more
Analisi dati
Apri schedaCOVARIANCE.P
COVARIANCE.P(data_y, data_x)
See COVAR
Analisi dati
Apri schedaCOVARIANCE.S
COVARIANCE.S(data_y, data_x)
Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more.
Analisi dati
Apri schedaCRITBINOM
CRITBINOM(num_trials, prob_success, target_prob)
Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more
Analisi dati
Apri schedaDEVSQ
DEVSQ(value1, value2)
Calculates the sum of squares of deviations based on a sample. Learn more
Analisi dati
Apri schedaEXPON.DIST
EXPON.DIST(x, LAMBDA, cumulative)
Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. Learn more.
Analisi dati
Apri schedaEXPONDIST
EXPONDIST(x, LAMBDA, cumulative)
See EXPON.DIST
Analisi dati
Apri schedaF.DIST
F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)
Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more
Analisi dati
Apri schedaF.DIST.RT
F.DIST.RT(x, degrees_freedom1, degrees_freedom2)
Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more
Analisi dati
Apri schedaF.INV
F.INV(probability, degrees_freedom1, degrees_freedom2)
Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
Analisi dati
Apri schedaF.INV.RT
F.INV.RT(probability, degrees_freedom1, degrees_freedom2)
Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
Analisi dati
Apri schedaF.TEST
F.TEST(range1, range2)
See FTEST.
Analisi dati
Apri schedaFDIST
FDIST(x, degrees_freedom1, degrees_freedom2)
See F.DIST.RT.
Analisi dati
Apri schedaFINV
FINV(probability, degrees_freedom1, degrees_freedom2)
See F.INV.RT
Analisi dati
Apri schedaFISHER
FISHER(value)
Returns the Fisher transformation of a specified value. Learn more
Analisi dati
Apri schedaFISHERINV
FISHERINV(value)
Returns the inverse Fisher transformation of a specified value. Learn more
Analisi dati
Apri schedaFORECAST
FORECAST(x, data_y, data_x)
Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more
Analisi dati
Apri schedaFORECAST.LINEAR
FORECAST.LINEAR(x, data_y, data_x)
See FORECAST
Analisi dati
Apri schedaFTEST
FTEST(range1, range2)
Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance. Learn more
Analisi dati
Apri schedaGAMMA
GAMMA(number)
Returns the Gamma function evaluated at the specified value. Learn more.
Analisi dati
Apri schedaGAMMA.DIST
GAMMA.DIST(x, alpha, beta, cumulative)
Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more
Analisi dati
Apri schedaGAMMA.INV
GAMMA.INV(probability, alpha, beta)
The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more.
Analisi dati
Apri schedaGAMMADIST
GAMMADIST(x, alpha, beta, cumulative)
See GAMMA.DIST
Analisi dati
Apri schedaGAMMAINV
GAMMAINV(probability, alpha, beta)
See GAMMA.INV.
Analisi dati
Apri schedaGAUSS
GAUSS(z)
The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more.
Analisi dati
Apri schedaGEOMEAN
GEOMEAN(value1, value2)
Calculates the geometric mean of a dataset. Learn more
Analisi dati
Apri schedaHARMEAN
HARMEAN(value1, value2)
Calculates the harmonic mean of a dataset. Learn more
Analisi dati
Apri schedaHYPGEOM.DIST
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
See HYPGEOMDIST
Analisi dati
Apri schedaHYPGEOMDIST
HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws. Learn more
Analisi dati
Apri schedaINTERCEPT
INTERCEPT(data_y, data_x)
Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more
Analisi dati
Apri schedaKURT
KURT(value1, value2)
Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more
Analisi dati
Apri schedaLARGE
LARGE(data, n)
Returns the nth largest element from a data set, where n is user-defined. Learn more
Analisi dati
Apri schedaLOGINV
LOGINV(x, mean, standard_deviation)
Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
Analisi dati
Apri schedaLOGNORM.DIST
LOGNORM.DIST(x, mean, standard_deviation)
See LOGNORMDIST
Analisi dati
Apri schedaLOGNORM.INV
LOGNORM.INV(x, mean, standard_deviation)
See LOGINV
Analisi dati
Apri schedaLOGNORMDIST
LOGNORMDIST(x, mean, standard_deviation)
Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
Analisi dati
Apri schedaMARGINOFERROR
MARGINOFERROR(range, confidence)
Calculates the amount of random sampling error given a range of values and a confidence level. Learn more
Analisi dati
Apri schedaMAX
MAX(value1, [value2, ...])
Returns the maximum value in a numeric dataset. Learn more
Analisi dati
Apri schedaMAXA
MAXA(value1, value2)
Returns the maximum numeric value in a dataset. Learn more
Analisi dati
Apri schedaMAXIFS
MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Returns the maximum value in a range of cells, filtered by a set of criteria. Learn more.
Analisi dati
Apri schedaMEDIAN
MEDIAN(value1, [value2, ...])
Returns the median value in a numeric dataset. Learn more
Analisi dati
Apri schedaMIN
MIN(value1, [value2, ...])
Returns the minimum value in a numeric dataset. Learn more
Analisi dati
Apri schedaMINA
MINA(value1, value2)
Returns the minimum numeric value in a dataset. Learn more
Analisi dati
Apri schedaMINIFS
MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more.
Analisi dati
Apri schedaMODE
MODE(value1, [value2, ...])
Returns the most commonly occurring value in a dataset. Learn more
Analisi dati
Apri schedaMODE.MULT
MODE.MULT(value1, value2)
Returns the most commonly occurring values in a dataset. Learn more.
Analisi dati
Apri schedaMODE.SNGL
MODE.SNGL(value1, [value2, ...])
See MODE
Analisi dati
Apri schedaNEGBINOM.DIST
NEGBINOM.DIST(num_failures, num_successes, prob_success)
See NEGBINOMDIST
Analisi dati
Apri schedaNEGBINOMDIST
NEGBINOMDIST(num_failures, num_successes, prob_success)
Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. Learn more
Analisi dati
Apri schedaNORM.DIST
NORM.DIST(x, mean, standard_deviation, cumulative)
See NORMDIST
Analisi dati
Apri schedaNORM.INV
NORM.INV(x, mean, standard_deviation)
See NORMINV
Analisi dati
Apri schedaNORM.S.DIST
NORM.S.DIST(x)
See NORMSDIST
Analisi dati
Apri schedaNORM.S.INV
NORM.S.INV(x)
See NORMSINV
Analisi dati
Apri schedaNORMDIST
NORMDIST(x, mean, standard_deviation, cumulative)
Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation. Learn more
Analisi dati
Apri schedaNORMINV
NORMINV(x, mean, standard_deviation)
Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more
Analisi dati
Apri schedaNORMSDIST
NORMSDIST(x)
Returns the value of the standard normal cumulative distribution function for a specified value. Learn more
Analisi dati
Apri schedaNORMSINV
NORMSINV(x)
Returns the value of the inverse standard normal distribution function for a specified value. Learn more
Analisi dati
Apri schedaPEARSON
PEARSON(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaPERCENTILE
PERCENTILE(data, percentile)
Returns the value at a given percentile of a dataset. Learn more
Analisi dati
Apri schedaPERCENTILE.EXC
PERCENTILE.EXC(data, percentile)
Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more.
Analisi dati
Apri schedaPERCENTILE.INC
PERCENTILE.INC(data, percentile)
See PERCENTILE
Analisi dati
Apri schedaPERCENTRANK
PERCENTRANK(data, value, [significant_digits])
Returns the percentage rank (percentile) of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERCENTRANK.EXC
PERCENTRANK.EXC(data, value, [significant_digits])
Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERCENTRANK.INC
PERCENTRANK.INC(data, value, [significant_digits])
Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERMUT
PERMUT(n, k)
Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. Learn more
Analisi dati
Apri schedaPERMUTATIONA
PERMUTATIONA(number, number_chosen)
Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more.
Analisi dati
Apri schedaPHI
PHI(x)
The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.
Analisi dati
Apri schedaPOISSON
POISSON(x, mean, cumulative)
See POISSON.DIST
Analisi dati
Apri schedaPOISSON.DIST
POISSON.DIST(x, mean, [cumulative])
Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more.
Analisi dati
Apri schedaPROB
PROB(data, probabilities, low_limit, [high_limit])
Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits. Learn more
Analisi dati
Apri schedaQUARTILE
QUARTILE(data, quartile_number)
Returns a value nearest to a specified quartile of a dataset. Learn more
Analisi dati
Apri schedaQUARTILE.EXC
QUARTILE.EXC(data, quartile_number)
Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more.
Analisi dati
Apri schedaQUARTILE.INC
QUARTILE.INC(data, quartile_number)
See QUARTILE
Analisi dati
Apri schedaRANK
RANK(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. Learn more
Analisi dati
Apri schedaRANK.AVG
RANK.AVG(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Learn more
Analisi dati
Apri schedaRANK.EQ
RANK.EQ(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Learn more
Analisi dati
Apri schedaRSQ
RSQ(data_y, data_x)
Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaSKEW
SKEW(value1, value2)
Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more
Analisi dati
Apri schedaSKEW.P
SKEW.P(value1, value2)
Calculates the skewness of a dataset that represents the entire population. Learn more.
Analisi dati
Apri schedaSLOPE
SLOPE(data_y, data_x)
Calculates the slope of the line resulting from linear regression of a dataset. Learn more
Analisi dati
Apri schedaSMALL
SMALL(data, n)
Returns the nth smallest element from a data set, where n is user-defined. Learn more
Analisi dati
Apri schedaSTANDARDIZE
STANDARDIZE(value, mean, standard_deviation)
Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more
Analisi dati
Apri schedaSTDEV
STDEV(value1, [value2, ...])
Calculates the standard deviation based on a sample. Learn more
Analisi dati
Apri schedaSTDEV.P
STDEV.P(value1, [value2, ...])
See STDEVP
Analisi dati
Apri schedaSTDEV.S
STDEV.S(value1, [value2, ...])
See STDEV
Analisi dati
Apri schedaSTDEVA
STDEVA(value1, value2)
Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more
Analisi dati
Apri schedaSTDEVP
STDEVP(value1, value2)
Calculates the standard deviation based on an entire population. Learn more
Analisi dati
Apri schedaSTDEVPA
STDEVPA(value1, value2)
Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more
Analisi dati
Apri schedaSTEYX
STEYX(data_y, data_x)
Calculates the standard error of the predicted y-value for each x in the regression of a dataset. Learn more
Analisi dati
Apri schedaT.DIST
T.DIST(x, degrees_freedom, cumulative)
Returns the right tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.DIST.2T
T.DIST.2T(x, degrees_freedom)
Returns the two tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.DIST.RT
T.DIST.RT(x, degrees_freedom)
Returns the right tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.INV
T.INV(probability, degrees_freedom)
Calculates the negative inverse of the one-tailed TDIST function. Learn more
Analisi dati
Apri schedaT.INV.2T
T.INV.2T(probability, degrees_freedom)
Calculates the inverse of the two-tailed TDIST function. Learn more
Analisi dati
Apri schedaT.TEST
T.TEST(range1, range2, tails, type)
Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more.
Analisi dati
Apri schedaTDIST
TDIST(x, degrees_freedom, tails)
Calculates the probability for Student's t-distribution with a given input (x). Learn more
Analisi dati
Apri schedaTINV
TINV(probability, degrees_freedom)
See T.INV.2T
Analisi dati
Apri schedaTRIMMEAN
TRIMMEAN(data, exclude_proportion)
Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. Learn more
Analisi dati
Apri schedaTTEST
TTEST(range1, range2, tails, type)
See T.TEST.
Analisi dati
Apri schedaVAR
VAR(value1, [value2, ...])
Calculates the variance based on a sample. Learn more
Analisi dati
Apri schedaVAR.P
VAR.P(value1, [value2, ...])
See VARP
Analisi dati
Apri schedaVAR.S
VAR.S(value1, [value2, ...])
See VAR
Analisi dati
Apri schedaVARA
VARA(value1, value2)
Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more
Analisi dati
Apri schedaVARP
VARP(value1, value2)
Calculates the variance based on an entire population. Learn more
Analisi dati
Apri schedaVARPA
VARPA(value1, value2,...)
Calculates the variance based on an entire population, setting text to the value `0`. Learn more
Analisi dati
Apri schedaWEIBULL
WEIBULL(x, shape, scale, cumulative)
Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Learn more
Analisi dati
Apri schedaWEIBULL.DIST
WEIBULL.DIST(x, shape, scale, cumulative)
See WEIBULL
Analisi dati
Apri schedaZ.TEST
Z.TEST(data, value, [standard_deviation])
Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.
Analisi dati
Apri schedaZTEST
ZTEST(data, value, [standard_deviation])
See Z.TEST.
Analisi dati
Apri schedaARABIC
ARABIC(roman_numeral)
Computes the value of a Roman numeral. Learn more
Marketing
Apri schedaASC
ASC(text)
Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.
Marketing
Apri schedaCHAR
CHAR(table_number)
Convert a number into a character according to the current Unicode table. Learn more
Marketing
Apri schedaCLEAN
CLEAN(text)
Returns the text with the non-printable ASCII characters removed. Learn more
Marketing
Apri schedaCODE
CODE(string)
Returns the numeric Unicode map value of the first character in the string provided. Learn more
Marketing
Apri schedaCONCATENATE
CONCATENATE(string1, [string2, ...])
Appends strings to one another. Learn more
Marketing
Apri schedaDOLLAR
DOLLAR(number, [number_of_places])
Formats a number into the locale-specific currency format. Learn more
Marketing
Apri schedaEXACT
EXACT(string1, string2)
Tests whether two strings are identical. Learn more
Marketing
Apri schedaFIND
FIND(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Marketing
Apri schedaFINDB
FINDB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Marketing
Apri schedaFIXED
FIXED(number, [number_of_places], [suppress_separator])
Formats a number with a fixed number of decimal places. Learn more
Marketing
Apri schedaJOIN
JOIN(delimiter, value_or_array1, [value_or_array2, ...])
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more
Marketing
Apri schedaLEFT
LEFT(string, [number_of_characters])
Returns a substring from the beginning of a specified string. Learn more
Marketing
Apri schedaLEFTB
LEFTB(string, num_of_bytes)
Returns the left portion of a string up to a certain number of bytes. Learn more.
Marketing
Apri schedaLEN
LEN(text)
Returns the length of a string. Learn more
Marketing
Apri schedaLENB
LENB(string)
Returns the length of a string in bytes." Learn more.
Marketing
Apri schedaLOWER
LOWER(text)
Converts a specified string to lowercase. Learn more
Marketing
Apri schedaMID
MID(string, starting_at, extract_length)
Returns a segment of a string. Learn more
Marketing
Apri schedaMIDB
MIDB(string)
Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more.
Marketing
Apri schedaPROPER
PROPER(text_to_capitalize)
Capitalizes each word in a specified string. Learn more
Marketing
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 schedaREPLACE
REPLACE(text, position, length, new_text)
Replaces part of a text string with a different text string. Learn more
Marketing
Apri schedaREPLACEB
REPLACEB(text, position, num_bytes, new_text)
Replaces part of a text string, based on a number of bytes, with a different text string. Learn more.
Marketing
Apri schedaREPT
REPT(text_to_repeat, number_of_repetitions)
Returns specified text repeated a number of times. Learn more
Marketing
Apri schedaRIGHT
RIGHT(string, [number_of_characters])
Returns a substring from the end of a specified string. Learn more
Marketing
Apri schedaRIGHTB
RIGHTB(string, num_of_bytes)
Returns the right portion of a string up to a certain number of bytes. Learn more.
Marketing
Apri schedaROMAN
ROMAN(number, [rule_relaxation])
Formats a number in Roman numerals. Learn more
Marketing
Apri schedaSEARCH
SEARCH(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Marketing
Apri schedaSEARCHB
SEARCHB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Marketing
Apri schedaSPLIT
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Learn more
Marketing
Apri schedaSUBSTITUTE
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Replaces existing text with new text in a string. Learn more
Marketing
Apri schedaT
T(value)
Returns string arguments as text. Learn more
Marketing
Apri schedaTEXT
TEXT(number, format)
Converts a number into text according to a specified format. Learn more
Marketing
Apri schedaTEXTJOIN
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. Learn more.
Marketing
Apri schedaTRIM
TRIM(text)
Removes leading and trailing spaces in a specified string. Learn more
Marketing
Apri schedaUNICHAR
UNICHAR(number)
Returns the Unicode character for a number. Learn more.
Marketing
Apri schedaUNICODE
UNICODE(text)
Returns the decimal Unicode value of the first character of the text. Learn more.
Marketing
Apri schedaUPPER
UPPER(text)
Converts a specified string to uppercase. Learn more
Marketing
Apri schedaVALUE
VALUE(text)
Converts a string in any of the date, time or number formats that Google Sheets understands into a number. 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