Function reference

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

AREAS(reference)

CHOOSE(index_num, value1, [value2], ...)

Use it for: Turn a month number into a quarter, or a weekday number into a day name.

CHOOSECOLS(array, col_num1, [col_num2], ...)

CHOOSEROWS(array, row_num1, [row_num2], ...)

COLUMN([reference])

COLUMNS(array)

DROP(array, rows, [columns])

EXPAND(array, rows, [columns], [pad_with])

FILTER(array, include, [if_empty])

Use it for: Show a list of sales over 1,000 that updates itself when the data changes.

FORMULATEXT(reference)

Use it for: Display a formula next to its result for workbook documentation or teaching material.

GETPIVOTDATA(data_field, pivot_table, ...)

HLOOKUP(lookup_value, table_array, row_index, [range_lookup])

HSTACK(array1, [array2], ...)

HYPERLINK(link_location, [friendly_name])

IMAGE(source, [alt_text], [sizing], [height], [width])

INDEX(array, row_num, [column_num])

Use it for: Combine with MATCH for two-way lookups or lookups to the left.

INDIRECT(ref_text, [a1])

Use it for: Pull data from a sheet whose name is typed in a cell, such as a monthly report sheet.

LOOKUP(lookup_value, lookup_vector, [result_vector])

MATCH(lookup_value, lookup_array, [match_type])

Use it for: Pair with INDEX to find a row or column number dynamically.

OFFSET(reference, rows, cols, [height], [width])

Use it for: Build a dynamic range, such as a rolling 12-month total that moves as new data is added.

ROW([reference])

ROWS(array)

SORT(array, [sort_index], [sort_order], [by_col])

SORTBY(array, by_array1, [sort_order1], ...)

TAKE(array, rows, [columns])

TOCOL(array, [ignore], [scan_by_column])

TOROW(array, [ignore], [scan_by_column])

TRANSPOSE(array)

UNIQUE(array, [by_col], [exactly_once])

VLOOKUP(lookup_value, table, col_index, [exact])

Use it for: Look up a product's price or name from its product code.

VSTACK(array1, [array2], ...)

WRAPCOLS(vector, wrap_count, [pad_with])

WRAPROWS(vector, wrap_count, [pad_with])

