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
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.
ARRAY_CONSTRAIN
ARRAY_CONSTRAIN(input_range, num_rows, num_cols)
Constrains an array result to a specified size. Learn more
Apri schedaBYCOL
BYCOL(array_or_range, LAMBDA)
Groups an array by columns by application of a LAMBDA function to each column. Learn more
Apri schedaBYROW
BYROW(array_or_range, LAMBDA)
Groups an array by rows by application of a LAMBDA function to each row. Learn more
Apri schedaCHOOSECOLS
CHOOSECOLS(array, col_num1, [col_num2])
Creates a new array from the selected columns in the existing range. Learn more
Apri schedaCHOOSEROWS
CHOOSEROWS(array, row_num1, [row_num2])
Creates a new array from the selected rows in the existing range. Learn more
Apri schedaFLATTEN
FLATTEN(range1,[range2,...])
Flattens all the values from one or more ranges into a single column. Learn more
Apri schedaFREQUENCY
FREQUENCY(data, classes)
Calculates the frequency distribution of a one-column array into specified classes. Learn more
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
Apri schedaHSTACK
HSTACK(range1; [range2, …])
Appends ranges horizontally and in sequence to return a larger array. Learn more
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
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
Apri schedaMAKEARRAY
MAKEARRAY(rows, columns, LAMBDA)
Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn more
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
Apri schedaMDETERM
MDETERM(square_matrix)
Returns the matrix determinant of a square matrix specified as an array or range. Learn more
Apri schedaMINVERSE
MINVERSE(square_matrix)
Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more
Apri schedaMMULT
MMULT(matrix1, matrix2)
Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
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
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
Apri schedaSUMPRODUCT
SUMPRODUCT(array1, [array2, ...])
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more
Apri schedaSUMX2MY2
SUMX2MY2(array_x, array_y)
Calculates the sum of the differences of the squares of values in two arrays. Learn more
Apri schedaSUMX2PY2
SUMX2PY2(array_x, array_y)
Calculates the sum of the sums of the squares of values in two arrays. Learn more
Apri schedaSUMXMY2
SUMXMY2(array_x, array_y)
Calculates the sum of the squares of differences of values in two arrays. Learn more
Apri schedaTOCOL
TOCOL(array_or_range, [ignore], [scan_by_column])
Transforms an array or range of cells into a single column. Learn more
Apri schedaTOROW
TOROW(array_or_range, [ignore], [scan_by_column])
Transforms an array or range of cells into a single row. Learn more
Apri schedaTRANSPOSE
TRANSPOSE(array_or_range)
Transposes the rows and columns of an array or range of cells. Learn more
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
Apri schedaVSTACK
VSTACK(range1; [range2, …])
Appends ranges vertically and in sequence to return a larger array. Learn more
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Apri schedaDATE
DATE(year, month, day)
Converts a provided year, month, and day into a date. Learn more
Apri schedaDATEDIF
DATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates. Learn more
Apri schedaDATEVALUE
DATEVALUE(date_string)
Converts a provided date string in a known format to a date value. Learn more
Apri schedaDAY
DAY(date)
Returns the day of the month that a specific date falls on, in numeric format. Learn more
Apri schedaDAYS
DAYS(end_date, start_date)
Returns the number of days between two dates. Learn more.
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
Apri schedaEDATE
EDATE(start_date, months)
Returns a date a specified number of months before or after another date. Learn more
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
Apri schedaEPOCHTODATE
EPOCHTODATE(timestamp, [unit])
Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. Learn more
Apri schedaHOUR
HOUR(time)
Returns the hour component of a specific time, in numeric format. Learn more
Apri schedaISOWEEKNUM
ISOWEEKNUM(date)
Returns the number of the ISO week of the year where the provided date falls. Learn more
Apri schedaMINUTE
MINUTE(time)
Returns the minute component of a specific time, in numeric format. Learn more
Apri schedaMONTH
MONTH(date)
Returns the month of the year a specific date falls in, in numeric format. Learn more
Apri schedaNETWORKDAYS
NETWORKDAYS(start_date, end_date, [holidays])
Returns the number of net working days between two provided days. Learn more
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
Apri schedaNOW
NOW()
Returns the current date and time as a date value. Learn more
Apri schedaSECOND
SECOND(time)
Returns the second component of a specific time, in numeric format. Learn more
Apri schedaTIME
TIME(hour, minute, second)
Converts a provided hour, minute, and second into a time. Learn more
Apri schedaTIMEVALUE
TIMEVALUE(time_string)
Returns the fraction of a 24-hour day the time represents. Learn more
Apri schedaTODAY
TODAY()
Returns the current date as a date value. Learn more
Apri schedaWEEKDAY
WEEKDAY(date, [type])
Returns a number representing the day of the week of the date provided. Learn more
Apri schedaWEEKNUM
WEEKNUM(date, [type])
Returns a number representing the week of the year where the provided date falls. Learn more
Apri schedaWORKDAY
WORKDAY(start_date, num_days, [holidays])
Calculates the end date after a specified number of working days. Learn more
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
Apri schedaYEAR
YEAR(date)
Returns the year specified by a given date. Learn more
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
Apri schedaBIN2DEC
BIN2DEC(signed_binary_number)
Converts a signed binary number to decimal format. Learn more
Apri schedaBIN2HEX
BIN2HEX(signed_binary_number, [significant_digits])
Converts a signed binary number to signed hexadecimal format. Learn more
Apri schedaBIN2OCT
BIN2OCT(signed_binary_number, [significant_digits])
Converts a signed binary number to signed octal format. Learn more
Apri schedaBITAND
BITAND(value1, value2)
Bitwise boolean AND of two numbers. Learn more.
Apri schedaBITLSHIFT
BITLSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the left. Learn more.
Apri schedaBITOR
BITOR(value1, value2)
Bitwise boolean OR of 2 numbers. Learn more.
Apri schedaBITRSHIFT
BITRSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the right. Learn more.
Apri schedaBITXOR
BITXOR(value1, value2)
Bitwise XOR (exclusive OR) of 2 numbers. Learn more.
Apri schedaCOMPLEX
COMPLEX(real_part, imaginary_part, [suffix])
Creates a complex number given real and imaginary coefficients. Learn more
Apri schedaDEC2BIN
DEC2BIN(decimal_number, [significant_digits])
Converts a decimal number to signed binary format. Learn more
Apri schedaDEC2HEX
DEC2HEX(decimal_number, [significant_digits])
Converts a decimal number to signed hexadecimal format. Learn more
Apri schedaDEC2OCT
DEC2OCT(decimal_number, [significant_digits])
Converts a decimal number to signed octal format. Learn more
Apri schedaDELTA
DELTA(number1, [number2])
Compare two numeric values, returning 1 if they're equal. Learn more
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.
Apri schedaERF.PRECISE
ERF.PRECISE(lower_bound, [upper_bound])
See ERF
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.
Apri schedaHEX2BIN
HEX2BIN(signed_hexadecimal_number, [significant_digits])
Converts a signed hexadecimal number to signed binary format. Learn more
Apri schedaHEX2DEC
HEX2DEC(signed_hexadecimal_number)
Converts a signed hexadecimal number to decimal format. Learn more
Apri schedaHEX2OCT
HEX2OCT(signed_hexadecimal_number, significant_digits)
Converts a signed hexadecimal number to signed octal format. Learn more
Apri schedaIMABS
IMABS(number)
Returns absolute value of a complex number. Learn more
Apri schedaIMAGINARY
IMAGINARY(complex_number)
Returns the imaginary coefficient of a complex number. Learn more
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.
Apri schedaIMCONJUGATE
IMCONJUGATE(number)
Returns the complex conjugate of a number. Learn more
Apri schedaIMCOS
IMCOS(number)
The IMCOS function returns the cosine of the given complex number. Learn more.
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.
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.
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.
Apri schedaIMCSC
IMCSC(number)
Returns the cosecant of the given complex number. Learn more.
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.
Apri schedaIMDIV
IMDIV(dividend, divisor)
Returns one complex number divided by another. Learn more
Apri schedaIMEXP
IMEXP(exponent)
Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
Apri schedaIMLOG
IMLOG(value, base)
Returns the logarithm of a complex number for a specified base. Learn more.
Apri schedaIMLOG10
IMLOG10(value)
Returns the logarithm of a complex number with base 10. Learn more.
Apri schedaIMLOG2
IMLOG2(value)
Returns the logarithm of a complex number with base 2. Learn more.
Apri schedaIMPRODUCT
IMPRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of complex numbers together. Learn more
Apri schedaIMREAL
IMREAL(complex_number)
Returns the real coefficient of a complex number. Learn more
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.
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.
Apri schedaIMSIN
IMSIN (number)
Returns the sine of the given complex number. Learn more.
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.
Apri schedaIMSUB
IMSUB(first_number, second_number)
Returns the difference between two complex numbers. Learn more
Apri schedaIMSUM
IMSUM(value1, [value2, ...])
Returns the sum of a series of complex numbers. Learn more
Apri schedaIMTAN
IMTAN(number)
Returns the tangent of the given complex number. Learn more.
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.
Apri schedaOCT2BIN
OCT2BIN(signed_octal_number, [significant_digits])
Converts a signed octal number to signed binary format. Learn more
Apri schedaOCT2DEC
OCT2DEC(signed_octal_number)
Converts a signed octal number to decimal format. Learn more
Apri schedaOCT2HEX
OCT2HEX(signed_octal_number, [significant_digits])
Converts a signed octal number to signed hexadecimal format. Learn more
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
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
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
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
Apri schedaACCRINTM
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity. Learn more
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.
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
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
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
Apri schedaCOUPNCD
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date. Learn more
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
Apri schedaCOUPPCD
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date. Learn more
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
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
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
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
Apri schedaDISC
DISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the discount rate of a security based on price. Learn more
Apri schedaDOLLARDE
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal fraction into a decimal value. Learn more
Apri schedaDOLLARFR
DOLLARFR(decimal_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction. Learn more
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
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
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
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
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
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
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
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.
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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.
Apri schedaSLN
SLN(cost, salvage, life)
Calculates the depreciation of an asset for one period using the straight-line method. Learn more
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
Apri schedaTBILLEQ
TBILLEQ(settlement, maturity, discount)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
Apri schedaTBILLPRICE
TBILLPRICE(settlement, maturity, discount)
Calculates the price of a US Treasury Bill based on discount rate. Learn more
Apri schedaTBILLYIELD
TBILLYIELD(settlement, maturity, price)
Calculates the yield of a US Treasury Bill based on price. Learn more
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.
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
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
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
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
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
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
Apri schedaDETECTLANGUAGE
DETECTLANGUAGE(text_or_range)
Identifies the language used in text within the specified range. Learn more
Apri schedaGOOGLEFINANCE
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Fetches current or historical securities information from Google Finance. Learn more
Apri schedaGOOGLETRANSLATE
GOOGLETRANSLATE(text, [source_language], [target_language])
Translates text from one language into another Learn more
Apri schedaIMAGE
IMAGE(url, [mode], [height], [width])
Inserts an image into a cell. Learn more
Apri schedaQUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Apri schedaSPARKLINE
SPARKLINE(data, [options])
Creates a miniature chart contained within a single cell. Learn more
Apri schedaCELL
CELL(info_type, reference)
Returns the requested information about the specified cell. Learn more
Apri schedaERROR.TYPE
ERROR.TYPE(reference)
Returns a number corresponding to the error value in a different cell. Learn more
Apri schedaISBLANK
ISBLANK(value)
Checks whether the referenced cell is empty. Learn more
Apri schedaISDATE
ISDATE(value)
Returns whether a value is a date. Learn more.
Apri schedaISEMAIL
ISEMAIL(value)
Checks whether a value is a valid email address. Learn more
Apri schedaISERR
ISERR(value)
Checks whether a value is an error other than `#N/A`. Learn more
Apri schedaISERROR
ISERROR(value)
Checks whether a value is an error. Learn more
Apri schedaISFORMULA
ISFORMULA(cell)
Checks whether a formula is in the referenced cell. Learn more
Apri schedaISLOGICAL
ISLOGICAL(value)
Checks whether a value is `TRUE` or `FALSE`. Learn more
Apri schedaISNA
ISNA(value)
Checks whether a value is the error `#N/A`. Learn more
Apri schedaISNONTEXT
ISNONTEXT(value)
Checks whether a value is non-textual. Learn more
Apri schedaISNUMBER
ISNUMBER(value)
Checks whether a value is a number. Learn more
Apri schedaISREF
ISREF(value)
Checks whether a value is a valid cell reference. Learn more
Apri schedaISTEXT
ISTEXT(value)
Checks whether a value is text. Learn more
Apri schedaN
N(value)
Returns the argument provided as a number. Learn more
Apri schedaNA
NA()
Returns the "value not available" error, `#N/A`. Learn more
Apri schedaSHEETS
SHEETS(reference)
Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
Apri schedaTYPE
TYPE(value)
Returns a number associated with the type of data passed into the function. Learn more
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
Apri schedaFALSE
FALSE()
Returns the logical value `FALSE`. Learn more
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
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
Apri schedaIFNA
IFNA(value, value_if_na)
Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.
Apri schedaIFS
IFS(condition1, value1, [condition2, value2], …)
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.
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
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
Apri schedaNOT
NOT(logical_expression)
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more
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
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
Apri schedaTRUE
TRUE()
Returns the logical value `TRUE`. Learn more
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.
Apri schedaADDRESS
ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Returns a cell reference as a string. Learn more
Apri schedaCHOOSE
CHOOSE(index, choice1, [choice2, ...])
Returns an element from a list of choices based on index. Learn more
Apri schedaCOLUMN
COLUMN([cell_reference])
Returns the column number of a specified cell, with `A=1`. Learn more
Apri schedaCOLUMNS
COLUMNS(range)
Returns the number of columns in a specified array or range. Learn more
Apri schedaFORMULATEXT
FORMULATEXT(cell)
Returns the formula as a string. Learn more.
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
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
Apri schedaINDEX
INDEX(reference, [row], [column])
Returns the content of a cell, specified by row and column offset. Learn more
Apri schedaINDIRECT
INDIRECT(cell_reference_as_string, [is_A1_notation])
Returns a cell reference specified by a string. Learn more
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
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
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
Apri schedaROW
ROW([cell_reference])
Returns the row number of a specified cell. Learn more
Apri schedaROWS
ROWS(range)
Returns the number of rows in a specified array or range. Learn more
Apri schedaSHEET
SHEET(value)
Returns the sheet number of the specified sheet or other reference. Learn more about the SHEET function.
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
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
Apri schedaABS
ABS(value)
Returns the absolute value of a number. Learn more
Apri schedaACOS
ACOS(value)
Returns the inverse cosine of a value, in radians. Learn more
Apri schedaACOSH
ACOSH(value)
Returns the inverse hyperbolic cosine of a number. Learn more
Apri schedaACOT
ACOT(value)
Returns the inverse cotangent of a value, in radians. Learn more.
Apri schedaACOTH
ACOTH(value)
Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more.
Apri schedaASIN
ASIN(value)
Returns the inverse sine of a value, in radians. Learn more
Apri schedaASINH
ASINH(value)
Returns the inverse hyperbolic sine of a number. Learn more
Apri schedaATAN
ATAN(value)
Returns the inverse tangent of a value, in radians. Learn more
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
Apri schedaATANH
ATANH(value)
Returns the inverse hyperbolic tangent of a number. Learn more
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.
Apri schedaCEILING
CEILING(value, [factor])
Rounds a number up to the nearest integer multiple of specified significance. Learn more
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.
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.
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
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.
Apri schedaCOS
COS(angle)
Returns the cosine of an angle provided in radians. Learn more
Apri schedaCOSH
COSH(value)
Returns the hyperbolic cosine of any real number. Learn more
Apri schedaCOT
COT(angle)
Cotangent of an angle provided in radians. Learn more.
Apri schedaCOTH
COTH(value)
Returns the hyperbolic cotangent of any real number. Learn more.
Apri schedaCOUNTBLANK
COUNTBLANK(range)
Returns the number of empty cells in a given range. Learn more
Apri schedaCOUNTIF
COUNTIF(range, criterion)
Returns a conditional count across a range. Learn more
Apri schedaCOUNTIFS
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the count of a range depending on multiple criteria. Learn more
Apri schedaCOUNTUNIQUE
COUNTUNIQUE(value1, [value2, ...])
Counts the number of unique values in a list of specified values and ranges. Learn more
Apri schedaCSC
CSC(angle)
Returns the cosecant of an angle provided in radians. Learn more.
Apri schedaCSCH
CSCH(value)
The CSCH function returns the hyperbolic cosecant of any real number. Learn more.
Apri schedaDECIMAL
DECIMAL(value, base)
The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more.
Apri schedaDEGREES
DEGREES(angle)
Converts an angle value in radians to degrees. Learn more
Apri schedaERFC
ERFC(z)
Returns the complementary Gauss error function of a value. Learn more
Apri schedaERFC.PRECISE
ERFC.PRECISE(z)
See ERFC
Apri schedaEVEN
EVEN(value)
Rounds a number up to the nearest even integer. Learn more
Apri schedaEXP
EXP(exponent)
Returns Euler's number, e (~2.718) raised to a power. Learn more
Apri schedaFACT
FACT(value)
Returns the factorial of a number. Learn more
Apri schedaFACTDOUBLE
FACTDOUBLE(value)
Returns the "double factorial" of a number. Learn more
Apri schedaFLOOR
FLOOR(value, [factor])
Rounds a number down to the nearest integer multiple of specified significance. Learn more
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.
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.
Apri schedaGAMMALN
GAMMALN(value)
Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more
Apri schedaGAMMALN.PRECISE
GAMMALN.PRECISE(value)
See GAMMALN
Apri schedaGCD
GCD(value1, value2)
Returns the greatest common divisor of one or more integers. Learn more
Apri schedaIMLN
IMLN(complex_value)
Returns the logarithm of a complex number, base e (Euler's number). Learn more
Apri schedaIMPOWER
IMPOWER(complex_base, exponent)
Returns a complex number raised to a power. Learn more
Apri schedaIMSQRT
IMSQRT(complex_number)
Computes the square root of a complex number. Learn more
Apri schedaINT
INT(value)
Rounds a number down to the nearest integer that is less than or equal to it. Learn more
Apri schedaISEVEN
ISEVEN(value)
Checks whether the provided value is even. Learn more
Apri schedaISO.CEILING
ISO.CEILING(number, [significance])
See CEILING.PRECISE
Apri schedaISODD
ISODD(value)
Checks whether the provided value is odd. Learn more
Apri schedaLCM
LCM(value1, value2)
Returns the least common multiple of one or more integers. Learn more
Apri schedaLN
LN(value)
Returns the the logarithm of a number, base e (Euler's number). Learn more
Apri schedaLOG
LOG(value, base)
Returns the the logarithm of a number given a base. Learn more
Apri schedaLOG10
LOG10(value)
Returns the the logarithm of a number, base 10. Learn more
Apri schedaMOD
MOD(dividend, divisor)
Returns the result of the modulo operator, the remainder after a division operation. Learn more
Apri schedaMROUND
MROUND(value, factor)
Rounds one number to the nearest integer multiple of another. Learn more
Apri schedaMULTINOMIAL
MULTINOMIAL(value1, value2)
Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more
Apri schedaMUNIT
MUNIT(dimension)
Returns a unit matrix of size dimension x dimension. Learn more.
Apri schedaODD
ODD(value)
Rounds a number up to the nearest odd integer. Learn more
Apri schedaPI
PI()
Returns the value of Pi to 14 decimal places. Learn more
Apri schedaPOWER
POWER(base, exponent)
Returns a number raised to a power. Learn more
Apri schedaPRODUCT
PRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of numbers together. Learn more
Apri schedaQUOTIENT
QUOTIENT(dividend, divisor)
Returns one number divided by another. Learn more
Apri schedaRADIANS
RADIANS(angle)
Converts an angle value in degrees to radians. Learn more
Apri schedaRAND
RAND()
Returns a random number between 0 inclusive and 1 exclusive. Learn more
Apri schedaRANDARRAY
RANDARRAY(rows, columns)
Generates an array of random numbers between 0 and 1. Learn more.
Apri schedaRANDBETWEEN
RANDBETWEEN(low, high)
Returns a uniformly random integer between two values, inclusive. Learn more
Apri schedaROUND
ROUND(value, [places])
Rounds a number to a certain number of decimal places according to standard rules. Learn more
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
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
Apri schedaSEC
SEC(angle)
The SEC function returns the secant of an angle, measured in radians. Learn more.
Apri schedaSECH
SECH(value)
The SECH function returns the hyperbolic secant of an angle. Learn more
Apri schedaSEQUENCE
SEQUENCE(rows, columns, start, step)
Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.
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
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
Apri schedaSIN
SIN(angle)
Returns the sine of an angle provided in radians. Learn more
Apri schedaSINH
SINH(value)
Returns the hyperbolic sine of any real number. Learn more
Apri schedaSQRT
SQRT(value)
Returns the positive square root of a positive number. Learn more
Apri schedaSQRTPI
SQRTPI(value)
Returns the positive square root of the product of Pi and the given positive number. Learn more
Apri schedaSUBTOTAL
SUBTOTAL(function_code, range1, [range2, ...])
Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
Apri scheda