Using Formulas


Chaining of arithmetic formulas are supported!

List of Formulas Supported by Excellentable:

#
Type
Name
Input Data
Description
1Array

TREND

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.
2Array

SUMXMY2

SUMXMY2(array_x, array_y)Calculates the sum of the squares of differences of values in two arrays.
3Array

SUMX2PY2

SUMX2PY2(array_x, array_y)Calculates the sum of the sums of the squares of values in two arrays. 
4Array

SUMX2MY2

SUMX2MY2(array_x, array_y)Calculates the sum of the differences of the squares of values in two arrays.
5Array

SUMPRODUCT

SUMPRODUCT(array1, array2)Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. 
6Array

MMULT

MMULT(matrix1, matrix2)Calculates the matrix product of two matrices specified as arrays or ranges. 
7Array

MINVERSE

MINVERSE(square_matrix)Returns the multiplicative inverse of a square matrix specified as an array or range. 
8Array

MDETERM

MDETERM(square_matrix)Returns the matrix determinant of a square matrix specified as an array or range. 
9Array

LOGEST

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. 
10Array

LINEST

LINEST(known_data_y, known_data_x, b, verbose)Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.
11Array

GROWTH

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.
12Array

FREQUENCY

FREQUENCY(data, classes)Calculates the frequency distribution of a one-column array into specified classes.
13Array

TRANSPOSE

TRANSPOSE(array_or_range)Transposes the rows and columns of an array or range of cells. 
14Database

DMIN

DMIN(database, field, criteria)Returns the minimum value selected from a database table-like array or range using a SQL-like query.
15Database

DVARP

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. 
16Database

DSUM

DSUM(database, field, criteria)Returns the sum of values selected from a database table-like array or range using a SQL-like query.
17Database

DSTDEVP

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. 
18Database

DSTDEV

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. 
19Database

DPRODUCT

DPRODUCT(database, field, criteria)Returns the product of values selected from a database table-like array or range using a SQL-like query. 
20Database

DVAR

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.
21Database

DMAX

DMAX(database, field, criteria)Returns the maximum value selected from a database table-like array or range using a SQL-like query.
22Database

DGET

DGET(database, field, criteria)Returns a single value from a database table-like array or range using a SQL-like query. 
23Database

DCOUNTA

DCOUNTA(database, field, criteria)Counts values, including text, selected from a database table-like array or range using a SQL-like query.
24Database

DCOUNT

DCOUNT(database, field, criteria)Counts numeric values selected from a database table-like array or range using a SQL-like query.
25Database

DAVERAGE

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.
26Date

EOMONTH

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. 
27Date

HOUR