XLOOKUP(lookup, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Use it for: Replace VLOOKUP in new workbooks, for example to find a price from a product code.

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

AND(logical1, [logical2], ...)

Use it for: Checking that a record meets several conditions at once, such as sales above target and complaints below a limit.

BYCOL(array, lambda)

BYROW(array, lambda)

FALSE()

IF(logical_test, value_if_true, value_if_false)

Use it for: Marking each student as Pass or Fail based on a minimum score.

IFERROR(value, value_if_error)

Use it for: Showing 0 or a blank on a dashboard instead of #DIV/0! or #N/A.

IFNA(value, value_if_na)

IFS(condition1, value1, [condition2, value2], ...)

Use it for: Converting exam scores into A, B, or C grades.

LAMBDA([parameter1, parameter2, ...], calculation)

LET(name1, value1, [name2, value2], ..., calculation)

Use it for: Shortening a long formula that repeats the same lookup several times.

MAKEARRAY(rows, cols, lambda)

MAP(array1, [array2], ..., lambda)

NOT(logical)

OR(logical1, [logical2], ...)

REDUCE([initial_value], array, lambda)

SCAN([initial_value], array, lambda)

SWITCH(expression, value1, result1, [value2, result2], ..., [default])

TRUE()

XOR(logical1, [logical2], ...)

ABS(number)

Use it for: Measuring how far actual spending differs from the budget, regardless of whether it is over or under.

ACOS(number)

ACOSH(number)

ACOT(number)

ACOTH(number)

AGGREGATE(function_num, options, ref1, ...)

Use it for: Totaling a sales column on a dashboard even when some cells contain errors such as #N/A.

ARABIC(text)

ASIN(number)

ASINH(number)

ATAN(number)

ATAN2(x_num, y_num)

ATANH(number)

BASE(number, radix, [min_length])

CEILING(number, significance)

CEILING.MATH(number, [significance], [mode])

CEILING.PRECISE(number, [significance])

COMBIN(number, number_chosen)

Use it for: Counting how many matches are needed when 8 teams each play every other team once.

COMBINA(number, number_chosen)

COS(number)

COSH(number)

COT(number)

COTH(number)

CSC(number)

CSCH(number)

DECIMAL(text, radix)

DEGREES(angle)

EVEN(number)

EXP(number)

FACT(number)

Use it for: Counting the ways to order 5 speakers in a presentation lineup.

FACTDOUBLE(number)

FLOOR(number, significance)

FLOOR.MATH(number, [significance], [mode])

FLOOR.PRECISE(number, [significance])

GCD(number1, [number2], ...)

INT(number)

Use it for: Finding how many full cartons a stock quantity fills when divided by the carton size.

ISO.CEILING(number, [significance])

LCM(number1, [number2], ...)

LN(number)

LOG(number, [base])

LOG10(number)

MDETERM(array)

MINVERSE(array)

MMULT(array1, array2)

MOD(number, divisor)

Use it for: Shading every other row through Conditional Formatting with =MOD(ROW(),2)=0.

MROUND(number, multiple)

MULTINOMIAL(number1, [number2], ...)

MUNIT(dimension)

ODD(number)

PI()

POWER(number, power)

Use it for: Calculating the value of savings after several years of compound interest, for example =B2*POWER(1+B3,B4).

PRODUCT(number1, [number2], ...)

QUOTIENT(numerator, denominator)

RADIANS(angle)

RAND()

Use it for: Generating sample data to test formulas before the real data is available.

RANDARRAY([rows], [cols], [min], [max], [integer])

RANDBETWEEN(bottom, top)

Use it for: Filling a column with sample scores between 1 and 100 for a training exercise.

ROMAN(number, [form])

ROUND(number, num_digits)

Use it for: Showing currency totals to two decimal places in a financial report.

ROUNDDOWN(number, num_digits)

ROUNDUP(number, num_digits)

SEC(number)

SECH(number)

SERIESSUM(x, n, m, coefficients)

SIGN(number)

Use it for: Flagging whether each month's profit rose, held steady, or fell compared with the previous month.

SIN(number)

SINH(number)

SQRT(number)

SQRTPI(number)

SUBTOTAL(function_num, ref1, ...)

Use it for: Showing a sales total that changes to match the visible rows after a table is filtered.

SUM(number1, [number2], ...)

Use it for: Totaling sales, expenses, or quantities for a period.

SUMIF(range, criteria, [sum_range])

Use it for: Totaling the expenses for one category, such as food.

SUMIFS(sum_range, criteria_range1, criteria1, ...)

Use it for: Totaling sales by month and category on a dashboard.

SUMPRODUCT(array1, [array2], ...)

Use it for: Calculating a weighted average, or total revenue from quantity and unit price columns.

SUMSQ(number1, [number2], ...)

SUMX2MY2(array_x, array_y)

SUMX2PY2(array_x, array_y)

SUMXMY2(array_x, array_y)

Use it for: Measuring forecast accuracy by comparing forecast values with actual results.

TAN(number)

TANH(number)

TRUNC(number, [num_digits])

AVEDEV(number1, [number2], ...)

AVERAGE(number1, [number2], ...)

Use it for: Find the average monthly sales across 12 months in column B.

AVERAGEA(value1, [value2], ...)

AVERAGEIF(range, criteria, [average_range])

AVERAGEIFS(avg_range, criteria_range1, criteria1, ...)

Use it for: Calculate average Q1 2026 sales as a benchmark for the following quarters.

BETA.DIST(x, alpha, beta, cumulative, [A], [B])

BETA.INV(probability, alpha, beta, [A], [B])

BINOM.DIST(number_s, trials, prob_s, cumulative)

BINOM.DIST.RANGE(trials, prob_s, num_s, [num_s2])

BINOM.INV(trials, probability_s, alpha)

CHISQ.DIST(x, deg_freedom, cumulative)

CHISQ.DIST.RT(x, deg_freedom)

CHISQ.INV(probability, deg_freedom)

CHISQ.INV.RT(probability, deg_freedom)

CHISQ.TEST(actual_range, expected_range)

CONFIDENCE.NORM(alpha, std_dev, size)

CONFIDENCE.T(alpha, std_dev, size)

CORREL(array1, array2)

Use it for: Measure how closely monthly ad spend moves with monthly sales.

COUNT(value1, [value2], ...)

Use it for: Count how many students already have a score in the marks column.

COUNTA(value1, [value2], ...)

Use it for: Count the participants who have registered in a name list.

COUNTBLANK(range)

Use it for: Check how many fields are still blank in a customer data sheet.

COUNTIF(range, criteria)

Use it for: Count the transactions above RM1,000.

COUNTIFS(range1, criteria1, ...)

Use it for: Count customers in Kuala Lumpur who spent more than RM5,000.

COVARIANCE.P(array1, array2)

COVARIANCE.S(array1, array2)

DEVSQ(number1, ...)

EXPON.DIST(x, lambda, cumulative)

F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

F.DIST.RT(x, deg_freedom1, deg_freedom2)

F.INV(probability, deg_freedom1, deg_freedom2)

F.INV.RT(probability, deg_freedom1, deg_freedom2)

F.TEST(array1, array2)

FISHER(x)

FISHERINV(y)

FORECAST.ETS(target_date, values, timeline, ...)

Use it for: Forecast next month's sales from monthly sales history that has a seasonal pattern.

FORECAST.ETS.CONFINT(target_date, values, timeline, ...)

FORECAST.ETS.SEASONALITY(values, timeline, ...)

FORECAST.ETS.STAT(values, timeline, statistic_type, ...)

FORECAST.LINEAR(x, known_ys, known_xs)

FREQUENCY(data_array, bins_array)

Use it for: Count students in each score band to build a histogram.

GAMMA(number)

GAMMA.DIST(x, alpha, beta, cumulative)

GAMMA.INV(probability, alpha, beta)

GAMMALN(x)

GAMMALN.PRECISE(x)

GAUSS(x)

GEOMEAN(number1, ...)

Use it for: Calculate the average annual growth rate from each year's growth factor.

GROWTH(known_ys, [known_xs], [new_xs], [const])

HARMEAN(number1, ...)

HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)

