# Using Formulas

Nesting formulas are supported!

## List of Formulas Supported by Excellentable:

# | Type | Name | Input Data | Description |
---|---|---|---|---|

1 | Array | `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(array_x, array_y)` | Calculates the sum of the squares of differences of values in two arrays. | |

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

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

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

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

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

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

9 | Array | `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(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(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(data, classes)` | Calculates the frequency distribution of a one-column array into specified classes. | |

13 | Array | `TRANSPOSE(array_or_range)` | Transposes the rows and columns of an array or range of cells. | |

14 | Database | `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(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(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(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(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(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(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(database, field, criteria)` | Returns the maximum value selected from a database table-like array or range using a SQL-like query. | |

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

23 | Database | `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(database, field, criteria)` | Counts numeric values selected from a database table-like array or range using a SQL-like query. | |

25 | Database | `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(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(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(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 | IISO.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