Using Formulas | Excellentable Help Center

Nesting formulas are supported!

List of Formulas Supported by Excellentable:

#	Type	Name	Input Data	Description
1	Array	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.
2	Array	SUMXMY2	`SUMXMY2(array_x, array_y)`	Calculates the sum of the squares of differences of values in two arrays.
3	Array	SUMX2PY2	`SUMX2PY2(array_x, array_y)`	Calculates the sum of the sums of the squares of values in two arrays.
4	Array	SUMX2MY2	`SUMX2MY2(array_x, array_y)`	Calculates the sum of the differences of the squares of values in two arrays.
5	Array	SUMPRODUCT	`SUMPRODUCT(array1, array2)`	Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
6	Array	MMULT	`MMULT(matrix1, matrix2)`	Calculates the matrix product of two matrices specified as arrays or ranges.
7	Array	MINVERSE	`MINVERSE(square_matrix)`	Returns the multiplicative inverse of a square matrix specified as an array or range.
8	Array	MDETERM	`MDETERM(square_matrix)`	Returns the matrix determinant of a square matrix specified as an array or range.
9	Array	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.
10	Array	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.
11	Array	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.
12	Array	FREQUENCY	`FREQUENCY(data, classes)`	Calculates the frequency distribution of a one-column array into specified classes.
13	Array	TRANSPOSE	`TRANSPOSE(array_or_range)`	Transposes the rows and columns of an array or range of cells.
14	Database	DMIN	`DMIN(database, field, criteria)`	Returns the minimum value selected from a database table-like array or range using a SQL-like query.
15	Database	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.
16	Database	DSUM	`DSUM(database, field, criteria)`	Returns the sum of values selected from a database table-like array or range using a SQL-like query.
17	Database	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.
18	Database	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.
19	Database	DPRODUCT	`DPRODUCT(database, field, criteria)`	Returns the product of values selected from a database table-like array or range using a SQL-like query.
20	Database	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.
21	Database	DMAX	`DMAX(database, field, criteria)`	Returns the maximum value selected from a database table-like array or range using a SQL-like query.
22	Database	DGET	`DGET(database, field, criteria)`	Returns a single value from a database table-like array or range using a SQL-like query.
23	Database	DCOUNTA	`DCOUNTA(database, field, criteria)`	Counts values, including text, selected from a database table-like array or range using a SQL-like query.
24	Database	DCOUNT	`DCOUNT(database, field, criteria)`	Counts numeric values selected from a database table-like array or range using a SQL-like query.
25	Database	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.
26	Date	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.
27	Date	HOUR	`HOUR(time)`	Returns the hour component of a specific time, in numeric format.
28	Date	MINUTE	`MINUTE(time)`	Returns the minute component of a specific time, in numeric format.
29	Date	MONTH	`MONTH(date)`	Returns the month of the year a specific date falls in, in numeric format.
30	Date	NETWORKDAYS	`NETWORKDAYS(start_date, end_date, holidays)`	Returns the number of net working days between two provided days.
31	Date	NETWORKDAYS.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.
32	Date	NOW	`NOW()`	Returns the current date and time as a date value.
33	Date	SECOND	`SECOND(time)`	Returns the second component of a specific time, in numeric format.
34	Date	TIME	`TIME(hour, minute, second)`	Converts a provided hour, minute, and second into a time.
35	Date	TIMEVALUE	`TIMEVALUE(time_string)`	Returns the fraction of a 24-hour day the time represents.
36	Date	TODAY	`TODAY()`	Returns the current date as a date value.
37	Date	WEEKDAY	`WEEKDAY(date, type)`	Returns a number representing the day of the week of the date provided.
38	Date	WEEKNUM	`WEEKNUM(date, [type])`	Returns a number representing the week of the year where the provided date falls.
39	Date	WORKDAY	`WORKDAY(start_date, num_days, holidays)`	Calculates the number of working days from a specified start date.
40	Date	WORKDAY.INTL	`WORKDAY.INTL(start_date, num_days, [weekend], [holidays])`	Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
41	Date	YEAR	`YEAR(date)`	Returns the year specified by a given date.
42	Date	YEARFRAC	`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.
43	Date	DATE	`DATE(year, month, day)`	Converts a provided year, month, and day into a date.
44	Date	DATEVALUE	`DATEVALUE(date_string)`	Converts a provided date string in a known format to a date value.
45	Date	DAY	`DAY(date)`	Returns the day of the month that a specific date falls on, in numeric format.
46	Date	DAYS360	`DAYS360(start_date, end_date, method)`	Returns the difference between two days based on the 360 day year used in some financial interest calculations.
47	Date	EDATE	`EDATE(start_date)`	Returns a date a specified number of months before or after another date.
48	Date	DATEDIF	`DATEDIF(start_date, end_date, unit)`	Calculates the number of days, months, or years between two dates.
49	Engineering	HEX2DEC	`HEX2DEC(signed_hexadecimal_number)`	Converts a signed hexadecimal number to decimal format.
50	Engineering	BIN2DEC	`BIN2DEC(signed_binary_number)`	Converts a signed binary number to decimal format.
51	Engineering	BIN2HEX	`BIN2HEX(signed_binary_number, significant_digits)`	Converts a signed binary number to signed hexadecimal format.
52	Engineering	BIN2OCT	`BIN2OCT(signed_binary_number, significant_digits)`	Converts a signed binary number to signed octal format.
53	Engineering	OCT2HEX	`OCT2HEX(signed_octal_number, significant_digits)`	Converts a signed octal number to signed hexadecimal format.
54	Engineering	OCT2DEC	`OCT2DEC(signed_octal_number)`	Converts a signed octal number to decimal format.
55	Engineering	OCT2BIN	`OCT2BIN(signed_octal_number, significant_digits)`	Converts a signed octal number to signed binary format.
56	Engineering	HEX2OCT	`HEX2OCT(signed_hexadecimal_number, significant_digits)`	Converts a signed hexadecimal number to signed octal format.
57	Engineering	DEC2BIN	`DEC2BIN(decimal_number, significant_digits)`	Converts a decimal number to signed binary format.
58	Engineering	HEX2BIN	`HEX2BIN(signed_hexadecimal_number, significant_digits)`	Converts a signed hexadecimal number to signed binary format.
59	Engineering	DELTA	`DELTA(number1, [number2])`	Compare two numeric values, returning 1 if they're equal.
60	Engineering	DEC2OCT	`DEC2OCT(decimal_number, significant_digits)`	Converts a decimal number to signed octal format.
61	Engineering	DEC2HEX	`DEC2HEX(decimal_number, significant_digits)`	Converts a decimal number to signed hexadecimal format.
62	Financial	DISC	`DISC(settlement, maturity, price, redemption, day_count_convention)`	Calculates the discount rate of a security based on price.
63	Financial	PRICEDISC	`PRICEDISC(settlement, maturity, discount, redemption, day_count_convention)`	Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
64	Financial	PRICEMAT	`PRICEMAT(settlement, maturity, issue, rate, yield, day_count_convention)`	Calculates the price of a security paying interest at maturity, based on expected yield.
65	Financial	PV	`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.
66	Financial	RATE	`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.
67	Financial	RECEIVED	`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.
68	Financial	SLN	`SLN(cost, salvage, life)`	Calculates the depreciation of an asset for one period using the straight-line method.
69	Financial	SYD	`SYD(cost, salvage, life, period)`	Calculates the depreciation of an asset for a specified period using the sum of years digits method.
70	Financial	TBILLEQ	`TBILLEQ(settlement, maturity, discount)`	Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
71	Financial	TBILLPRICE	`TBILLPRICE(settlement, maturity, discount)`	Calculates the price of a US Treasury Bill based on discount rate.
72	Financial	TBILLYIELD	`TBILLYIELD(settlement, maturity, price)`	Calculates the yield of a US Treasury Bill based on price.
73	Financial	XIRR	`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.
74	Financial	XNPV	`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.
75	Financial	YIELD	`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.
76	Financial	YIELDDISC	`YIELDDISC(settlement, maturity, price, redemption, day_count_convention)`	Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
77	Financial	CUMPRINC	`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.
78	Financial	CUMIPMT	`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.
79	Financial	COUPPCD	`COUPPCD(settlement, maturity, frequency, day_count_convention)`	Calculates last coupon, or interest payment, date before the settlement date.
80	Financial	COUPNUM	`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.
81	Financial	COUPNCD	COUPNCD(settlement, maturity, frequency, [day_count_convention])	Calculates next coupon, or interest payment, date after the settlement date.
82	Financial	COUPDAYSNC	`COUPDAYSNC(settlement, maturity, frequency, day_count_convention)`	Calculates the number of days from the settlement date until the next coupon, or interest payment.
83	Financial	COUPDAYS	`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.
84	Financial	COUPDAYBS	`COUPDAYBS(settlement, maturity, frequency, day_count_convention)`	Calculates the number of days from the first coupon, or interest payment, until settlement.
85	Financial	ACCRINTM	`ACCRINTM(issue, maturity, rate, redemption, day_count_convention)`	Calculates the accrued interest of a security that pays interest at maturity.
86	Financial	ACCRINT	`ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, day_count_convention)`	Calculates the accrued interest of a security that has periodic payments.
87	Financial	DB	`DB(cost, salvage, life, period, month)`	Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
88	Financial	DURATION	`DURATION(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.
89	Financial	EFFECT	`EFFECT(nominal_rate, periods_per_year)`	Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
90	Financial	FV	`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.
91	Financial	FVSCHEDULE	`FVSCHEDULE(principal, rate_schedule)`	Calculates the future value of some principal based on a specified series of potentially varying interest rates.
92	Financial	INTRATE	`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.
93	Financial	IPMT	`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.
94	Financial	IRR	`IRR(cashflow_amounts, rate_guess)`	Calculates the internal rate of return on an investment based on a series of periodic cash flows.
95	Financial	MDURATION	`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.
96	Financial	MIRR	`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.
97	Financial	NOMINAL	`NOMINAL(effective_rate, periods_per_year)`	Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
98	Financial	NPER	`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.
99	Financial	DOLLARDE	`DOLLARDE(fractional_price, unit)`	Converts a price quotation given as a decimal fraction into a decimal value.
100	Financial	NPV	`NPV(discount, cashflow1, cashflow2)`	Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
101	Financial	PMT	`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.
102	Financial	PPMT	`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.
103	Financial	DOLLARFR	`DOLLARFR(decimal_price, unit)`	Converts a price quotation given as a decimal value into a decimal fraction.
104	Financial	PRICE	`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.
105	Financial	DDB	`DDB(cost, salvage, life, period, factor)`	Calculates the depreciation of an asset for a specified period using the double-declining balance method.
106	Info	ISREF	`ISREF(value)`	Checks whether a value is a valid cell reference.
107	Info	TYPE	`TYPE(value)`	Returns a number associated with the type of data passed into the function.
108	Info	ERROR.TYPE	`ERROR.TYPE(reference)`	Returns a number corresponding to the error value in a different cell.
109	Info	ISBLANK	`ISBLANK(value)`	Checks whether the referenced cell is empty.
110	Info	ISERR	`ISERR(value)`	Checks whether a value is an error other than `#N/A`.
111	Info	ISERROR	`ISERROR(value)`	Checks whether a value is an error.
112	Info	ISLOGICAL	`ISLOGICAL(value)`	Checks whether a value is `TRUE` or `FALSE`.
113	Info	NA	`NA()`	Returns the "value not available" error, `#N/A`.
114	Info	N	`N(value)`	Returns the argument provided as a number.
115	Info	ISNUMBER	`ISNUMBER(value)`	Checks whether a value is a number.
116	Info	ISNONTEXT	`ISNONTEXT(value)`	Checks whether a value is non-textual.
117	Info	ISNA	`ISNA(value)`	Checks whether a value is the error `#N/A`.
118	Info	ISTEXT	`ISTEXT(value)`	Checks whether a value is text.
119	Logical	TRUE	`TRUE()`	Returns the logical value `TRUE`.
120	Logical	OR	`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.
121	Logical	NOT	`NOT(logical_expression)`	Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
122	Logical	IFERROR	`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.
123	Logical	IF	`IF(logical_expression, value_if_true, value_if_false)`	Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
124	Logical	FALSE	`FALSE()`	Returns the logical value `FALSE`.
125	Logical	AND	`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.
126	Lookup	HLOOKUP	`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.
127	Lookup	ROWS	`ROWS(range)`	Returns the number of rows in a specified array or range.
128	Lookup	COLUMN	`COLUMN(cell_reference)`	Returns the column number of a specified cell, with `A=1`.
129	Lookup	CHOOSE	`CHOOSE(index, choice1, choice2)`	Returns an element from a list of choices based on index.
130	Lookup	ADDRESS	`ADDRESS(row, column, absolute_relative_mode, use_a1_notation, sheet)`	Returns a cell reference as a string.
131	Lookup	VLOOKUP	`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.
132	Lookup	ROW	`ROW(cell_reference)`	Returns the row number of a specified cell.
133	Lookup	OFFSET	`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.
134	Lookup	MATCH	`MATCH(search_key, range, search_type)`	Returns the relative position of an item in a range that matches a specified value.
135	Lookup	LOOKUP	`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.
136	Lookup	INDIRECT	`INDIRECT(cell_reference_as_string)`	Returns a cell reference specified by a string.
137	Lookup	INDEX	`INDEX(reference, row, column)`	Returns the content of a cell, specified by row and column offset.
138	Lookup	COLUMNS	`COLUMNS(range)`	Returns the number of columns in a specified array or range.
139	Math	LCM	`LCM(value1, value2)`	Returns the least common multiple of one or more integers.
140	Math	LN	`LN(value)`	Returns the the logarithm of a number, base e (Euler's number).
141	Math	LOG	`LOG(value, base)`	Returns the the logarithm of a number given a base.
142	Math	LOG10	`LOG10(value)`	Returns the the logarithm of a number, base 10.
143	Math	MOD	`MOD(dividend, divisor)`	Returns the result of the modulo operator, the remainder after a division operation.
144	Math	MROUND	`MROUND(value, factor)`	Rounds one number to the nearest integer multiple of another.
145	Math	MULTINOMIAL	`MULTINOMIAL(value1, value2)`	Returns the factorial of the sum of values divided by the product of the values' factorials.
146	Math	ODD	`ODD(value)`	Rounds a number up to the nearest odd integer.
147	Math	PI	`PI()`	Returns the value of Pi to 14 decimal places.
148	Math	POWER	`POWER(base, exponent)`	Returns a number raised to a power.
149	Math	PRODUCT	`PRODUCT(factor1, factor2)`	Returns the result of multiplying a series of numbers together.
150	Math	QUOTIENT	`QUOTIENT(dividend, divisor)`	Returns one number divided by another.
151	Math	RADIANS	`RADIANS(angle)`	Converts an angle value in degrees to radians.
152	Math	RAND	`RAND()`	Returns a random number between 0 inclusive and 1 exclusive.
153	Math	RANDBETWEEN	`RANDBETWEEN(low, high)`	Returns a uniformly random integer between two values, inclusive.
154	Math	ROUND	`ROUND(value, places)`	Rounds a number to a certain number of decimal places according to standard rules.
155	Math	ROUNDDOWN	`ROUNDDOWN(value, places)`	Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
156	Math	ROUNDUP	`ROUNDUP(value, places)`	Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
157	Math	SERIESSUM	`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`.
158	Math	SIGN	`SIGN(value)`	Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
159	Math	SIN	`SIN(angle)`	Returns the sine of an angle provided in radians.
160	Math	SINH	`SINH(value)`	Returns the hyperbolic sine of any real number.
161	Math	SQRT	`SQRT(value)`	Returns the positive square root of a positive number
162	Math	SQRTPI	`SQRTPI(value)`	Returns the positive square root of the product of Pi and the given positive number.
163	Math	SUBTOTAL	`SUBTOTAL(function_code, range1, range2)`	Returns a subtotal for a vertical range of cells using a specified aggregation function.
164	Math	SUM	`SUM(value1, value2)`	Returns the sum of a series of numbers and/or cells.
165	Math	SUMIF	`SUMIF(range, criterion, sum_range)`	Returns a conditional sum across a range.
166	Math	SUMIFS	`SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the sum of a range depending on multiple criteria.
167	Math	SUMSQ	`SUMSQ(value1, value2)`	Returns the sum of the squares of a series of numbers and/or cells.
168	Math	TAN	`TAN(angle)`	Returns the tangent of an angle provided in radians.
169	Math	TANH	`TANH(value)`	Returns the hyperbolic tangent of any real number
170	Math	TRUNC	`TRUNC(value, places)`	Truncates a number to a certain number of significant digits by omitting less significant digits.
171	Math	ABS	`ABS(value)`	Returns the absolute value of a number.
172	Math	ACOS	`ACOS(value)`	Returns the inverse cosine of a value, in radians.
173	Math	ACOSH	`ACOSH(value)`	Returns the inverse hyperbolic cosine of a number.
174	Math	ASIN	`ASIN(value)`	Returns the inverse sine of a value, in radians.
175	Math	ASINH	`ASINH(value)`	Returns the inverse hyperbolic sine of a number
176	Math	ATAN	`ATAN(value)`	Returns the inverse tangent of a value, in radians.
177	Math	ATAN2	`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.
178	Math	ATANH	`ATANH(value)`	Returns the inverse hyperbolic tangent of a number.
179	Math	CEILING	`CEILING(value, factor)`	Rounds a number up to the nearest integer multiple of specified significance.
180	Math	COMBIN	`COMBIN(n, k)`	Returns the number of ways to choose some number of objects from a pool of a given size of objects.
181	Math	COS	`COS(angle)`	Returns the cosine of an angle provided in radians.
182	Math	COSH	`COSH(value)`	Returns the hyperbolic cosine of any real number.
183	Math	COUNTBLANK	`COUNTBLANK(range)`	Returns the number of empty cells in a given range.
184	Math	COUNTIF	`COUNTIF(range, criterion)`	Returns a conditional count across a range.
185	Math	COUNTIFS	`COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the count of a range depending on multiple criteria.
186	Math	DEGREES	`DEGREES(angle)`	Converts an angle value in radians to degrees.
187	Math	ERFC	`ERFC(z)`	Returns the complementary Gauss error function of a value.
188	Math	EVEN	`EVEN(value)`	Rounds a number up to the nearest even integer.
189	Math	EXP	`EXP(exponent)`	Returns Euler's number, e (~2.718) raised to a power.
190	Math	FACT	`FACT(value)`	Returns the factorial of a number.
191	Math	FACTDOUBLE	`FACTDOUBLE(value)`	Returns the "double factorial" of a number.
192	Math	FLOOR	`FLOOR(value, factor)`	Rounds a number down to the nearest integer multiple of specified significance.
193	Math	GAMMALN	`GAMMALN(value)`	Returns the the logarithm of a specified Gamma function, base e (Euler's number).
194	Math	GCD	`GCD(value1, value2)`	Returns the greatest common divisor of one or more integers.
195	Math	INT	`INT(value)`	Rounds a number down to the nearest integer that is less than or equal to it.
196	Math	ISEVEN	`ISEVEN(value)`	Checks whether the provided value is even.
197	Math	ISODD	`ISODD(value)`	Checks whether the provided value is odd.
198	Parser	CONVERT	`CONVERT(value, start_unit, end_unit)`	Converts a numeric value to a different unit of measure.
199	Statistical	NEGBINOMDIST	`NEGBINOMDIST(num_failures, num_successes, prob_success)`	Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.
200	Statistical	NORMDIST	`NORMDIST(x, mean, standard_deviation, cumulative)`	Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
201	Statistical	NORMINV	`NORMINV(x, mean, standard_deviation)`	Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.
202	Statistical	NORMSDIST	`NORMSDIST(x)`	Returns the value of the standard normal cumulative distribution function for a specified value.
203	Statistical	NORMSINV	`NORMSINV(x)`	Returns the value of the inverse standard normal distribution function for a specified value.
204	Statistical	PEARSON	`PEARSON(data_y, data_x)`	Calculates r, the Pearson product-moment correlation coefficient of a dataset.
205	Statistical	PERCENTILE	`PERCENTILE(data, percentile)`	Returns the value at a given percentile of a dataset.
206	Statistical	PERCENTRANK	`PERCENTRANK(data, value, [significant_digits])`	Returns the percentage rank (percentile) of a specified value in a dataset.
207	Statistical	PERCENTRANK.EXC	`PERCENTRANK.EXC(data, value, [significant_digits])`	Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
208	Statistical	PERCENTRANK.INC	`PERCENTRANK.INC(data, value, [significant_digits])`	Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
209	Statistical	PERMUT	`PERMUT(n, k)`	Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
210	Statistical	POISSON	`POISSON(x, mean, cumulative)`	Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.
211	Statistical	PROB	`PROB(data, probabilities, low_limit, high_limit)`	Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.
212	Statistical	QUARTILE	`QUARTILE(data, quartile_number)`	Returns a value nearest to a specified quartile of a dataset.
213	Statistical	RANK	`RANK(value, data, is_ascending)`	Returns the rank of a specified value in a dataset.
214	Statistical	RANK.AVG	`RANK.AVG(value, data, [is_ascending])`	Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.
215	Statistical	RANK.EQ	`RANK.EQ(value, data, [is_ascending])`	Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.
216	Statistical	RSQ	`RSQ(data_y, data_x)`	Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
217	Statistical	SKEW	`SKEW(value1, value2)`	Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
218	Statistical	SLOPE	`SLOPE(data_y, data_x)`	Calculates the slope of the line resulting from linear regression of a dataset.
219	Statistical	SMALL	`SMALL(data, n)`	Returns the nth smallest element from a data set, where n is user-defined.
220	Statistical	STANDARDIZE	`STANDARDIZE(value, mean, standard_deviation)`	Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.
221	Statistical	STDEV	`STDEV(value1, value2)`	Calculates the standard deviation based on a sample.
222	Statistical	STDEVA	`STDEVA(value1, value2)`	Calculates the standard deviation based on a sample, setting text to the value `0`.
223	Statistical	STDEVP	`STDEVP(value1, value2)`	Calculates the standard deviation based on an entire population.
224	Statistical	STDEVPA	`STDEVPA(value1, value2)`	Calculates the standard deviation based on an entire population, setting text to the value `0`.
225	Statistical	STEYX	`STEYX(data_y, data_x)`	Calculates the standard error of the predicted y-value for each x in the regression of a dataset.
226	Statistical	T.INV	`T.INV(probability, degrees_freedom)`	Calculates the negative inverse of the one-tailed TDIST function.
227	Statistical	T.INV.2T	`T.INV.2T(probability, degrees_freedom)`	Calculates the inverse of the two-tailed TDIST function.
228	Statistical	TDIST	`TDIST(x, degrees_freedom, tails)`	Calculates the probability for Student's t-distribution with a given input (x).
229	Statistical	TINV	`TINV(probability, degrees_freedom)`	Calculates the inverse of the two-tailed TDIST function.
230	Statistical	TRIMMEAN	`TRIMMEAN(data, exclude_proportion)`	Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.
231	Statistical	TTEST	`TTEST(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.
232	Statistical	VAR	`VAR(value1, value2)`	Calculates the variance based on a sample.
233	Statistical	VARA	`VARA(value1, value2)`	Calculates an estimate of variance based on a sample, setting text to the value `0`.
234	Statistical	VARP	`VARP(value1, value2)`	Calculates the variance based on an entire population.
235	Statistical	VARPA	`VARPA(value1, value2)`	Calculates the variance based on an entire population, setting text to the value `0`.
236	Statistical	WEIBULL	`WEIBULL(x, shape, scale, cumulative)`	Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
237	Statistical	ZTEST	`ZTEST(data, value, standard_deviation)`	Returns the two-tailed P-value of a Z-test with standard distribution.
238	Statistical	F.DIST.RT	`F.DIST.RT(x, degrees_freedom1, degrees_freedom2)`	Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.
239	Statistical	FDIST	`FDIST(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.
240	Statistical	F.DIST	`F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)`	Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.
241	Statistical	FISHER	`FISHER(value)`	Returns the Fisher transformation of a specified value.
242	Statistical	FISHERINV	`FISHERINV(value)`	Returns the inverse Fisher transformation of a specified value.
243	Statistical	FORECAST	`FORECAST(x, data_y, data_x)`	Calculates the expected y-value for a specified x based on a linear regression of a dataset.
244	Statistical	GEOMEAN	`GEOMEAN(value1, value2)`	Calculates the geometric mean of a dataset.
245	Statistical	HARMEAN	`HARMEAN(value1, value2)`	Calculates the harmonic mean of a dataset.
246	Statistical	HYPGEOMDIST	`HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)`	Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.
247	Statistical	INTERCEPT	`INTERCEPT(data_y, data_x)`	Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).
248	Statistical	KURT	`KURT(value1, value2)`	Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.
249	Statistical	LARGE	`LARGE(data, n)`	Returns the nth largest element from a data set, where n is user-defined.
250	Statistical	LOGINV	`LOGINV(x, mean, standard_deviation)`	Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.
251	Statistical	LOGNORMDIST	`LOGNORMDIST(x, mean, standard_deviation)`	Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.
252	Statistical	AVEDEV	`AVEDEV(value1, value2)`	Calculates the average of the magnitudes of deviations of data from a dataset's mean.
253	Statistical	MAX	`MAX(value1, value2)`	Returns the maximum value in a numeric dataset.
254	Statistical	MAXA	`MAXA(value1, value2)`	Returns the maximum numeric value in a dataset.
255	Statistical	MEDIAN	`MEDIAN(value1, value2)`	Returns the median value in a numeric dataset.
256	Statistical	MIN	`MIN(value1, value2)`	Returns the minimum value in a numeric dataset.
257	Statistical	MINA	`MINA(value1, value2)`	Returns the minimum numeric value in a dataset.
258	Statistical	MODE	`MODE(value1, value2)`	Returns the most commonly occurring value in a dataset.
259	Statistical	AVERAGE	`AVERAGE(value1, value2)`	Returns the numerical average value in a dataset, ignoring text.
260	Statistical	AVERAGEA	`AVERAGEA(value1, value2)`	Returns the numerical average value in a dataset.
261	Statistical	AVERAGEIF	`AVERAGEIF(criteria_range, criterion, [average_range])`	Returns the average of a range depending on criteria.
262	Statistical	AVERAGEIFS	`AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the average of a range depending on multiple criteria.
263	Statistical	BINOMDIST	`BINOMDIST(num_successes, num_trials, prob_success, cumulative)`	Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.
264	Statistical	CONFIDENCE	`CONFIDENCE(alpha, standard_deviation, pop_size)`	Calculates the width of half the confidence interval for a normal distribution.
265	Statistical	CORREL	`CORREL(data_y, data_x)`	Calculates r, the Pearson product-moment correlation coefficient of a dataset.
266	Statistical	COUNT	`COUNT(value1, value2)`	Returns the a count of the number of numeric values in a dataset.
267	Statistical	COUNTA	`COUNTA(value1, value2)`	Returns the a count of the number of values in a dataset.
268	Statistical	COVAR	`COVAR(data_y, data_x)`	Calculates the covariance of a dataset.
269	Statistical	DEVSQ	`DEVSQ(value1, value2)`	Calculates the sum of squares of deviations based on a sample.
270	Statistical	CRITBINOM	`CRITBINOM(num_trials, prob_success, target_prob)`	Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
271	Text	VALUE	`VALUE(text)`	Converts a string in any of the date, time or number formats that Excellentable understands into a number.
272	Text	TRIM	`TRIM(text)`	Removes leading and trailing spaces in a specified string.
273	Text	TEXT	`TEXT(number, format)`	Converts a number into text according to a specified format.
274	Text	T	`T(value)`	Returns string arguments as text.
275	Text	SUBSTITUTE	`SUBSTITUTE(text_to_search, search_for, replace_with, occurrence_number)`	Replaces existing text with new text in a string.
276	Text	SEARCH	`SEARCH(search_for, text_to_search, starting_at)`	Returns the position at which a string is first found within text.
277	Text	ROMAN	`ROMAN(number, rule_relaxation)`	Formats a number in Roman numerals.
278	Text	RIGHT	`RIGHT(string, number_of_characters)`	Returns a substring from the end of a specified string.
279	Text	REPT	`REPT(text_to_repeat, number_of_repetitions)`	Returns specified text repeated a number of times.
280	Text	REPLACE	`REPLACE(text, position, length, new_text)`	Replaces part of a text string with a different text string.
281	Text	UPPER	`UPPER(text)`	Converts a specified string to uppercase.
282	Text	MID	`MID(string, starting_at, extract_length)`	Returns a segment of a string.
283	Text	LOWER	`LOWER(text)`	Converts a specified string to lowercase.
284	Text	LEN	`LEN(text)`	Returns the length of a string.
285	Text	LEFT	`LEFT(string, number_of_characters)`	Returns a substring from the beginning of a specified string.
286	Text	FIXED	`FIXED(number, number_of_places, suppress_separator)`	Formats a number with a fixed number of decimal places.
287	Text	FIND	`FIND(search_for, text_to_search, starting_at)`	Returns the position at which a string is first found within text.
288	Text	EXACT	`EXACT(string1, string2)`	Tests whether two strings are identical.
289	Text	DOLLAR	`DOLLAR(number, number_of_places)`	Formats a number into the locale-specific currency format.
290	Text	CONCATENATE	`CONCATENATE(string1, string2)`	Appends strings to one another.
291	Text	CLEAN	`CLEAN(text)`	Returns the text with the non-printable ASCII characters removed.
292	Text	CHAR	`CHAR(table_number)`	Convert a number into a character according to the current Unicode table.
293	Text	CODE	`CODE(string)`	Returns the numeric Unicode map value of the first character in the string provided.
294		AMORDEGRC	AMORDEGRC(cost,datepurchased,firstperiod,salvage,period,drate,basis)	Returns the depreciation for each accounting period.
295		AMORLINC	AMORLINC(cost,datepurchased,firstperiod,salvage,period,drate,basis)	Calculates the depreciation for an accounting period, taking into account prorated depreciation.
296		AREASPARKLINE	AREASPARKLINE(points, min, max, line1, line2, colorPositive, colorNegative)
297		BESSELI	BESSELI(value,order)	Calculates the modified Bessel function of the first kind evaluated for purely imaginary arguments..
298		BESSELJ	BESSELJ(value,order)	Returns the Bessel function.
299		BESSELK	BESSELK(value,order)	Calculates the modified Bessel function of the second kind evaluated for purely imaginary arguments.
300		BESSELY	BESSELY(value,order)	Returns the Bessel function, which is also called the Weber function or the Neumann function.
301		BETA.DIST	BETA.DIST(x,alpha,beta,cumulative,lower,upper)	Returns the beta distribution.
302		BETA.INV	BETAINV(prob,alpha,beta,lower,upper)	Returns the inverse of the beta cumulative probability density function (BETA.DIST).
303		BETADIST	BETADIST(x,alpha,beta,lower,upper)	Returns the cumulative beta probability density function.
304		BETAINV	BETAINV(prob,alpha,beta,lower,upper)	Returns the inverse of the cumulative beta probability density function for a specified beta distribution.
305		BINOM.DIST	BINOM.DIST(number_s,trials,probability_s,cumulative)	Returns the individual term binomial distribution probability.
306		BINOM.INV	BINOM.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		BOXPLOTSPARKLINE	BOXPLOTSPARKLINE(points, boxPlotClass, showAverage, scaleStart, scaleEnd, acceptableStart, acceptableEnd, colorScheme, style, vertical)
308		BULLETSPARKLINE	BULLETSPARKLINE(measure, target, maxi, good?, bad?, forecast?, tickunit?, colorScheme?, vertical?)
309		CASCADESPARKLINE	CASCADESPARKLINE(pointsRange, pointIndex, labelsRange, minimum, maximum, colorPositive, colorNegative, vertical)
310		CEILING.PRECISE	CEILING.PRECISE(number, [significance])	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
311		CHIDIST	CHIDIST(value,deg)	Returns the right-tailed probability of the chi-squared distribution.
312		CHIINV	CHIINV(probability,deg_freedom)	Returns the inverse of the right-tailed probability of the chi-squared distribution.
313		CHISQ.DIST	CHISQ.DIST(value,deg_freedom,cumulative)	Returns the chi-squared distribution.
314		CHISQ.DIST.RT	CHISQ.DIST.RT(value,deg_freedom)	Returns the right-tailed probability of the chi-squared distribution.
315		CHISQ.INV	CHISQ.INV(probability,deg_freedom)	Returns the inverse of the left-tailed probability of the chi-squared distribution.
316		CHISQ.INV.RT	CHISQ.INV.RT(probability,deg_freedom)	Returns the inverse of the right-tailed probability of the chi-squared distribution.
317		CHISQ.TEST	CHISQ.TEST(actual_range,expected_range)	Returns the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.
318		CHITEST	CHITEST(actual_range,expected_range)	Calculates the test for independence from the chi-squared distribution.
319		COLUMNSPARKLINE	COLUMNSPARKLINE(data, dataOrientation, dateAxisData, dateAxisOrientation, setting)
320		COMPLEX	COMPLEX(realcoeff,imagcoeff,suffix)	Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
321		CONFIDENCE.NORM	CONFIDENCE.NORM(alpha,standard_dev,size)	Returns the confidence interval for a population mean, using a normal distribution.
322		CONFIDENCE.T	CONFIDENCE.T(alpha,standard_dev,size)	Returns the confidence interval for a population mean, using a Student's t distribution.
323		COVARIANCE.P	COVARIANCE.P(array1,array2)	Returns population covariance, the average of the products of deviations for each data point pair in two data sets.
324		COVARIANCE.S	COVARIANCE.S(array1,array2)	Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
325		ERF	ERF(limit,upperlimit)	Returns the error function integrated between lower_limit and upper_limit.
326		ERF.PRECISE	ERF.PRECISE(limit)	Returns the error function.
327		EURO	EURO(code)	This function returns the equivalent of one Euro based on the ISO currency code.
328		EUROCONVERT	EUROCONVERT(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.DIST	EXPON.DIST(value,lambda,cumulative)	Returns the exponential distribution.
330		F.INV	F.INV(probability,deg_freedom1,deg_freedom2)	Returns the inverse of the F probability distribution.
331		F.INV.RT	F.INV.RT(probability,deg_freedom1,deg_freedom2)	Returns the inverse of the (right-tailed) F probability distribution.
332		F.TEST	F.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		FINV	FINV(probability,deg_freedom1,deg_freedom2)	Returns the inverse of the (right-tailed) F probability distribution.
334		FLOOR.PRECISE	FLOOR.PRECISE(number, [significance])	Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance.
335		FTEST	FTEST(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.DIST	GAMMA.DIST(value,alpha,beta,cumulative)	Returns the gamma distribution.
337		GAMMA.INV	GAMMA.INV(probability,alpha,beta)	Returns the inverse of the gamma cumulative distribution.
338		GAMMADIST	GAMMADIST(value,alpha,beta,cumulative)	Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution.
339		GAMMAINV	GAMMAINV(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		GESTEP	GESTEP(number, [step])	Returns 1 if number ≥ step; returns 0 (zero) otherwise.
342		HBARSPARKLINE	HBARSPARKLINE(value, colorScheme)
343		HYPGEOM.DIST	HYPGEOM.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		IMABS	IMABS(inumber)	Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
345		IMAGINARY	IMAGINARY(inumber)	Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
346		IMARGUMENT	IMARGUMENT(inumber)	Returns the argument (theta), an angle expressed in radians.
347		IMCONJUGATE	IMCONJUGATE(inumber)	Returns the complex conjugate of a complex number in x + yi or x + yj text format.
348		IMCOS	IMCOS(inumber)	Returns the cosine of a complex number in x + yi or x + yj text format.
349		IMDIV	IMDIV(inumber1, inumber2)	Returns the quotient of two complex numbers in x + yi or x + yj text format.
350		IMEXP	IMEXP(inumber)	Returns the exponential of a complex number in x + yi or x + yj text format.
351		IMLN	IMLN(inumber)	Returns the natural logarithm of a complex number in x + yi or x + yj text format.
352		IMSQRT	IMSQRT(inumber)	Returns the square root of a complex number in x + yi or x + yj text format.
353		IMSUB	IMSUB(inumber1, inumber2)	Returns the difference of two complex numbers in x + yi or x + yj text format.
354		IMLOG2	IMLOG2(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		IMPOWER	IMPOWER(inumber, number)	Returns a complex number in x + yi or x + yj text format raised to a power.
357		IMPRODUCT	IMPRODUCT(inumber1, [inumber2], ...)	Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.
358		IMREAL	IMREAL(inumber)	Returns the real coefficient of a complex number in x + yi or x + yj text format.
359		IMSIN	IMSIN(inumber)	Returns the sine of a complex number in x + yi or x + yj text format.
360		IMSUM	IMSUM(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		ISPMT	ISPMT(rate, per, nper, pv)	Calculates the interest paid during a specific period of an investment.
363		LINESPARKLINE	LINESPARKLINE(data, dataOrientation, dateAxisData, dateAxisOrientation, setting)
364		LOGNORM.DIST	LOGNORM.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.INV	LOGNORM.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.MULT	MODE.MULT((number1,[number2],...)	Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
367		MODE.SNGL	MODE.SNGL(number1,[number2],...)	Returns the most frequently occurring, or repetitive, value in an array or range of data.
368		NEGBINOM.DIST	NEGBINOM.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.DIST	NORM.DIST(value,mean,standard_dev,cumulative)	Returns the normal distribution for the specified mean and standard deviation.
370		NORM.INV	NORM.INV(probability,mean,standard_dev)	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
371		NORM.S.DIST	NORM.S.DIST(value,cumulative)	Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
372		NORM.S.INV	NORM.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		ODDFPRICE	ODDFPRICE(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		ODDFYIELD	ODDFYIELD(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		ODDLPRICE	ODDLPRICE(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		ODDLYIELD	ODDLYIELD(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		PARETOSPARKLINE	PARETOSPARKLINE(points, pointIndex, colorRange, target, target2, highlightPosition, label, vertical)
378		PERCENTILE.EXC	PERCENTILE.EXC(array,value)	Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
379		PERCENTILE.INC	PERCENTILE.INC(array,value)	Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
380		PIESPARKLINE	PIESPARKLINE(Percentage,color1,color2,.....)
381		POISSON.DIST	POISSON.DIST(value,mean,cumulative)	Returns the Poisson distribution.
382		QUARTILE.EXC	QUARTILE.EXC(array, quart)	Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
383		QUARTILE.INC	QUARTILE.INC(array,quart)	Returns the quartile of a data set, based on percentile values from 0..1, inclusive.
384		SCATTERSPARKLINE	SCATTERSPARKLINE(points1, points2, minX, maxX, minY, maxY, hLine, vLine, xMinZone, xMaxZone, yMinZone, yMaxZone, tags, drawSymbol, drawLines, color1, color2, dash)
385		SPREADSPARKLINE	SPREADSPARKLINE(points, showAverage?, scaleStart?, scaleEnd?, style?, colorScheme?, vertical?)
386		STACKEDSPARKLINE	STACKEDSPARKLINE(points, colorRange?, labelRange?, maximum?, targetRed?, targetGreen?, targetBlue?, tragetYellow?, color?, highlightPosition?, vertical?, textOrientation?, textSize?)
387		STDEV.P	STDEV.P(number1,[number2],...)	Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
388		STDEV.S	STDEV.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.RT	T.DIST.RT(value,deg_freedom)	Returns the right-tailed Student's t-distribution.
392		VAR.P	VAR.P(number1,[number2],...)	Calculates variance based on the entire population (ignores logical values and text in the population).
393		VAR.S	VAR.S(number1,[number2],...)	Estimates variance based on a sample (ignores logical values and text in the sample).
394		VARISPARKLINE	VARISPARKLINE(variance, reference, mini, maxi, mark, tickunit, legend, colorPositive, colorNegative, vertical)
395		VBARSPARKLINE	VBARSPARKLINE(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.DIST	WEIBULL.DIST(value,alpha,beta,cumulative)	Returns the Weibull distribution.
398		WINLOSSSPARKLINE	WINLOSSSPARKLINE(data, dataOrientation, dateAxisData, dateAxisOrientation, setting)
399		YIELDMAT	YIELDMAT(settlement, maturity, issue, rate, pr, [basis])	Returns the annual yield of a security that pays interest at maturity.
400		Z.TEST	Z.TEST(array,x,[sigma])	Returns the one-tailed P-value of a z-test.
401		ERFC.PRECISE	ERFC.PRECISE(x)	Returns the complementary ERF function integrated between x and infinity.
402		T.TEST	T.TEST(array1,array2,tails,type)	Returns the probability associated with a Student's T-Test.
403	Text	PROPER	PROPER(text_to_capitalize)	Capitalizes each word in a specified string.
404	Statistical	EXPONDIST	EXPONDIST(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