INTERCEPT(known_ys, known_xs)

KURT(number1, ...)

LARGE(array, k)

Use it for: Show the second-highest sale in a top-five list on a dashboard.

LINEST(known_ys, [known_xs], [const], [stats])

LOGEST(known_ys, [known_xs], [const], [stats])

LOGNORM.DIST(x, mean, standard_dev, cumulative)

LOGNORM.INV(probability, mean, standard_dev)

MAX(number1, [number2], ...)

Use it for: Find the month with the highest revenue or the largest expense in a year.

MAXA(value1, [value2], ...)

MAXIFS(max_range, criteria_range1, criteria1, ...)

Use it for: Find the highest sale in the Kuala Lumpur region for 2026.

MEDIAN(number1, [number2], ...)

Use it for: Report a typical employee salary without distortion from a few very high salaries.

MIN(number1, [number2], ...)

Use it for: Find the lowest share price over a period.

MINA(value1, [value2], ...)

MINIFS(min_range, criteria_range1, criteria1, ...)

MODE.MULT(number1, ...)

MODE.SNGL(number1, ...)

NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)

NORM.DIST(x, mean, standard_dev, cumulative)

NORM.INV(probability, mean, standard_dev)

NORM.S.DIST(z, cumulative)

NORM.S.INV(probability)

PEARSON(array1, array2)

PERCENTILE.EXC(array, k)

PERCENTILE.INC(array, k)

PERCENTRANK.EXC(array, x, [significance])

PERCENTRANK.INC(array, x, [significance])

PERMUT(number, number_chosen)

PERMUTATIONA(number, number_chosen)

PHI(x)

POISSON.DIST(x, mean, cumulative)

PROB(x_range, prob_range, [lower_limit], [upper_limit])

QUARTILE.EXC(array, quart)

QUARTILE.INC(array, quart)

RANK.AVG(number, ref, [order])

RANK.EQ(number, ref, [order])

Use it for: Rank salespeople on a monthly sales leaderboard.

RSQ(known_ys, known_xs)

SKEW(number1, ...)

SKEW.P(number1, ...)

SLOPE(known_ys, known_xs)

SMALL(array, k)

STANDARDIZE(x, mean, standard_dev)

STDEV.P(number1, ...)

STDEV.S(number1, ...)

Use it for: Measure how much daily delivery times vary around their average.

STDEVA(value1, ...)

STDEVPA(value1, ...)

STEYX(known_ys, known_xs)

T.DIST(x, deg_freedom, cumulative)