HOUR(time)Returns the hour component of a specific time, in numeric format. 
28DateMINUTEMINUTE(time)Returns the minute component of a specific time, in numeric format.
29DateMONTHMONTH(date)Returns the month of the year a specific date falls in, in numeric format. 
30DateNETWORKDAYSNETWORKDAYS(start_date, end_date, holidays)Returns the number of net working days between two provided days. 
31DateNETWORKDAYS.INTLNETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])Returns the number of net working days between two provided days excluding specified weekend days and holidays.
32DateNOWNOW()Returns the current date and time as a date value. 
33DateSECONDSECOND(time)Returns the second component of a specific time, in numeric format.
34DateTIMETIME(hour, minute, second)Converts a provided hour, minute, and second into a time. 
35DateTIMEVALUETIMEVALUE(time_string)Returns the fraction of a 24-hour day the time represents.
36DateTODAYTODAY()Returns the current date as a date value.
37DateWEEKDAYWEEKDAY(date, type)Returns a number representing the day of the week of the date provided.
38DateWEEKNUMWEEKNUM(date, [type])Returns a number representing the week of the year where the provided date falls.
39DateWORKDAYWORKDAY(start_date, num_days, holidays)Calculates the number of working days from a specified start date. 
40DateWORKDAY.INTLWORKDAY.INTL(start_date, num_days, [weekend], [holidays])Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
41DateYEARYEAR(date)Returns the year specified by a given date.
42DateYEARFRACYEARFRAC(start_date, end_date, day_count_convention)Returns the number of years, including fractional years, between two dates using a specified day count convention.
43DateDATEDATE(year, month, day)Converts a provided year, month, and day into a date.
44DateDATEVALUEDATEVALUE(date_string)Converts a provided date string in a known format to a date value.
45DateDAYDAY(date)Returns the day of the month that a specific date falls on, in numeric format.
46DateDAYS360DAYS360(start_date, end_date, method)Returns the difference between two days based on the 360 day year used in some financial interest calculations. 
47DateEDATEEDATE(start_date)Returns a date a specified number of months before or after another date. 
48DateDATEDIFDATEDIF(start_date, end_date, unit)Calculates the number of days, months, or years between two dates.
49EngineeringHEX2DECHEX2DEC(signed_hexadecimal_number)Converts a signed hexadecimal number to decimal format. 
50EngineeringBIN2DECBIN2DEC(signed_binary_number)Converts a signed binary number to decimal format.
51EngineeringBIN2HEXBIN2HEX(signed_binary_number, significant_digits)Converts a signed binary number to signed hexadecimal format. 
52EngineeringBIN2OCTBIN2OCT(signed_binary_number, significant_digits)Converts a signed binary number to signed octal format. 
53EngineeringOCT2HEXOCT2HEX(signed_octal_number, significant_digits)Converts a signed octal number to signed hexadecimal format.
54EngineeringOCT2DECOCT2DEC(signed_octal_number)Converts a signed octal number to decimal format.
55EngineeringOCT2BINOCT2BIN(signed_octal_number, significant_digits)Converts a signed octal number to signed binary format. 
56EngineeringHEX2OCTHEX2OCT(signed_hexadecimal_number, significant_digits)Converts a signed hexadecimal number to signed octal format. 
57EngineeringDEC2BINDEC2BIN(decimal_number, significant_digits)Converts a decimal number to signed binary format.
58EngineeringHEX2BINHEX2BIN(signed_hexadecimal_number, significant_digits)Converts a signed hexadecimal number to signed binary format. 
59EngineeringDELTADELTA(number1, [number2])Compare two numeric values, returning 1 if they're equal.
60EngineeringDEC2OCTDEC2OCT(decimal_number, significant_digits)Converts a decimal number to signed octal format.
61EngineeringDEC2HEXDEC2HEX(decimal_number, significant_digits)Converts a decimal number to signed hexadecimal format. 
62FinancialDISCDISC(settlement, maturity, price, redemption, day_count_convention)Calculates the discount rate of a security based on price.
63FinancialPRICEDISCPRICEDISC(settlement, maturity, discount, redemption, day_count_convention)Calculates the price of a discount (non-interest-bearing) security, based on expected yield. 
64FinancialPRICEMATPRICEMAT(settlement, maturity, issue, rate, yield, day_count_convention)Calculates the price of a security paying interest at maturity, based on expected yield. 
65FinancialPVPV(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. 
66FinancialRATERATE(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.
67FinancialRECEIVEDRECEIVED(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. 
68FinancialSLNSLN(cost, salvage, life)Calculates the depreciation of an asset for one period using the straight-line method. 
69FinancialSYDSYD(cost, salvage, life, period)Calculates the depreciation of an asset for a specified period using the sum of years digits method. 
70FinancialTBILLEQTBILLEQ(settlement, maturity, discount)Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. 
71FinancialTBILLPRICETBILLPRICE(settlement, maturity, discount)Calculates the price of a US Treasury Bill based on discount rate. 
72FinancialTBILLYIELDTBILLYIELD(settlement, maturity, price)Calculates the yield of a US Treasury Bill based on price.
73FinancialXIRRXIRR(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. 
74FinancialXNPVXNPV(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.
75FinancialYIELDYIELD(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.
76FinancialYIELDDISCYIELDDISC(settlement, maturity, price, redemption, day_count_convention)Calculates the annual yield of a discount (non-interest-bearing) security, based on price. 
77FinancialCUMPRINCCUMPRINC(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. 
78FinancialCUMIPMTCUMIPMT(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. 
79FinancialCOUPPCDCOUPPCD(settlement, maturity, frequency, day_count_convention)Calculates last coupon, or interest payment, date before the settlement date.
80FinancialCOUPNUMCOUPNUM(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. 
81FinancialCOUPNCD

COUPNCD(settlement, maturity, frequency, [day_count_convention])

Calculates next coupon, or interest payment, date after the settlement date. 
82FinancialCOUPDAYSNCCOUPDAYSNC(settlement, maturity, frequency, day_count_convention)Calculates the number of days from the settlement date until the next coupon, or interest payment. 
83FinancialCOUPDAYSCOUPDAYS(settlement, maturity, frequency, day_count_convention)Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. 
84FinancialCOUPDAYBSCOUPDAYBS(settlement, maturity, frequency, day_count_convention)Calculates the number of days from the first coupon, or interest payment, until settlement. 
85FinancialACCRINTMACCRINTM(issue, maturity, rate, redemption, day_count_convention)Calculates the accrued interest of a security that pays interest at maturity.
86FinancialACCRINTACCRINT(issue, first_payment, settlement, rate, redemption, frequency, day_count_convention)Calculates the accrued interest of a security that has periodic payments.
87FinancialDBDB(cost, salvage, life, period, month)Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
88FinancialDURATIONDURATION(rate, present_value, future_value)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.
89FinancialEFFECTEFFECT(nominal_rate, periods_per_year)Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. 
90FinancialFVFV(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.
91FinancialFVSCHEDULEFVSCHEDULE(principal, rate_schedule)Calculates the future value of some principal based on a specified series of potentially varying interest rates.
92FinancialINTRATEINTRATE(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.
93FinancialIPMTIPMT(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. 
94FinancialIRRIRR(cashflow_amounts, rate_guess)Calculates the internal rate of return on an investment based on a series of periodic cash flows.
95FinancialMDURATIONMDURATION(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.
96FinancialMIRRMIRR(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.
97FinancialNOMINALNOMINAL(effective_rate, periods_per_year)Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
98FinancialNPERNPER(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. 
99FinancialDOLLARDEDOLLARDE(fractional_price, unit)Converts a price quotation given as a decimal fraction into a decimal value. 
100FinancialNPVNPV(discount, cashflow1, cashflow2)Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. 
101FinancialPMTPMT(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. 
102FinancialPPMTPPMT(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. 
103FinancialDOLLARFRDOLLARFR(decimal_price, unit)Converts a price quotation given as a decimal value into a decimal fraction.
104FinancialPRICEPRICE(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. 
105FinancialDDBDDB(cost, salvage, life, period, factor)Calculates the depreciation of an asset for a specified period using the double-declining balance method.
106InfoISREFISREF(value)Checks whether a value is a valid cell reference. 
107InfoTYPETYPE(value)Returns a number associated with the type of data passed into the function.
108InfoERROR.TYPEERROR.TYPE(reference)Returns a number corresponding to the error value in a different cell.
109InfoISBLANKISBLANK(value)Checks whether the referenced cell is empty.
110InfoISERRISERR(value)Checks whether a value is an error other than `#N/A`.
111InfoISERRORISERROR(value)Checks whether a value is an error. 
112InfoISLOGICALISLOGICAL(value)Checks whether a value is `TRUE` or `FALSE`. 
113InfoNANA()Returns the "value not available" error, `#N/A`.
114InfoNN(value)Returns the argument provided as a number. 
115InfoISNUMBERISNUMBER(value)Checks whether a value is a number. 
116InfoISNONTEXTISNONTEXT(value)Checks whether a value is non-textual. 
117InfoISNAISNA(value)Checks whether a value is the error `#N/A`. 
118InfoISTEXTISTEXT(value)Checks whether a value is text. 
119LogicalTRUETRUE()Returns the logical value `TRUE`. 
120LogicalOROR(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. 
121LogicalNOTNOT(logical_expression)Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. 
122LogicalIFERRORIFERROR(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. 
123LogicalIFIF(logical_expression, value_if_true, value_if_false)Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
124LogicalFALSEFALSE()Returns the logical value `FALSE`. 
125LogicalANDAND(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. 
126LookupHLOOKUPHLOOKUP(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. 
127LookupROWSROWS(range)Returns the number of rows in a specified array or range.
128LookupCOLUMNCOLUMN(cell_reference)Returns the column number of a specified cell, with `A=1`.
129LookupCHOOSECHOOSE(index, choice1, choice2)Returns an element from a list of choices based on index. 
130LookupADDRESSADDRESS(row, column, absolute_relative_mode, use_a1_notation, sheet)Returns a cell reference as a string. 
131LookupVLOOKUPVLOOKUP(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.
132LookupROWROW(cell_reference)Returns the row number of a specified cell.
133LookupOFFSETOFFSET(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.
134LookupMATCHMATCH(search_key, range, search_type)Returns the relative position of an item in a range that matches a specified value.
135LookupLOOKUPLOOKUP(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.
136LookupINDIRECTINDIRECT(cell_reference_as_string)Returns a cell reference specified by a string. 
137LookupINDEXINDEX(reference, row, column)Returns the content of a cell, specified by row and column offset. 
138LookupCOLUMNSCOLUMNS(range)Returns the number of columns in a specified array or range. 
139MathLCMLCM(value1, value2)Returns the least common multiple of one or more integers. 
140MathLNLN(value)Returns the the logarithm of a number, base e (Euler's number).
141MathLOGLOG(value, base)Returns the the logarithm of a number given a base.
142MathLOG10LOG10(value)Returns the the logarithm of a number, base 10.
143MathMODMOD(dividend, divisor)Returns the result of the modulo operator, the remainder after a division operation. 
144MathMROUNDMROUND(value, factor)Rounds one number to the nearest integer multiple of another. 
145MathMULTINOMIALMULTINOMIAL(value1, value2)Returns the factorial of the sum of values divided by the product of the values' factorials.
146MathODDODD(value)Rounds a number up to the nearest odd integer. 
147MathPIPI()Returns the value of Pi to 14 decimal places. 
148MathPOWERPOWER(base, exponent)Returns a number raised to a power. 
149MathPRODUCTPRODUCT(factor1, factor2)Returns the result of multiplying a series of numbers together. 
150MathQUOTIENTQUOTIENT(dividend, divisor)Returns one number divided by another. 
151MathRADIANSRADIANS(angle)Converts an angle value in degrees to radians. 
152MathRANDRAND()Returns a random number between 0 inclusive and 1 exclusive. 
153MathRANDBETWEENRANDBETWEEN(low, high)Returns a uniformly random integer between two values, inclusive. 
154MathROUNDROUND(value, places)Rounds a number to a certain number of decimal places according to standard rules. 
155MathROUNDDOWNROUNDDOWN(value, places)Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. 
156MathROUNDUPROUNDUP(value, places)Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
157MathSERIESSUMSERIESSUM(x, n, m, a)Given parameters xnm, 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`. 
158MathSIGNSIGN(value)Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. 
159MathSINSIN(angle)Returns the sine of an angle provided in radians. 
160MathSINHSINH(value)Returns the hyperbolic sine of any real number.
161MathSQRTSQRT(value)Returns the positive square root of a positive number
162MathSQRTPISQRTPI(value)Returns the positive square root of the product of Pi and the given positive number.
163MathSUBTOTALSUBTOTAL(function_code, range1, range2)Returns a subtotal for a vertical range of cells using a specified aggregation function. 
164MathSUMSUM(value1, value2)Returns the sum of a series of numbers and/or cells.
165MathSUMIFSUMIF(range, criterion, sum_range)Returns a conditional sum across a range. 
166MathSUMIFSSUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])Returns the sum of a range depending on multiple criteria.
167MathSUMSQSUMSQ(value1, value2)Returns the sum of the squares of a series of numbers and/or cells.
168MathTANTAN(angle)Returns the tangent of an angle provided in radians.
169MathTANHTANH(value)Returns the hyperbolic tangent of any real number
170MathTRUNCTRUNC(value, places)Truncates a number to a certain number of significant digits by omitting less significant digits. 
171MathABSABS(value)Returns the absolute value of a number. 
172MathACOSACOS(value)Returns the inverse cosine of a value, in radians. 
173MathACOSHACOSH(value)Returns the inverse hyperbolic cosine of a number. 
174MathASINASIN(value)Returns the inverse sine of a value, in radians. 
175MathASINHASINH(value)Returns the inverse hyperbolic sine of a number
176MathATANATAN(value)Returns the inverse tangent of a value, in radians. 
177MathATAN2ATAN2(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.
178MathATANHATANH(value)Returns the inverse hyperbolic tangent of a number. 
179MathCEILINGCEILING(value, factor)Rounds a number up to the nearest integer multiple of specified significance. 
180MathCOMBINCOMBIN(n, k)Returns the number of ways to choose some number of objects from a pool of a given size of objects. 
181MathCOSCOS(angle)Returns the cosine of an angle provided in radians.
182MathCOSHCOSH(value)Returns the hyperbolic cosine of any real number.
183MathCOUNTBLANKCOUNTBLANK(range)Returns the number of empty cells in a given range.
184MathCOUNTIFCOUNTIF(range, criterion)Returns a conditional count across a range. 
185MathCOUNTIFSCOUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])Returns the count of a range depending on multiple criteria.
186MathDEGREESDEGREES(angle)Converts an angle value in radians to degrees. 
187MathERFCERFC(z)Returns the complementary Gauss error function of a value.
188MathEVENEVEN(value)Rounds a number up to the nearest even integer. 
189MathEXPEXP(exponent)Returns Euler's number, e (~2.718) raised to a power.
190MathFACTFACT(value)Returns the factorial of a number. 
191MathFACTDOUBLEFACTDOUBLE(value)Returns the "double factorial" of a number.
192MathFLOORFLOOR(value, factor)Rounds a number down to the nearest integer multiple of specified significance.
193MathGAMMALNGAMMALN(value)Returns the the logarithm of a specified Gamma function, base e (Euler's number). 
194MathGCDGCD(value1, value2)Returns the greatest common divisor of one or more integers. 
195MathINTINT(value)Rounds a number down to the nearest integer that is less than or equal to it.
196MathISEVENISEVEN(value)Checks whether the provided value is even.
197MathISODDISODD(value)Checks whether the provided value is odd. 
198ParserCONVERTCONVERT(value, start_unit, end_unit)Converts a numeric value to a different unit of measure.
199StatisticalNEGBINOMDISTNEGBINOMDIST(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. 
200StatisticalNORMDISTNORMDIST(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. 
201StatisticalNORMINVNORMINV(x, mean, standard_deviation)Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. 
202StatisticalNORMSDISTNORMSDIST(x)Returns the value of the standard normal cumulative distribution function for a specified value. 
203StatisticalNORMSINVNORMSINV(x)Returns the value of the inverse standard normal distribution function for a specified value. 
204StatisticalPEARSONPEARSON(data_y, data_x)Calculates r, the Pearson product-moment correlation coefficient of a dataset.
205StatisticalPERCENTILEPERCENTILE(data, percentile)Returns the value at a given percentile of a dataset.
206StatisticalPERCENTRANKPERCENTRANK(data, value, [significant_digits])Returns the percentage rank (percentile) of a specified value in a dataset. 
207StatisticalPERCENTRANK.EXCPERCENTRANK.EXC(data, value, [significant_digits])Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
208StatisticalPERCENTRANK.INCPERCENTRANK.INC(data, value, [significant_digits])Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
209StatisticalPERMUTPERMUT(n, k)Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. 
210StatisticalPOISSONPOISSON(x, mean, cumulative)Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. 
211StatisticalPROBPROB(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. 
212StatisticalQUARTILEQUARTILE(data, quartile_number)Returns a value nearest to a specified quartile of a dataset. 
213StatisticalRANKRANK(value, data, is_ascending)Returns the rank of a specified value in a dataset.
214StatisticalRANK.AVGRANK.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.
215StatisticalRANK.EQRANK.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.
216StatisticalRSQRSQ(data_y, data_x)Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
217StatisticalSKEWSKEW(value1, value2)Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
218StatisticalSLOPESLOPE(data_y, data_x)Calculates the slope of the line resulting from linear regression of a dataset.
219StatisticalSMALLSMALL(data, n)Returns the nth smallest element from a data set, where n is user-defined.
220StatisticalSTANDARDIZESTANDARDIZE(value, mean, standard_deviation)Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. 
221StatisticalSTDEVSTDEV(value1, value2)Calculates the standard deviation based on a sample. 
222StatisticalSTDEVASTDEVA(value1, value2)Calculates the standard deviation based on a sample, setting text to the value `0`. 
223StatisticalSTDEVPSTDEVP(value1, value2)Calculates the standard deviation based on an entire population. 
224StatisticalSTDEVPASTDEVPA(value1, value2)Calculates the standard deviation based on an entire population, setting text to the value `0`. 
225StatisticalSTEYXSTEYX(data_y, data_x)Calculates the standard error of the predicted y-value for each x in the regression of a dataset.
226StatisticalT.INVT.INV(probability, degrees_freedom)Calculates the negative inverse of the one-tailed TDIST function. 
227StatisticalT.INV.2TT.INV.2T(probability, degrees_freedom)Calculates the inverse of the two-tailed TDIST function.
228StatisticalTDISTTDIST(x, degrees_freedom, tails)Calculates the probability for Student's t-distribution with a given input (x).
229StatisticalTINVTINV(probability, degrees_freedom)Calculates the inverse of the two-tailed TDIST function.
230StatisticalTRIMMEANTRIMMEAN(data, exclude_proportion)Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. 
231StatisticalTTESTTTEST(range1, range2, tails, type)Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. 
232StatisticalVARVAR(value1, value2)Calculates the variance based on a sample. 
233StatisticalVARAVARA(value1, value2)Calculates an estimate of variance based on a sample, setting text to the value `0`.
234StatisticalVARPVARP(value1, value2)Calculates the variance based on an entire population. 
235StatisticalVARPAVARPA(value1, value2)Calculates the variance based on an entire population, setting text to the value `0`. 
236StatisticalWEIBULLWEIBULL(x, shape, scale, cumulative)Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
237StatisticalZTESTZTEST(data, value, standard_deviation)Returns the two-tailed P-value of a Z-test with standard distribution. 
238StatisticalF.DIST.RTF.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.
239StatisticalFDISTFDIST(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.
240StatisticalF.DISTF.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.
241StatisticalFISHERFISHER(value)Returns the Fisher transformation of a specified value. 
242StatisticalFISHERINVFISHERINV(value)Returns the inverse Fisher transformation of a specified value. 
243Statistical

FORECAST

FORECAST(x, data_y, data_x)Calculates the expected y-value for a specified x based on a linear regression of a dataset.
244StatisticalGEOMEANGEOMEAN(value1, value2)Calculates the geometric mean of a dataset.
245StatisticalHARMEANHARMEAN(value1, value2)Calculates the harmonic mean of a dataset. 
246StatisticalHYPGEOMDISTHYPGEOMDIST(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. 
247StatisticalINTERCEPTINTERCEPT(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).
248StatisticalKURTKURT(value1, value2)Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.
249StatisticalLARGELARGE(data, n)Returns the nth largest element from a data set, where n is user-defined.
250StatisticalLOGINVLOGINV(x, mean, standard_deviation)Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. 
251StatisticalLOGNORMDISTLOGNORMDIST(x, mean, standard_deviation)Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. 
252StatisticalAVEDEVAVEDEV(value1, value2)Calculates the average of the magnitudes of deviations of data from a dataset's mean. 
253StatisticalMAXMAX(value1, value2)Returns the maximum value in a numeric dataset.
254StatisticalMAXAMAXA(value1, value2)Returns the maximum numeric value in a dataset.
255StatisticalMEDIANMEDIAN(value1, value2)Returns the median value in a numeric dataset. 
256StatisticalMINMIN(value1, value2)Returns the minimum value in a numeric dataset.
257StatisticalMINAMINA(value1, value2)Returns the minimum numeric value in a dataset.
258StatisticalMODEMODE(value1, value2)Returns the most commonly occurring value in a dataset.
259StatisticalAVERAGEAVERAGE(value1, value2)Returns the numerical average value in a dataset, ignoring text. 
260StatisticalAVERAGEAAVERAGEA(value1, value2)Returns the numerical average value in a dataset.
261StatisticalAVERAGEIFAVERAGEIF(criteria_range, criterion, [average_range])Returns the average of a range depending on criteria.
262StatisticalAVERAGEIFSAVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])Returns the average of a range depending on multiple criteria.
263StatisticalBINOMDISTBINOMDIST(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.
264StatisticalCONFIDENCECONFIDENCE(alpha, standard_deviation, pop_size)Calculates the width of half the confidence interval for a normal distribution. 
265StatisticalCORRELCORREL(data_y, data_x)Calculates r, the Pearson product-moment correlation coefficient of a dataset.
266StatisticalCOUNTCOUNT(value1, value2)Returns the a count of the number of numeric values in a dataset. 
267StatisticalCOUNTACOUNTA(value1, value2)Returns the a count of the number of values in a dataset. 
268StatisticalCOVARCOVAR(data_y, data_x)Calculates the covariance of a dataset. 
269StatisticalDEVSQDEVSQ(value1, value2)Calculates the sum of squares of deviations based on a sample. 
270StatisticalCRITBINOMCRITBINOM(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. 
271TextVALUEVALUE(text)Converts a string in any of the date, time or number formats that Excellentable understands into a number.
272TextTRIMTRIM(text)Removes leading and trailing spaces in a specified string. 
273TextTEXTTEXT(number, format)Converts a number into text according to a specified format. 
274TextTT(value)Returns string arguments as text. 
275TextSUBSTITUTESUBSTITUTE(text_to_search, search_for, replace_with, occurrence_number)Replaces existing text with new text in a string. 
276TextSEARCHSEARCH(search_for, text_to_search, starting_at)Returns the position at which a string is first found within text. 
277TextROMANROMAN(number, rule_relaxation)Formats a number in Roman numerals. 
278TextRIGHTRIGHT(string, number_of_characters)Returns a substring from the end of a specified string.
279TextREPTREPT(text_to_repeat, number_of_repetitions)Returns specified text repeated a number of times.
280TextREPLACEREPLACE(text, position, length, new_text)Replaces part of a text string with a different text string.
281TextUPPERUPPER(text)Converts a specified string to uppercase.
282TextMIDMID(string, starting_at, extract_length)Returns a segment of a string.
283TextLOWERLOWER(text)Converts a specified string to lowercase. 
284TextLENLEN(text)Returns the length of a string. 
285TextLEFTLEFT(string, number_of_characters)Returns a substring from the beginning of a specified string. 
286TextFIXEDFIXED(number, number_of_places, suppress_separator)Formats a number with a fixed number of decimal places. 
287TextFINDFIND(search_for, text_to_search, starting_at)Returns the position at which a string is first found within text. 
288TextEXACTEXACT(string1, string2)Tests whether two strings are identical. 
289TextDOLLARDOLLAR(number, number_of_places)Formats a number into the locale-specific currency format. 
290TextCONCATENATECONCATENATE(string1, string2)Appends strings to one another. 
291TextCLEANCLEAN(text)Returns the text with the non-printable ASCII characters removed.
292TextCHARCHAR(table_number)Convert a number into a character according to the current Unicode table. 
293TextCODECODE(string)Returns the numeric Unicode map value of the first character in the string provided. 
294 AMORDEGRCAMORDEGRC(cost,datepurchased,firstperiod,salvage,period,drate,basis)Returns the depreciation for each accounting period.
295 AMORLINCAMORLINC(cost,datepurchased,firstperiod,salvage,period,drate,basis)Calculates the depreciation for an accounting period, taking into account prorated depreciation.
296 AREASPARKLINEAREASPARKLINE(points, min, max, line1, line2, colorPositive, colorNegative) 
297 BESSELIBESSELI(value,order)Calculates the modified Bessel function of the first kind evaluated for purely imaginary arguments..
298 BESSELJBESSELJ(value,order)Returns the Bessel function.
299 BESSELKBESSELK(value,order)Calculates the modified Bessel function of the second kind evaluated for purely imaginary arguments.
300 BESSELYBESSELY(value,order)Returns the Bessel function, which is also called the Weber function or the Neumann function.
301 BETA.DISTBETA.DIST(x,alpha,beta,cumulative,lower,upper)Returns the beta distribution.
302 BETA.INVBETAINV(prob,alpha,beta,lower,upper)Returns the inverse of the beta cumulative probability density function (BETA.DIST).
303 BETADISTBETADIST(x,alpha,beta,lower,upper)Returns the cumulative beta probability density function.
304 BETAINVBETAINV(prob,alpha,beta,lower,upper)Returns the inverse of the cumulative beta probability density function for a specified beta distribution.
305 BINOM.DISTBINOM.DIST(number_s,trials,probability_s,cumulative)Returns the individual term binomial distribution probability.
306 BINOM.INVBINOM.INV(trials,probability_s,alpha)Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
307 BOXPLOTSPARKLINEBOXPLOTSPARKLINE(points, boxPlotClass, showAverage, scaleStart, scaleEnd, acceptableStart, acceptableEnd, colorScheme, style, vertical) 
308 BULLETSPARKLINEBULLETSPARKLINE(measure, target, maxi, good?, bad?, forecast?, tickunit?, colorScheme?, vertical?) 
309 CASCADESPARKLINECASCADESPARKLINE(pointsRange, pointIndex, labelsRange, minimum, maximum, colorPositive, colorNegative, vertical) 
310 CEILING.PRECISECEILING.PRECISE(number, [significance])Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
311 CHIDISTCHIDIST(value,deg)Returns the right-tailed probability of the chi-squared distribution.
312 CHIINVCHIINV(probability,deg_freedom)Returns the inverse of the right-tailed probability of the chi-squared distribution.
313 CHISQ.DISTCHISQ.DIST(value,deg_freedom,cumulative)Returns the chi-squared distribution.
314 CHISQ.DIST.RTCHISQ.DIST.RT(value,deg_freedom)Returns the right-tailed probability of the chi-squared distribution.
315 CHISQ.INVCHISQ.INV(probability,deg_freedom)Returns the inverse of the left-tailed probability of the chi-squared distribution.
316 CHISQ.INV.RTCHISQ.INV.RT(probability,deg_freedom)Returns the inverse of the right-tailed probability of the chi-squared distribution.
317 CHISQ.TESTCHISQ.TEST(actual_range,expected_range)Returns the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.
318 CHITESTCHITEST(actual_range,expected_range)Calculates the test for independence from the chi-squared distribution.
319 COLUMNSPARKLINECOLUMNSPARKLINE(data, dataOrientation, dateAxisData, dateAxisOrientation, setting) 
320 COMPLEXCOMPLEX(realcoeff,imagcoeff,suffix)Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
321 CONFIDENCE.NORMCONFIDENCE.NORM(alpha,standard_dev,size)Returns the confidence interval for a population mean, using a normal distribution.
322 CONFIDENCE.TCONFIDENCE.T(alpha,standard_dev,size)Returns the confidence interval for a population mean, using a Student's t distribution.
323 COVARIANCE.PCOVARIANCE.P(array1,array2)Returns population covariance, the average of the products of deviations for each data point pair in two data sets.
324 COVARIANCE.SCOVARIANCE.S(array1,array2)Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
325 ERFERF(limit,upperlimit)Returns the error function integrated between lower_limit and upper_limit.
326 ERF.PRECISEERF.PRECISE(limit)Returns the error function.
327 EUROEURO(code)This function returns the equivalent of one Euro based on the ISO currency code.
328 EUROCONVERTEUROCONVERT(number,source,target,full_precision,triangulation_precision)Converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).
329 EXPON.DISTEXPON.DIST(value,lambda,cumulative)Returns the exponential distribution.
330 F.INVF.INV(probability,deg_freedom1,deg_freedom2)Returns the inverse of the F probability distribution.
331  F.INV.RTF.INV.RT(probability,deg_freedom1,deg_freedom2)Returns the inverse of the (right-tailed) F probability distribution.
332 F.TESTF.TEST(array1,array2)

Returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different.

333 FINVFINV(probability,deg_freedom1,deg_freedom2)Returns the inverse of the (right-tailed) F probability distribution.
334 FLOOR.PRECISEFLOOR.PRECISE(number, [significance])Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance.
335 FTESTFTEST(array1,array2)Returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different.
336 GAMMA.DISTGAMMA.DIST(value,alpha,beta,cumulative)Returns the gamma distribution.
337 GAMMA.INVGAMMA.INV(probability,alpha,beta)Returns the inverse of the gamma cumulative distribution.
338 GAMMADISTGAMMADIST(value,alpha,beta,cumulative)Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution.
339 GAMMAINVGAMMAINV(probability,alpha,beta)Returns the inverse of the gamma cumulative distribution. 
340 GAMMALN.PRECISE

GAMMALN.PRECISE(value)

Returns the natural logarithm of the gamma function, Γ(x).
341 GESTEPGESTEP(number, [step])Returns 1 if number ≥ step; returns 0 (zero) otherwise.
342 HBARSPARKLINEHBARSPARKLINE(value, colorScheme) 
343 HYPGEOM.DISTHYPGEOM.DIST(sample_s,number_sample,population_s,number_pop,cumulative)Returns the probability of a given number of sample successes, given the sample size, population successes, and population size.
344 IMABSIMABS(inumber)Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
345 IMAGINARYIMAGINARY(inumber)

Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

346 IMARGUMENTIMARGUMENT(inumber)
Returns the argument 
 (theta), an angle expressed in radians.
347 IMCONJUGATEIMCONJUGATE(inumber)Returns the complex conjugate of a complex number in x + yi or x + yj text format.
348 IMCOSIMCOS(inumber)Returns the cosine of a complex number in x + yi or x + yj text format.
349 IMDIVIMDIV(inumber1, inumber2)Returns the quotient of two complex numbers in x + yi or x + yj text format.
350 IMEXPIMEXP(inumber)Returns the exponential of a complex number in x + yi or x + yj text format.
351 IMLNIMLN(inumber)Returns the natural logarithm of a complex number in x + yi or x + yj text format.
352 IMSQRTIMSQRT(inumber)Returns the square root of a complex number in x + yi or x + yj text format.
353 IMSUBIMSUB(inumber1, inumber2)Returns the difference of two complex numbers in x + yi or x + yj text format.
354 IMLOG2IMLOG2(inumber)Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
355 IMLOG10

IMLOG10(inumber)

Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

356 IMPOWERIMPOWER(inumber, number)Returns a complex number in x + yi or x + yj text format raised to a power.
357 IMPRODUCTIMPRODUCT(inumber1, [inumber2], ...)Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.
358 IMREALIMREAL(inumber)

Returns the real coefficient of a complex number in x + yi or x + yj text format.

359 IMSINIMSIN(inumber)Returns the sine of a complex number in x + yi or x + yj text format.
360 IMSUMIMSUM(inumber1, [inumber2], ...)Returns the sum of two or more complex numbers in x + yi or x + yj text format.
361 ISO.CEILING ISO.CEILING(number, [significance])Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
362 ISPMTISPMT(rate, per, nper, pv)Calculates the interest paid during a specific period of an investment.
363 LINESPARKLINELINESPARKLINE(data, dataOrientation, dateAxisData, dateAxisOrientation, setting) 
364 LOGNORM.DISTLOGNORM.DIST(value,mean,standard_dev,cumulative)Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.
365 LOGNORM.INVLOGNORM.INV(probability, mean, standard_dev)Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.
366 MODE.MULTMODE.MULT((number1,[number2],...)Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
367 MODE.SNGLMODE.SNGL(number1,[number2],...)Returns the most frequently occurring, or repetitive, value in an array or range of data.
368 NEGBINOM.DISTNEGBINOM.DIST(number_f,number_s,probability_s,cumulative)Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success.
369 NORM.DISTNORM.DIST(value,mean,standard_dev,cumulative)Returns the normal distribution for the specified mean and standard deviation.
370 NORM.INVNORM.INV(probability,mean,standard_dev)Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
371 NORM.S.DISTNORM.S.DIST(value,cumulative)Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
372 NORM.S.INVNORM.S.INV(probability)

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

373 ODDFPRICEODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])Returns the price per $100 face value of a security having an odd (short or long) first period.
374 ODDFYIELDODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])Returns the yield of a security that has an odd (short or long) first period.
375 ODDLPRICEODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])Returns the price per $100 face value of a security having an odd (short or long) last coupon period.
376 ODDLYIELDODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])Returns the yield of a security that has an odd (short or long) last period.
377 PARETOSPARKLINEPARETOSPARKLINE(points, pointIndex, colorRange, target, target2, highlightPosition, label, vertical) 
378 PERCENTILE.EXCPERCENTILE.EXC(array,value)Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
379 PERCENTILE.INCPERCENTILE.INC(array,value)Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
380 PIESPARKLINEPIESPARKLINE(Percentage,color1,color2,.....) 
381 POISSON.DISTPOISSON.DIST(value,mean,cumulative)Returns the Poisson distribution.
382 QUARTILE.EXCQUARTILE.EXC(array, quart)Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
383 QUARTILE.INCQUARTILE.INC(array,quart)Returns the quartile of a data set, based on percentile values from 0..1, inclusive.
384 SCATTERSPARKLINESCATTERSPARKLINE(points1, points2, minX, maxX, minY, maxY, hLine, vLine, xMinZone, xMaxZone, yMinZone, yMaxZone, tags, drawSymbol, drawLines, color1, color2, dash) 
385 SPREADSPARKLINESPREADSPARKLINE(points, showAverage?, scaleStart?, scaleEnd?, style?, colorScheme?, vertical?) 
386 STACKEDSPARKLINESTACKEDSPARKLINE(points, colorRange?, labelRange?, maximum?, targetRed?, targetGreen?, targetBlue?, tragetYellow?, color?, highlightPosition?, vertical?, textOrientation?, textSize?) 
387 STDEV.PSTDEV.P(number1,[number2],...)Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
388 STDEV.SSTDEV.S(number1,[number2],...)Estimates standard deviation based on a sample (ignores logical values and text in the sample).
389 T.DIST

T.DIST(value,deg_freedom, cumulative)

Returns the Student's left-tailed t-distribution.
390 T.DIST.2T

T.DIST.2T(value,deg_freedom)

Returns the two-tailed Student's t-distribution.
391 T.DIST.RTT.DIST.RT(value,deg_freedom)Returns the right-tailed Student's t-distribution.
392 VAR.PVAR.P(number1,[number2],...)Calculates variance based on the entire population (ignores logical values and text in the population).
393 VAR.SVAR.S(number1,[number2],...)Estimates variance based on a sample (ignores logical values and text in the sample).
394 VARISPARKLINEVARISPARKLINE(variance, reference, mini, maxi, mark, tickunit, legend, colorPositive, colorNegative, vertical) 
395 VBARSPARKLINEVBARSPARKLINE(value, colorScheme) 
396 VDB

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method
397 WEIBULL.DISTWEIBULL.DIST(value,alpha,beta,cumulative)Returns the Weibull distribution.
398 WINLOSSSPARKLINEWINLOSSSPARKLINE(data, dataOrientation, dateAxisData, dateAxisOrientation, setting) 
399 YIELDMATYIELDMAT(settlement, maturity, issue, rate, pr, [basis])Returns the annual yield of a security that pays interest at maturity.
400 Z.TESTZ.TEST(array,x,[sigma])Returns the one-tailed P-value of a z-test.
401 ERFC.PRECISEERFC.PRECISE(x)Returns the complementary ERF function integrated between x and infinity.
402 T.TESTT.TEST(array1,array2,tails,type)Returns the probability associated with a Student's T-Test.
403TextPROPERPROPER(text_to_capitalize)Capitalizes each word in a specified string.
404StatisticalEXPONDISTEXPONDIST(value, lambda, [cumulative])Returns the value of the exponential distribution function with a specified lambda at a specified value.

Questions?

For further questions or concerns please contact us at support@addteq.com