Formula functions

Formulas are calculated by the editor’s own engine, in its worker, as cells change. Dynamic arrays spill as in Excel 365, and LET, LAMBDA and its helpers (MAP, REDUCE, SCAN, BYROW, BYCOL, MAKEARRAY) work, as do names defined with them. On opening, the engine’s results are compared with the values Excel saved, and any that disagree are reported.

The engine calculates 477 of Excel's 518 worksheet functions. A workbook using one of the other 41 keeps Excel's saved result for it until Excel recalculates the file, and a save lists such formulas as outOfDate when their inputs change.

Calculated

Function	Arguments and what it does
`ABS`	`ABS(number)` Returns the absolute value of a number.
`ACCRINT`
`ACCRINTM`
`ACOS`	`ACOS(number)` Returns the arccosine of a number, in radians.
`ACOSH`
`ACOT`
`ACOTH`
`ADDRESS`	`ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])` Returns a cell reference as text, given row and column numbers.
`AGGREGATE`	`AGGREGATE(function_num, options, ref1, [ref2], ...)` Returns an aggregate (sum, average, count…), optionally ignoring hidden rows and errors.
`AND`	`AND(logical1, [logical2], ...)` Returns TRUE if all of its arguments are TRUE.
`ARABIC`
`AREAS`	`AREAS(reference)` Returns the number of areas in a reference.
`ARRAYTOTEXT`	`ARRAYTOTEXT(array, [format])` Returns an array of values as text.
`ASIN`	`ASIN(number)` Returns the arcsine of a number, in radians.
`ASINH`
`ATAN`	`ATAN(number)` Returns the arctangent of a number, in radians.
`ATAN2`	`ATAN2(x_num, y_num)` Returns the arctangent of x and y coordinates, in radians.
`ATANH`
`AVEDEV`	`AVEDEV(number1, [number2], ...)` Returns the average of the absolute deviations of numbers from their mean.
`AVERAGE`	`AVERAGE(number1, [number2], ...)` Returns the average (arithmetic mean) of its arguments.
`AVERAGEA`	`AVERAGEA(value1, [value2], ...)` Returns the average of its arguments, counting text as 0 and TRUE as 1.
`AVERAGEIF`	`AVERAGEIF(range, criteria, [average_range])` Returns the average of the cells that meet a condition.
`AVERAGEIFS`	`AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)` Returns the average of the cells that meet several conditions.
`BASE`
`BESSELI`
`BESSELJ`
`BESSELK`
`BESSELY`
`BETA.DIST`
`BETA.INV`
`BETADIST`
`BETAINV`
`BIN2DEC`	`BIN2DEC(number)` Converts a binary number to decimal.
`BIN2HEX`
`BIN2OCT`
`BINOM.DIST`	`BINOM.DIST(number_s, trials, probability_s, cumulative)` Returns the binomial distribution probability.
`BINOM.DIST.RANGE`
`BINOM.INV`
`BINOMDIST`
`BITAND`
`BITLSHIFT`
`BITOR`
`BITRSHIFT`
`BITXOR`
`BYCOL`	`BYCOL(array, lambda)` Applies a LAMBDA to each column and returns an array of the results.
`BYROW`	`BYROW(array, lambda)` Applies a LAMBDA to each row and returns an array of the results.
`CEILING`	`CEILING(number, significance)` Rounds a number up to the nearest multiple of significance.
`CEILING.MATH`	`CEILING.MATH(number, [significance], [mode])` Rounds a number up to the nearest integer or multiple of significance.
`CEILING.PRECISE`
`CELL`	`CELL(info_type, [reference])` Returns information about the formatting, location or contents of a cell.
`CHAR`	`CHAR(number)` Returns the character with the given code.
`CHIDIST`
`CHIINV`
`CHISQ.DIST`
`CHISQ.DIST.RT`
`CHISQ.INV`
`CHISQ.INV.RT`
`CHISQ.TEST`	`CHISQ.TEST(actual_range, expected_range)` Returns the chi-squared test for independence.
`CHITEST`
`CHOOSE`	`CHOOSE(index_num, value1, [value2], ...)` Chooses a value from a list by its position.
`CHOOSECOLS`	`CHOOSECOLS(array, col_num1, [col_num2], ...)` Returns the given columns of an array.
`CHOOSEROWS`	`CHOOSEROWS(array, row_num1, [row_num2], ...)` Returns the given rows of an array.
`CLEAN`	`CLEAN(text)` Removes all nonprintable characters from text.
`CODE`	`CODE(text)` Returns the code of the first character in text.
`COLUMN`	`COLUMN([reference])` Returns the column number of a reference.
`COLUMNS`	`COLUMNS(array)` Returns the number of columns in an array or reference.
`COMBIN`	`COMBIN(number, number_chosen)` Returns the number of combinations of a number of items.
`COMBINA`
`COMPLEX`
`CONCAT`	`CONCAT(text1, [text2], ...)` Joins text from several ranges or strings.
`CONCATENATE`	`CONCATENATE(text1, [text2], ...)` Joins several text items into one.
`CONFIDENCE`
`CONFIDENCE.NORM`	`CONFIDENCE.NORM(alpha, standard_dev, size)` Returns the confidence interval for a population mean, using a normal distribution.
`CONFIDENCE.T`	`CONFIDENCE.T(alpha, standard_dev, size)` Returns the confidence interval for a population mean, using Student's t-distribution.
`CORREL`	`CORREL(array1, array2)` Returns the correlation coefficient between two data sets.
`COS`	`COS(number)` Returns the cosine of an angle.
`COSH`
`COT`
`COTH`
`COUNT`	`COUNT(value1, [value2], ...)` Counts the cells that contain numbers.
`COUNTA`	`COUNTA(value1, [value2], ...)` Counts the cells that are not empty.
`COUNTBLANK`	`COUNTBLANK(range)` Counts the empty cells in a range.
`COUNTIF`	`COUNTIF(range, criteria)` Counts the cells in a range that meet a condition.
`COUNTIFS`	`COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)` Counts the cells that meet several conditions.
`COUPDAYBS`
`COUPDAYS`
`COUPDAYSNC`
`COUPNCD`
`COUPNUM`
`COUPPCD`
`COVAR`
`COVARIANCE.P`	`COVARIANCE.P(array1, array2)` Returns the population covariance of two data sets.
`COVARIANCE.S`	`COVARIANCE.S(array1, array2)` Returns the sample covariance of two data sets.
`CRITBINOM`
`CSC`
`CSCH`
`CUMIPMT`	`CUMIPMT(rate, nper, pv, start_period, end_period, type)` Returns the cumulative interest paid on a loan between two periods.
`CUMPRINC`	`CUMPRINC(rate, nper, pv, start_period, end_period, type)` Returns the cumulative principal paid on a loan between two periods.
`DATE`	`DATE(year, month, day)` Returns the serial number of a date.
`DATEDIF`	`DATEDIF(start_date, end_date, unit)` Returns the number of days, months or years between two dates.
`DATEVALUE`	`DATEVALUE(date_text)` Converts a date written as text to a serial number.
`DAVERAGE`	`DAVERAGE(database, field, criteria)` Returns the average of database entries that meet conditions.
`DAY`	`DAY(serial_number)` Returns the day of the month, from 1 to 31.
`DAYS`	`DAYS(end_date, start_date)` Returns the number of days between two dates.
`DAYS360`	`DAYS360(start_date, end_date, [method])` Returns the number of days between two dates on a 360-day year.
`DB`	`DB(cost, salvage, life, period, [month])` Returns depreciation for a period by the fixed-declining balance method.
`DCOUNT`	`DCOUNT(database, field, criteria)` Counts the database entries with numbers that meet conditions.
`DCOUNTA`	`DCOUNTA(database, field, criteria)` Counts the non-empty database entries that meet conditions.
`DDB`	`DDB(cost, salvage, life, period, [factor])` Returns depreciation for a period by the double-declining balance method.
`DEC2BIN`	`DEC2BIN(number, [places])` Converts a decimal number to binary.
`DEC2HEX`	`DEC2HEX(number, [places])` Converts a decimal number to hexadecimal.
`DEC2OCT`
`DECIMAL`
`DEGREES`	`DEGREES(angle)` Converts radians to degrees.
`DELTA`
`DEVSQ`	`DEVSQ(number1, [number2], ...)` Returns the sum of squares of deviations from the mean.
`DGET`	`DGET(database, field, criteria)` Returns the single database entry that meets conditions.
`DISC`
`DMAX`	`DMAX(database, field, criteria)` Returns the largest database entry that meets conditions.
`DMIN`	`DMIN(database, field, criteria)` Returns the smallest database entry that meets conditions.
`DOLLARDE`
`DOLLARFR`
`DPRODUCT`
`DROP`	`DROP(array, rows, [columns])` Removes rows or columns from the start or end of an array.
`DSTDEV`
`DSTDEVP`
`DSUM`	`DSUM(database, field, criteria)` Adds the database entries that meet conditions.
`DURATION`
`DVAR`
`DVARP`
`EDATE`	`EDATE(start_date, months)` Returns the date a number of months before or after a date.
`EFFECT`	`EFFECT(nominal_rate, npery)` Returns the effective annual interest rate.
`EOMONTH`	`EOMONTH(start_date, months)` Returns the last day of the month a number of months before or after a date.
`ERF`
`ERF.PRECISE`
`ERFC`
`ERFC.PRECISE`
`ERROR.TYPE`	`ERROR.TYPE(error_val)` Returns a number for an error value.
`EVEN`	`EVEN(number)` Rounds a number up to the nearest even integer.
`EXACT`	`EXACT(text1, text2)` Checks whether two text values are exactly the same.
`EXP`	`EXP(number)` Returns e raised to the power of a number.
`EXPAND`	`EXPAND(array, rows, [columns], [pad_with])` Expands an array to the given size.
`EXPON.DIST`	`EXPON.DIST(x, lambda, cumulative)` Returns the exponential distribution.
`EXPONDIST`
`F.DIST`
`F.DIST.RT`
`F.INV`
`F.INV.RT`
`F.TEST`
`FACT`	`FACT(number)` Returns the factorial of a number.
`FACTDOUBLE`
`FALSE`	`FALSE()` Returns the logical value FALSE.
`FDIST`
`FILTER`	`FILTER(array, include, [if_empty])` Filters a range or array by a condition.
`FIND`	`FIND(find_text, within_text, [start_num])` Finds one text value within another (case-sensitive).
`FINDB`
`FINV`
`FISHER`
`FISHERINV`
`FIXED`	`FIXED(number, [decimals], [no_commas])` Formats a number as text with a fixed number of decimals.
`FLOOR`	`FLOOR(number, significance)` Rounds a number down to the nearest multiple of significance.
`FLOOR.MATH`	`FLOOR.MATH(number, [significance], [mode])` Rounds a number down to the nearest integer or multiple of significance.
`FLOOR.PRECISE`
`FORECAST`	`FORECAST(x, known_y's, known_x's)` Predicts a value along a linear trend.
`FORECAST.LINEAR`	`FORECAST.LINEAR(x, known_y's, known_x's)` Predicts a value along a linear trend.
`FORMULATEXT`	`FORMULATEXT(reference)` Returns the formula at a reference as text.
`FREQUENCY`	`FREQUENCY(data_array, bins_array)` Returns how often values occur within ranges, as a vertical array.
`FTEST`
`FV`	`FV(rate, nper, pmt, [pv], [type])` Returns the future value of an investment.
`FVSCHEDULE`
`GAMMA`
`GAMMA.DIST`
`GAMMA.INV`
`GAMMADIST`
`GAMMAINV`
`GAMMALN`
`GAMMALN.PRECISE`
`GAUSS`
`GCD`
`GEOMEAN`	`GEOMEAN(number1, [number2], ...)` Returns the geometric mean.
`GESTEP`
`GROWTH`	`GROWTH(known_y's, [known_x's], [new_x's], [const])` Returns values along an exponential trend.
`HARMEAN`	`HARMEAN(number1, [number2], ...)` Returns the harmonic mean.
`HEX2BIN`
`HEX2DEC`	`HEX2DEC(number)` Converts a hexadecimal number to decimal.
`HEX2OCT`
`HLOOKUP`	`HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])` Looks in the top row of a table and returns the value from a row you choose.
`HOUR`	`HOUR(serial_number)` Returns the hour of a time, from 0 to 23.
`HSTACK`	`HSTACK(array1, [array2], ...)` Joins arrays side by side into one array.
`HYPERLINK`	`HYPERLINK(link_location, [friendly_name])` Creates a link to a document or a place in the workbook.
`HYPGEOM.DIST`
`HYPGEOMDIST`
`IF`	`IF(logical_test, [value_if_true], [value_if_false])` Returns one value if a condition is TRUE and another if it is FALSE.
`IFERROR`	`IFERROR(value, value_if_error)` Returns a value of your choice if a formula gives an error, and its result otherwise.
`IFNA`	`IFNA(value, value_if_na)` Returns a value of your choice if a formula gives #N/A, and its result otherwise.
`IFS`	`IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)` Returns the value for the first condition that is TRUE.
`IMABS`
`IMAGINARY`
`IMARGUMENT`
`IMCONJUGATE`
`IMCOS`
`IMCOSH`
`IMCOT`
`IMCSC`
`IMCSCH`
`IMDIV`
`IMEXP`
`IMLN`
`IMLOG10`
`IMLOG2`
`IMPOWER`
`IMPRODUCT`
`IMREAL`
`IMSEC`
`IMSECH`
`IMSIN`
`IMSINH`
`IMSQRT`
`IMSUB`
`IMSUM`
`IMTAN`
`INDEX`	`INDEX(array, row_num, [column_num])` Returns the value at a row and column of a range or array.
`INDIRECT`	`INDIRECT(ref_text, [a1])` Returns the reference given by text.
`INT`	`INT(number)` Rounds a number down to the nearest integer.
`INTERCEPT`	`INTERCEPT(known_y's, known_x's)` Returns where a linear regression line crosses the y-axis.
`INTRATE`
`IPMT`	`IPMT(rate, per, nper, pv, [fv], [type])` Returns the interest paid on an investment in a period.
`IRR`	`IRR(values, [guess])` Returns the internal rate of return for a series of cash flows.
`ISBLANK`	`ISBLANK(value)` Returns TRUE if the value is empty.
`ISERR`	`ISERR(value)` Returns TRUE if the value is any error except #N/A.
`ISERROR`	`ISERROR(value)` Returns TRUE if the value is any error.
`ISEVEN`	`ISEVEN(number)` Returns TRUE if the number is even.
`ISFORMULA`	`ISFORMULA(reference)` Returns TRUE if the cell holds a formula.
`ISLOGICAL`	`ISLOGICAL(value)` Returns TRUE if the value is TRUE or FALSE.
`ISNA`	`ISNA(value)` Returns TRUE if the value is #N/A.
`ISNONTEXT`	`ISNONTEXT(value)` Returns TRUE if the value is not text.
`ISNUMBER`	`ISNUMBER(value)` Returns TRUE if the value is a number.
`ISO.CEILING`
`ISODD`	`ISODD(number)` Returns TRUE if the number is odd.
`ISOWEEKNUM`	`ISOWEEKNUM(date)` Returns the ISO week number of the year for a date.
`ISPMT`
`ISREF`	`ISREF(value)` Returns TRUE if the value is a reference.
`ISTEXT`	`ISTEXT(value)` Returns TRUE if the value is text.
`KURT`	`KURT(number1, [number2], ...)` Returns the kurtosis of a data set.
`LAMBDA`	`LAMBDA([parameter_or_calculation], ...)` Creates a function from parameters and a calculation.
`LARGE`	`LARGE(array, k)` Returns the k-th largest value in a data set.
`LCM`	`LCM(number1, [number2], ...)` Returns the least common multiple.
`LEFT`	`LEFT(text, [num_chars])` Returns the first characters of text.
`LEFTB`
`LEN`	`LEN(text)` Returns the number of characters in text.
`LENB`
`LET`	`LET(name1, name_value1, calculation_or_name2, [name_value2, calculation_or_name3], ...)` Names the results of calculations for use within a formula.
`LINEST`	`LINEST(known_y's, [known_x's], [const], [stats])` Returns the statistics of a linear trend.
`LN`	`LN(number)` Returns the natural logarithm of a number.
`LOG`	`LOG(number, [base])` Returns the logarithm of a number to a base.
`LOG10`	`LOG10(number)` Returns the base-10 logarithm of a number.
`LOGEST`
`LOGINV`
`LOGNORM.DIST`
`LOGNORM.INV`
`LOGNORMDIST`
`LOOKUP`	`LOOKUP(lookup_value, lookup_vector, [result_vector])` Looks up a value in a row or column and returns the value in the same place of another.
`LOWER`	`LOWER(text)` Converts text to lowercase.
`MAKEARRAY`	`MAKEARRAY(rows, cols, lambda)` Returns an array of a given size, calculated by a LAMBDA.
`MAP`	`MAP(array1, lambda_or_array2, ...)` Applies a LAMBDA to each value of arrays and returns the results.
`MATCH`	`MATCH(lookup_value, lookup_array, [match_type])` Returns the position of a value in a range.
`MAX`	`MAX(number1, [number2], ...)` Returns the largest value.
`MAXA`	`MAXA(value1, [value2], ...)` Returns the largest value, counting text as 0 and TRUE as 1.
`MAXIFS`	`MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)` Returns the largest value among cells that meet conditions.
`MDETERM`	`MDETERM(array)` Returns the matrix determinant of an array.
`MDURATION`
`MEDIAN`	`MEDIAN(number1, [number2], ...)` Returns the median of the numbers.
`MID`	`MID(text, start_num, num_chars)` Returns characters from the middle of text.
`MIDB`
`MIN`	`MIN(number1, [number2], ...)` Returns the smallest value.
`MINA`	`MINA(value1, [value2], ...)` Returns the smallest value, counting text as 0 and TRUE as 1.
`MINIFS`	`MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)` Returns the smallest value among cells that meet conditions.
`MINUTE`	`MINUTE(serial_number)` Returns the minute of a time, from 0 to 59.
`MINVERSE`	`MINVERSE(array)` Returns the inverse matrix of an array.
`MIRR`	`MIRR(values, finance_rate, reinvest_rate)` Returns the modified internal rate of return for a series of cash flows.
`MMULT`	`MMULT(array1, array2)` Returns the matrix product of two arrays.
`MOD`	`MOD(number, divisor)` Returns the remainder after division.
`MODE`	`MODE(number1, [number2], ...)` Returns the most common value in a data set.
`MODE.MULT`
`MODE.SNGL`	`MODE.SNGL(number1, [number2], ...)` Returns the most common value in a data set.
`MONTH`	`MONTH(serial_number)` Returns the month of a date, from 1 to 12.
`MROUND`	`MROUND(number, multiple)` Rounds a number to the nearest multiple.
`MULTINOMIAL`
`MUNIT`
`N`	`N(value)` Converts a value to a number.
`NA`	`NA()` Returns the error value #N/A.
`NEGBINOM.DIST`
`NEGBINOMDIST`
`NETWORKDAYS`	`NETWORKDAYS(start_date, end_date, [holidays])` Returns the number of working days between two dates.
`NETWORKDAYS.INTL`	`NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])` Returns the number of working days between two dates, with weekends of your choice.
`NOMINAL`	`NOMINAL(effect_rate, npery)` Returns the nominal annual interest rate.
`NORM.DIST`	`NORM.DIST(x, mean, standard_dev, cumulative)` Returns the normal distribution.
`NORM.INV`	`NORM.INV(probability, mean, standard_dev)` Returns the inverse of the normal cumulative distribution.
`NORM.S.DIST`	`NORM.S.DIST(z, cumulative)` Returns the standard normal distribution.
`NORM.S.INV`	`NORM.S.INV(probability)` Returns the inverse of the standard normal cumulative distribution.
`NORMDIST`
`NORMINV`
`NORMSDIST`
`NORMSINV`
`NOT`	`NOT(logical)` Reverses a logical value.
`NOW`	`NOW()` Returns the current date and time.
`NPER`	`NPER(rate, pmt, pv, [fv], [type])` Returns the number of periods for an investment.
`NPV`	`NPV(rate, value1, [value2], ...)` Returns the net present value of an investment from periodic cash flows and a discount rate.
`NUMBERVALUE`	`NUMBERVALUE(text, [decimal_separator], [group_separator])` Converts text to a number, whatever the locale.
`OCT2BIN`
`OCT2DEC`
`OCT2HEX`
`ODD`	`ODD(number)` Rounds a number up to the nearest odd integer.
`OFFSET`	`OFFSET(reference, rows, cols, [height], [width])` Returns a reference a number of rows and columns from a reference.
`OR`	`OR(logical1, [logical2], ...)` Returns TRUE if any argument is TRUE.
`PDURATION`
`PEARSON`	`PEARSON(array1, array2)` Returns the Pearson correlation coefficient.
`PERCENTILE`	`PERCENTILE(array, k)` Returns the k-th percentile of values in a range.
`PERCENTILE.EXC`	`PERCENTILE.EXC(array, k)` Returns the k-th percentile, where k is between 0 and 1 exclusive.
`PERCENTILE.INC`	`PERCENTILE.INC(array, k)` Returns the k-th percentile, where k is between 0 and 1 inclusive.
`PERCENTOF`	`PERCENTOF(data_subset, data_all)` Returns the share a subset makes of a total.
`PERCENTRANK`	`PERCENTRANK(array, x, [significance])` Returns the rank of a value in a data set as a percentage.
`PERCENTRANK.EXC`
`PERCENTRANK.INC`	`PERCENTRANK.INC(array, x, [significance])` Returns the rank of a value in a data set as a percentage (0 to 1 inclusive).
`PERMUT`	`PERMUT(number, number_chosen)` Returns the number of permutations of a number of items.
`PERMUTATIONA`
`PHI`
`PI`	`PI()` Returns the value of pi.
`PMT`	`PMT(rate, nper, pv, [fv], [type])` Returns the periodic payment for a loan.
`POISSON`
`POISSON.DIST`	`POISSON.DIST(x, mean, cumulative)` Returns the Poisson distribution.
`POWER`	`POWER(number, power)` Returns a number raised to a power.
`PPMT`	`PPMT(rate, per, nper, pv, [fv], [type])` Returns the payment on the principal of an investment in a period.
`PRICE`
`PRICEDISC`
`PRICEMAT`
`PROB`
`PRODUCT`	`PRODUCT(number1, [number2], ...)` Multiplies its arguments.
`PROPER`	`PROPER(text)` Capitalises the first letter of each word.
`PV`	`PV(rate, nper, pmt, [fv], [type])` Returns the present value of an investment.
`QUARTILE`	`QUARTILE(array, quart)` Returns the quartile of a data set.
`QUARTILE.EXC`	`QUARTILE.EXC(array, quart)` Returns the quartile of a data set, from percentiles 0 to 1 exclusive.
`QUARTILE.INC`	`QUARTILE.INC(array, quart)` Returns the quartile of a data set, from percentiles 0 to 1 inclusive.
`QUOTIENT`	`QUOTIENT(numerator, denominator)` Returns the integer part of a division.
`RADIANS`	`RADIANS(angle)` Converts degrees to radians.
`RAND`	`RAND()` Returns a random number between 0 and 1.
`RANDARRAY`	`RANDARRAY([rows], [columns], [min], [max], [whole_number])` Returns an array of random numbers.
`RANDBETWEEN`	`RANDBETWEEN(bottom, top)` Returns a random integer between two numbers.
`RANK`	`RANK(number, ref, [order])` Returns the rank of a number in a list.
`RANK.AVG`	`RANK.AVG(number, ref, [order])` Returns the rank of a number in a list; ties get their average rank.
`RANK.EQ`	`RANK.EQ(number, ref, [order])` Returns the rank of a number in a list; ties get the top rank.
`RATE`	`RATE(nper, pmt, pv, [fv], [type], [guess])` Returns the interest rate per period of an annuity.
`RECEIVED`
`REDUCE`	`REDUCE([initial_value], array, lambda)` Reduces an array to one value by applying a LAMBDA to each value.
`REPLACE`	`REPLACE(old_text, start_num, num_chars, new_text)` Replaces characters within text.
`REPLACEB`
`REPT`	`REPT(text, number_times)` Repeats text a number of times.
`RIGHT`	`RIGHT(text, [num_chars])` Returns the last characters of text.
`RIGHTB`
`ROMAN`
`ROUND`	`ROUND(number, num_digits)` Rounds a number to a number of digits.
`ROUNDDOWN`	`ROUNDDOWN(number, num_digits)` Rounds a number down, towards zero.
`ROUNDUP`	`ROUNDUP(number, num_digits)` Rounds a number up, away from zero.
`ROW`	`ROW([reference])` Returns the row number of a reference.
`ROWS`	`ROWS(array)` Returns the number of rows in an array or reference.
`RRI`
`RSQ`	`RSQ(known_y's, known_x's)` Returns the square of the Pearson correlation coefficient.
`SCAN`	`SCAN([initial_value], array, lambda)` Applies a LAMBDA to each value and returns each intermediate result.
`SEARCH`	`SEARCH(find_text, within_text, [start_num])` Finds one text value within another (not case-sensitive).
`SEARCHB`
`SEC`
`SECH`
`SECOND`	`SECOND(serial_number)` Returns the second of a time, from 0 to 59.
`SEQUENCE`	`SEQUENCE(rows, [columns], [start], [step])` Returns a list of sequential numbers.
`SERIESSUM`
`SHEET`	`SHEET([value])` Returns the sheet number of a sheet.
`SHEETS`	`SHEETS([reference])` Returns the number of sheets in a reference.
`SIGN`	`SIGN(number)` Returns the sign of a number: 1, 0 or -1.
`SIN`	`SIN(number)` Returns the sine of an angle.
`SINH`
`SKEW`	`SKEW(number1, [number2], ...)` Returns the skewness of a distribution.
`SKEW.P`
`SLN`	`SLN(cost, salvage, life)` Returns straight-line depreciation for one period.
`SLOPE`	`SLOPE(known_y's, known_x's)` Returns the slope of a linear regression line.
`SMALL`	`SMALL(array, k)` Returns the k-th smallest value in a data set.
`SORT`	`SORT(array, [sort_index], [sort_order], [by_col])` Sorts the contents of a range or array.
`SORTBY`	`SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2], ...)` Sorts a range or array by the values in another.
`SQRT`	`SQRT(number)` Returns a positive square root.
`SQRTPI`
`STANDARDIZE`	`STANDARDIZE(x, mean, standard_dev)` Returns a normalised value.
`STDEV`	`STDEV(number1, [number2], ...)` Estimates standard deviation from a sample.
`STDEV.P`	`STDEV.P(number1, [number2], ...)` Returns the standard deviation of a whole population.
`STDEV.S`	`STDEV.S(number1, [number2], ...)` Estimates standard deviation from a sample.
`STDEVA`
`STDEVP`
`STDEVPA`
`STEYX`	`STEYX(known_y's, known_x's)` Returns the standard error of the predicted y-values of a regression.
`SUBSTITUTE`	`SUBSTITUTE(text, old_text, new_text, [instance_num])` Replaces old text with new text.
`SUBTOTAL`	`SUBTOTAL(function_num, ref1, [ref2], ...)` Returns a subtotal in a list, ignoring other subtotals.
`SUM`	`SUM(number1, [number2], ...)` Adds its arguments.
`SUMIF`	`SUMIF(range, criteria, [sum_range])` Adds the cells that meet a condition.
`SUMIFS`	`SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)` Adds the cells that meet several conditions.
`SUMPRODUCT`	`SUMPRODUCT(array1, [array2], ...)` Returns the sum of the products of corresponding values.
`SUMSQ`	`SUMSQ(number1, [number2], ...)` Returns the sum of the squares of its arguments.
`SUMX2MY2`
`SUMX2PY2`
`SUMXMY2`
`SWITCH`	`SWITCH(expression, value1, result1, [default_or_value2, result2], ...)` Compares a value against a list and returns the result for the first match.
`SYD`	`SYD(cost, salvage, life, per)` Returns sum-of-years' digits depreciation for a period.
`T`	`T(value)` Returns the value if it is text, and empty text otherwise.
`T.DIST`	`T.DIST(x, deg_freedom, cumulative)` Returns Student's left-tailed t-distribution.
`T.DIST.2T`
`T.DIST.RT`
`T.INV`	`T.INV(probability, deg_freedom)` Returns the left-tailed inverse of Student's t-distribution.
`T.INV.2T`	`T.INV.2T(probability, deg_freedom)` Returns the two-tailed inverse of Student's t-distribution.
`T.TEST`	`T.TEST(array1, array2, tails, type)` Returns the probability of Student's t-test.
`TAKE`	`TAKE(array, rows, [columns])` Returns rows or columns from the start or end of an array.
`TAN`	`TAN(number)` Returns the tangent of an angle.
`TANH`
`TBILLEQ`
`TBILLPRICE`
`TBILLYIELD`
`TDIST`
`TEXT`	`TEXT(value, format_text)` Formats a number and converts it to text.
`TEXTAFTER`	`TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])` Returns the text after a delimiter.
`TEXTBEFORE`	`TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])` Returns the text before a delimiter.
`TEXTJOIN`	`TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)` Joins text from several ranges or strings, with a delimiter between.
`TEXTSPLIT`	`TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])` Splits text into rows and columns at delimiters.
`TIME`	`TIME(hour, minute, second)` Returns the serial number of a time.
`TIMEVALUE`	`TIMEVALUE(time_text)` Converts a time written as text to a serial number.
`TINV`
`TOCOL`	`TOCOL(array, [ignore], [scan_by_column])` Returns an array as one column.
`TODAY`	`TODAY()` Returns today's date.
`TOROW`	`TOROW(array, [ignore], [scan_by_column])` Returns an array as one row.
`TRANSPOSE`	`TRANSPOSE(array)` Swaps the rows and columns of an array.
`TREND`	`TREND(known_y's, [known_x's], [new_x's], [const])` Returns values along a linear trend.
`TRIM`	`TRIM(text)` Removes spaces from text, except single spaces between words.
`TRIMMEAN`	`TRIMMEAN(array, percent)` Returns the mean of the interior of a data set.
`TRUE`	`TRUE()` Returns the logical value TRUE.
`TRUNC`	`TRUNC(number, [num_digits])` Truncates a number to an integer or a number of digits.
`TTEST`
`TYPE`	`TYPE(value)` Returns a number for the type of a value.
`UNICHAR`	`UNICHAR(number)` Returns the Unicode character with the given code.
`UNICODE`	`UNICODE(text)` Returns the Unicode code of the first character of text.
`UNIQUE`	`UNIQUE(array, [by_col], [exactly_once])` Returns the unique values of a range or array.
`UPPER`	`UPPER(text)` Converts text to uppercase.
`VALUE`	`VALUE(text)` Converts text to a number.
`VALUETOTEXT`	`VALUETOTEXT(value, [format])` Returns a value as text.
`VAR`	`VAR(number1, [number2], ...)` Estimates variance from a sample.
`VAR.P`	`VAR.P(number1, [number2], ...)` Returns the variance of a whole population.
`VAR.S`	`VAR.S(number1, [number2], ...)` Estimates variance from a sample.
`VARA`
`VARP`
`VARPA`
`VDB`
`VLOOKUP`	`VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])` Looks in the first column of a table and returns the value from a column you choose.
`VSTACK`	`VSTACK(array1, [array2], ...)` Stacks arrays one above another into one array.
`WEEKDAY`	`WEEKDAY(serial_number, [return_type])` Returns the day of the week of a date, as a number.
`WEEKNUM`	`WEEKNUM(serial_number, [return_type])` Returns the week number of the year for a date.
`WEIBULL`
`WEIBULL.DIST`
`WORKDAY`	`WORKDAY(start_date, days, [holidays])` Returns the date a number of working days before or after a date.
`WORKDAY.INTL`	`WORKDAY.INTL(start_date, days, [weekend], [holidays])` Returns the date a number of working days away, with weekends of your choice.
`WRAPCOLS`	`WRAPCOLS(vector, wrap_count, [pad_with])` Wraps a row or column of values into columns.
`WRAPROWS`	`WRAPROWS(vector, wrap_count, [pad_with])` Wraps a row or column of values into rows.
`XIRR`	`XIRR(values, dates, [guess])` Returns the internal rate of return for cash flows that are not periodic.
`XLOOKUP`	`XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])` Searches a range for a match and returns the matching item from another range.
`XMATCH`	`XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])` Returns the position of an item in an array.
`XNPV`	`XNPV(rate, values, dates)` Returns the net present value of cash flows that are not periodic.
`XOR`	`XOR(logical1, [logical2], ...)` Returns TRUE if an odd number of its arguments are TRUE.
`YEAR`	`YEAR(serial_number)` Returns the year of a date.
`YEARFRAC`	`YEARFRAC(start_date, end_date, [basis])` Returns the fraction of a year between two dates.
`YIELD`
`YIELDDISC`
`YIELDMAT`
`Z.TEST`
`ZTEST`

Kept from Excel

AMORDEGRC, AMORLINC, ASC, BAHTTEXT, CONVERT, CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, DBCS, DETECTLANGUAGE, DOLLAR, ENCODEURL, FIELDVALUE, FILTERXML, FORECAST.ETS, FORECAST.ETS.CONFINT, FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, GETPIVOTDATA, GROUPBY, IMAGE, INFO, ISOMITTED, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PHONETIC, PIVOTBY, REGEXEXTRACT, REGEXREPLACE, REGEXTEST, RTD, STOCKHISTORY, TRANSLATE, TRIMRANGE, WEBSERVICE.