T.DIST.2T(x, deg_freedom)

T.DIST.RT(x, deg_freedom)

T.INV(probability, deg_freedom)

T.INV.2T(probability, deg_freedom)

T.TEST(array1, array2, tails, type)

TREND(known_ys, [known_xs], [new_xs], [const])

TRIMMEAN(array, percent)

Use it for: Average judges' scores after dropping the extreme high and low marks.

VAR.P(number1, ...)

VAR.S(number1, ...)

VARA(value1, ...)

VARPA(value1, ...)

WEIBULL.DIST(x, alpha, beta, cumulative)

Z.TEST(array, x, [sigma])

ARRAYTOTEXT(array, [format])

ASC(text)

BAHTTEXT(number)

CHAR(number)

CLEAN(text)

Use it for: Cleaning text imported from another system before analysis.

CODE(text)

CONCAT(text1, [text2], ...)

Use it for: Combining a branch code, year, and serial number into a single reference number.

CONCATENATE(text1, [text2], ...)

DBCS(text)

DOLLAR(number, [decimals])

EXACT(text1, text2)

FIND(find_text, within_text, [start_num])

FIXED(number, [decimals], [no_commas])

LEFT(text, [num_chars])

Use it for: Extracting a three-letter prefix from a product code.

LEN(text)

Use it for: Checking that every ID number in a list has exactly 12 digits.

LOWER(text)

Use it for: Standardizing email addresses before comparing them or removing duplicates.

MID(text, start_num, num_chars)

Use it for: Extracting a fixed segment, such as a region code, from a structured ID or account number.

NUMBERVALUE(text, [decimal_separator], [group_separator])

PROPER(text)

Use it for: Tidying customer names that were typed in all capitals or all lowercase.

REPLACE(old_text, start_num, num_chars, new_text)

REPT(text, number_times)

Use it for: Drawing a simple bar chart inside a cell, e.g. one bar for every RM1,000 of sales.

RIGHT(text, [num_chars])

SEARCH(find_text, within_text, [start_num])

SUBSTITUTE(text, old_text, new_text, [instance_num])

Use it for: Removing dashes from phone numbers.

T(value)

TEXT(value, format_text)

Use it for: Showing a KPI inside a sentence on a dashboard, such as "Sales up 25.0%".

TEXTAFTER(text, delimiter, [instance_num], ...)

TEXTBEFORE(text, delimiter, [instance_num], ...)

TEXTJOIN(delimiter, ignore_empty, text1, ...)

Use it for: Combining a column of names into a single comma-separated line.

TEXTSPLIT(text, col_delimiter, [row_delimiter], ...)

TRIM(text)

Use it for: Cleaning imported CSV data before a VLOOKUP so that hidden spaces do not cause failed matches.

UNICHAR(number)

UNICODE(text)

UPPER(text)

Use it for: Standardizing product or branch codes so they are all in capitals.

VALUE(text)

Use it for: Fixing numbers stored as text so they can be added up.

VALUETOTEXT(value, [format])

DATE(year, month, day)

Use it for: Building a full date from separate year, month, and day columns.

DATEDIF(start_date, end_date, unit)

Use it for: Calculating an employee's age or length of service in complete years.

DATEVALUE(date_text)

DAY(serial_number)

DAYS(end_date, start_date)

Use it for: Counting how many days an invoice has been outstanding.

DAYS360(start_date, end_date, [method])

EDATE(start_date, months)

Use it for: Calculating the end date of a subscription or contract from its length in months.

EOMONTH(start_date, months)

Use it for: Finding the month-end closing date for monthly reports.

HOUR(serial_number)

ISOWEEKNUM(date)

MINUTE(serial_number)

MONTH(serial_number)

Use it for: Grouping transactions by month for a monthly sales summary.

NETWORKDAYS(start_date, end_date, [holidays])

Use it for: Counting the working days available to complete a project.

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

NOW()

Use it for: Showing the current date and time on a printed report.

SECOND(serial_number)

TIME(hour, minute, second)

TIMEVALUE(time_text)

TODAY()

Use it for: Calculating how many days a payment is overdue as of today.

WEEKDAY(serial_number, [return_type])

Use it for: Checking whether a booking date falls on a weekday or a weekend.

WEEKNUM(serial_number, [return_type])

WORKDAY(start_date, days, [holidays])

Use it for: Setting a project deadline 10 working days from today.

WORKDAY.INTL(start_date, days, [weekend], [holidays])

YEAR(serial_number)

Use it for: Grouping sales data by year.

YEARFRAC(start_date, end_date, [basis])

Use it for: Prorating a bonus or annual leave for an employee who has served less than a full year.

ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

ACCRINTM(issue, settlement, rate, par, [basis])

AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])

AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

COUPDAYBS(settlement, maturity, frequency, [basis])

COUPDAYS(settlement, maturity, frequency, [basis])

COUPDAYSNC(settlement, maturity, frequency, [basis])

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

COUPNUM(settlement, maturity, frequency, [basis])

COUPPCD(settlement, maturity, frequency, [basis])

CUMIPMT(rate, nper, pv, start_period, end_period, type)

CUMPRINC(rate, nper, pv, start_period, end_period, type)

DB(cost, salvage, life, period, [month])

DDB(cost, salvage, life, period, [factor])

DISC(settlement, maturity, pr, redemption, [basis])

DOLLARDE(fractional_dollar, fraction)

DOLLARFR(decimal_dollar, fraction)

DURATION(settlement, maturity, coupon, yld, frequency, [basis])

EFFECT(nominal_rate, npery)

FV(rate, nper, pmt, [pv], [type])

Use it for: Estimate a retirement savings balance after putting away the same amount every month.

FVSCHEDULE(principal, schedule)

INTRATE(settlement, maturity, investment, redemption, [basis])

IPMT(rate, per, nper, pv, [fv], [type])

IRR(values, [guess])

Use it for: Compare the returns of several investment projects from their yearly cash flows.

ISPMT(rate, per, nper, pv)

MDURATION(settlement, maturity, coupon, yld, frequency, [basis])

MIRR(values, finance_rate, reinvest_rate)

NOMINAL(effect_rate, npery)

NPER(rate, pmt, pv, [fv], [type])

Use it for: Work out how many months it takes to pay off a loan with a fixed monthly installment.

NPV(rate, value1, [value2], ...)

Use it for: Check whether a capital project returns more than its cost of capital before approving it.

ODDFPRICE(...)

ODDFYIELD(...)

ODDLPRICE(...)

ODDLYIELD(...)

PDURATION(rate, pv, fv)

PMT(rate, nper, pv, [fv], [type])

Use it for: Calculate the monthly installment on a car loan or home loan.

PPMT(rate, per, nper, pv, [fv], [type])

PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])

PRICEDISC(settlement, maturity, discount, redemption, [basis])

PRICEMAT(settlement, maturity, issue, rate, yld, [basis])

PV(rate, nper, pmt, [fv], [type])

Use it for: Find what an annuity that pays a fixed monthly amount is worth today.

RATE(nper, pmt, pv, [fv], [type], [guess])

Use it for: Find the actual annual rate of a loan when you only know the monthly installment and the amount borrowed.

RECEIVED(settlement, maturity, investment, discount, [basis])

RRI(nper, pv, fv)

SLN(cost, salvage, life)

STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [properties]...)

SYD(cost, salvage, life, per)

TBILLEQ(settlement, maturity, discount)

TBILLPRICE(settlement, maturity, discount)

TBILLYIELD(settlement, maturity, pr)

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

XIRR(values, dates, [guess])

Use it for: Measure the actual return on an investment with deposits and withdrawals on different dates.

XNPV(rate, values, dates)

YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])

YIELDDISC(settlement, maturity, pr, redemption, [basis])

YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

CELL(info_type, [reference])

ERROR.TYPE(error_val)

INFO(type_text)

ISBLANK(value)

Use it for: Check whether the required fields in a registration form have been filled in.

ISERR(value)

ISERROR(value)

Use it for: Detect failing formulas so you can show a clear message instead of an error.

ISEVEN(number)

ISFORMULA(reference)

ISLOGICAL(value)

ISNA(value)

ISNONTEXT(value)

ISNUMBER(value)

Use it for: Make sure a price column contains only numbers before you total it.

ISODD(number)

ISOMITTED(argument)

ISREF(value)

ISTEXT(value)

N(value)

NA()

SHEET([value])

SHEETS([reference])

TYPE(value)

BESSELI(x, n)

BESSELJ(x, n)

BESSELK(x, n)

BESSELY(x, n)

BIN2DEC(number)

BIN2HEX(number, [places])

BIN2OCT(number, [places])

BITAND(number1, number2)

BITLSHIFT(number, shift_amount)

BITOR(number1, number2)

BITRSHIFT(number, shift_amount)

BITXOR(number1, number2)

COMPLEX(real_num, i_num, [suffix])

CONVERT(number, from_unit, to_unit)

DEC2BIN(number, [places])

DEC2HEX(number, [places])

DEC2OCT(number, [places])

DELTA(number1, [number2])

ERF(lower_limit, [upper_limit])

ERF.PRECISE(x)

ERFC(x)

ERFC.PRECISE(x)

GESTEP(number, [step])

HEX2BIN(number, [places])

HEX2DEC(number)

HEX2OCT(number, [places])

IMABS(inumber)

IMAGINARY(inumber)

IMARGUMENT(inumber)

IMCONJUGATE(inumber)

IMCOS(inumber)

IMCOSH(inumber)

IMCOT(inumber)

IMCSC(inumber)

IMCSCH(inumber)

IMDIV(inumber1, inumber2)

IMEXP(inumber)

IMLN(inumber)

IMLOG10(inumber)

IMLOG2(inumber)

IMPOWER(inumber, number)

IMPRODUCT(inumber1, ...)

IMREAL(inumber)

IMSEC(inumber)

IMSECH(inumber)

IMSIN(inumber)

IMSINH(inumber)

IMSQRT(inumber)

IMSUB(inumber1, inumber2)

IMSUM(inumber1, ...)

IMTAN(inumber)

OCT2BIN(number, [places])

OCT2DEC(number)

OCT2HEX(number, [places])

DAVERAGE(database, field, criteria)

DCOUNT(database, field, criteria)

DCOUNTA(database, field, criteria)

DGET(database, field, criteria)

DMAX(database, field, criteria)

DMIN(database, field, criteria)

DPRODUCT(database, field, criteria)

DSTDEV(database, field, criteria)

DSTDEVP(database, field, criteria)

DSUM(database, field, criteria)

DVAR(database, field, criteria)

DVARP(database, field, criteria)

CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])

CUBEMEMBER(connection, member_expression, [caption])

CUBEMEMBERPROPERTY(connection, member_expression, property)

CUBERANKEDMEMBER(connection, set_expression, rank, [caption])

CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])

CUBESETCOUNT(set)

CUBEVALUE(connection, [member_expression1], ...)

ENCODEURL(text)

FILTERXML(xml, xpath)

WEBSERVICE(url)

BETADIST(x, alpha, beta, [A], [B])

BETAINV(probability, alpha, beta, [A], [B])

BINOMDIST(number_s, trials, prob_s, cumulative)

CHIDIST(x, deg_freedom)

CHIINV(probability, deg_freedom)

CHITEST(actual_range, expected_range)

CONFIDENCE(alpha, standard_dev, size)

COVAR(array1, array2)

CRITBINOM(trials, probability_s, alpha)

EXPONDIST(x, lambda, cumulative)

FDIST(x, deg_freedom1, deg_freedom2)

FINV(probability, deg_freedom1, deg_freedom2)

FORECAST(x, known_ys, known_xs)

FTEST(array1, array2)

GAMMADIST(x, alpha, beta, cumulative)

GAMMAINV(probability, alpha, beta)

HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)

LOGINV(probability, mean, standard_dev)

LOGNORMDIST(x, mean, standard_dev)

MODE(number1, ...)

NEGBINOMDIST(number_f, number_s, probability_s)

NORMDIST(x, mean, standard_dev, cumulative)

NORMINV(probability, mean, standard_dev)

NORMSDIST(z)

NORMSINV(probability)

PERCENTILE(array, k)

PERCENTRANK(array, x, [significance])

POISSON(x, mean, cumulative)

QUARTILE(array, quart)

RANK(number, ref, [order])

STDEV(number1, ...)

STDEVP(number1, ...)

TDIST(x, deg_freedom, tails)

TINV(probability, deg_freedom)

TTEST(array1, array2, tails, type)

VAR(number1, ...)

VARP(number1, ...)

WEIBULL(x, alpha, beta, cumulative)

ZTEST(array, x, [sigma])

FLOOR.PRECISE(number)