Excel function list
All of it in one table: name, category, syntax, and the version it first appeared in.
Argument separator
Excel uses a semicolon in regions where decimals are written with a comma, and a comma in regions that use a decimal point. Switch it here if a formula is rejected when you paste it.
SUM(A1, A2)
524 functions
| Function | Syntax | Category | Available since |
|---|---|---|---|
| ABS | ABS(number) | Math and trigonometry | Excel 2003 or older |
| ACCRINT | ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ACCRINTM | ACCRINTM(issue, settlement, rate, par, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ACOS | ACOS(number) | Math and trigonometry | Excel 2003 or older |
| ACOSH | ACOSH(number) | Math and trigonometry | Excel 2003 or older |
| ACOT | ACOT(number) | Math and trigonometry | Excel 2013 |
| ACOTH | ACOTH(number) | Math and trigonometry | Excel 2013 |
| ADDRESS | ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) | Lookup and reference | Excel 2003 or older |
| AGGREGATE | AGGREGATE(function_num, options, ref1, [ref2], ...) | Math and trigonometry | Excel 2010 |
| AMORDEGRC | AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| AMORLINC | AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| AND | AND(logical1, [logical2], ...) | Logical | Excel 2003 or older |
| ARABIC | ARABIC(text) | Math and trigonometry | Excel 2013 |
| AREAS | AREAS(reference) | Lookup and reference | Excel 2003 or older |
| ARRAYTOTEXTSpills its result across several cells | ARRAYTOTEXT(array, [format]) | Text | Excel 2024 and Microsoft 365 |
| ASC | ASC(text) | Text | Excel 2003 or older |
| ASIN | ASIN(number) | Math and trigonometry | Excel 2003 or older |
| ASINH | ASINH(number) | Math and trigonometry | Excel 2003 or older |
| ATAN | ATAN(number) | Math and trigonometry | Excel 2003 or older |
| ATAN2 | ATAN2(x_num, y_num) | Math and trigonometry | Excel 2003 or older |
| ATANH | ATANH(number) | Math and trigonometry | Excel 2003 or older |
| AVEDEV | AVEDEV(number1, [number2], ...) | Statistical | Excel 2003 or older |
| AVERAGE | AVERAGE(number1, [number2], ...) | Statistical | Excel 2003 or older |
| AVERAGEA | AVERAGEA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| AVERAGEIF | AVERAGEIF(range, criteria, [average_range]) | Statistical | Excel 2007 |
| AVERAGEIFS | AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) | Statistical | Excel 2007 |
| BAHTTEXTNeeds Excel | BAHTTEXT(number) | Text | Excel 2003 or older |
| BASE | BASE(number, radix, [min_length]) | Math and trigonometry | Excel 2013 |
| BESSELI | BESSELI(x, n) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BESSELJ | BESSELJ(x, n) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BESSELK | BESSELK(x, n) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BESSELY | BESSELY(x, n) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BETA.DIST | BETA.DIST(x, alpha, beta, cumulative, [A], [B]) | Statistical | Excel 2010 |
| BETA.INV | BETA.INV(probability, alpha, beta, [A], [B]) | Statistical | Excel 2010 |
| BETADISTReplaced by BETA.DIST | BETADIST(x, alpha, beta, [A], [B]) | Compatibility | Excel 2003 or older |
| BETAINVReplaced by BETA.INV | BETAINV(probability, alpha, beta, [A], [B]) | Compatibility | Excel 2003 or older |
| BIN2DEC | BIN2DEC(number) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BIN2HEX | BIN2HEX(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BIN2OCT | BIN2OCT(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| BINOM.DIST | BINOM.DIST(number_s, trials, probability_s, cumulative) | Statistical | Excel 2010 |
| BINOM.DIST.RANGE | BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]) | Statistical | Excel 2013 |
| BINOM.INV | BINOM.INV(trials, probability_s, alpha) | Statistical | Excel 2010 |
| BINOMDISTReplaced by BINOM.DIST | BINOMDIST(number_s, trials, probability_s, cumulative) | Compatibility | Excel 2003 or older |
| BITAND | BITAND(number1, number2) | Engineering | Excel 2013 |
| BITLSHIFT | BITLSHIFT(number, shift_amount) | Engineering | Excel 2013 |
| BITOR | BITOR(number1, number2) | Engineering | Excel 2013 |
| BITRSHIFT | BITRSHIFT(number, shift_amount) | Engineering | Excel 2013 |
| BITXOR | BITXOR(number1, number2) | Engineering | Excel 2013 |
| BYCOLSpills its result across several cells | BYCOL(array, lambda) | Logical | Excel 2024 and Microsoft 365 |
| BYROWSpills its result across several cells | BYROW(array, lambda) | Logical | Excel 2024 and Microsoft 365 |
| CALLNeeds Excel | CALL(register_id, [argument1], ...) | Add-in and automation | Excel 2003 or older |
| CEILINGReplaced by CEILING.MATH | CEILING(number, significance) | Math and trigonometry | Excel 2003 or older |
| CEILING.MATH | CEILING.MATH(number, [significance], [mode]) | Math and trigonometry | Excel 2013 |
| CEILING.PRECISE | CEILING.PRECISE(number, [significance]) | Math and trigonometry | Excel 2010 |
| CELLRecalculates on every changeNeeds Excel | CELL(info_type, [reference]) | Information | Excel 2003 or older |
| CHAR | CHAR(number) | Text | Excel 2003 or older |
| CHIDISTReplaced by CHISQ.DIST.RT | CHIDIST(x, deg_freedom) | Compatibility | Excel 2003 or older |
| CHIINVReplaced by CHISQ.INV.RT | CHIINV(probability, deg_freedom) | Compatibility | Excel 2003 or older |
| CHISQ.DIST | CHISQ.DIST(x, deg_freedom, cumulative) | Statistical | Excel 2010 |
| CHISQ.DIST.RT | CHISQ.DIST.RT(x, deg_freedom) | Statistical | Excel 2010 |
| CHISQ.INV | CHISQ.INV(probability, deg_freedom) | Statistical | Excel 2010 |
| CHISQ.INV.RT | CHISQ.INV.RT(probability, deg_freedom) | Statistical | Excel 2010 |
| CHISQ.TEST | CHISQ.TEST(actual_range, expected_range) | Statistical | Excel 2010 |
| CHITESTReplaced by CHISQ.TEST | CHITEST(actual_range, expected_range) | Compatibility | Excel 2003 or older |
| CHOOSE | CHOOSE(index_num, value1, [value2], ...) | Lookup and reference | Excel 2003 or older |
| CHOOSECOLSSpills its result across several cells | CHOOSECOLS(array, col_num1, [col_num2], ...) | Lookup and reference | Excel 2024 and Microsoft 365 |
| CHOOSEROWSSpills its result across several cells | CHOOSEROWS(array, row_num1, [row_num2], ...) | Lookup and reference | Excel 2024 and Microsoft 365 |
| CLEAN | CLEAN(text) | Text | Excel 2003 or older |
| CODE | CODE(text) | Text | Excel 2003 or older |
| COLUMN | COLUMN([reference]) | Lookup and reference | Excel 2003 or older |
| COLUMNS | COLUMNS(array) | Lookup and reference | Excel 2003 or older |
| COMBIN | COMBIN(number, number_chosen) | Math and trigonometry | Excel 2003 or older |
| COMBINA | COMBINA(number, number_chosen) | Math and trigonometry | Excel 2013 |
| COMPLEX | COMPLEX(real_num, i_num, [suffix]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| CONCATReplaced by CONCATENATE | CONCAT(text1, [text2], ...) | Text | Excel 2019 |
| CONCATENATEReplaced by CONCAT atau TEXTJOIN | CONCATENATE(text1, [text2], ...) | Text | Excel 2003 or older |
| CONFIDENCEReplaced by CONFIDENCE.NORM | CONFIDENCE(alpha, standard_dev, size) | Compatibility | Excel 2003 or older |
| CONFIDENCE.NORM | CONFIDENCE.NORM(alpha, standard_dev, size) | Statistical | Excel 2010 |
| CONFIDENCE.T | CONFIDENCE.T(alpha, standard_dev, size) | Statistical | Excel 2010 |
| CONVERT | CONVERT(number, from_unit, to_unit) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COPILOTRecalculates on every changeNeeds ExcelReplaced by Copilot di panel samping | COPILOT(prompt_part1, [context1], [prompt_part2], [context2], ...) | Custom functions and linked data types | Microsoft 365 only, not in perpetual Excel editions |
| CORREL | CORREL(array1, array2) | Statistical | Excel 2003 or older |
| COS | COS(number) | Math and trigonometry | Excel 2003 or older |
| COSH | COSH(number) | Math and trigonometry | Excel 2003 or older |
| COT | COT(number) | Math and trigonometry | Excel 2013 |
| COTH | COTH(number) | Math and trigonometry | Excel 2013 |
| COUNT | COUNT(value1, [value2], ...) | Statistical | Excel 2003 or older |
| COUNTA | COUNTA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| COUNTBLANK | COUNTBLANK(range) | Statistical | Excel 2003 or older |
| COUNTIF | COUNTIF(range, criteria) | Statistical | Excel 2003 or older |
| COUNTIFS | COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...) | Statistical | Excel 2007 |
| COUPDAYBS | COUPDAYBS(settlement, maturity, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COUPDAYS | COUPDAYS(settlement, maturity, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COUPDAYSNC | COUPDAYSNC(settlement, maturity, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COUPNCD | COUPNCD(settlement, maturity, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COUPNUM | COUPNUM(settlement, maturity, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COUPPCD | COUPPCD(settlement, maturity, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| COVARReplaced by COVARIANCE.P | COVAR(array1, array2) | Compatibility | Excel 2003 or older |
| COVARIANCE.P | COVARIANCE.P(array1, array2) | Statistical | Excel 2010 |
| COVARIANCE.S | COVARIANCE.S(array1, array2) | Statistical | Excel 2010 |
| CRITBINOMReplaced by BINOM.INV | CRITBINOM(trials, probability_s, alpha) | Compatibility | Excel 2003 or older |
| CSC | CSC(number) | Math and trigonometry | Excel 2013 |
| CSCH | CSCH(number) | Math and trigonometry | Excel 2013 |
| CUBEKPIMEMBERNeeds Excel | CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption]) | Cube | Excel 2007 |
| CUBEMEMBERNeeds Excel | CUBEMEMBER(connection, member_expression, [caption]) | Cube | Excel 2007 |
| CUBEMEMBERPROPERTYNeeds Excel | CUBEMEMBERPROPERTY(connection, member_expression, property) | Cube | Excel 2007 |
| CUBERANKEDMEMBERNeeds Excel | CUBERANKEDMEMBER(connection, set_expression, rank, [caption]) | Cube | Excel 2007 |
| CUBESETNeeds Excel | CUBESET(connection, set_expression, [caption], [sort_order], [sort_by]) | Cube | Excel 2007 |
| CUBESETCOUNTNeeds Excel | CUBESETCOUNT(set) | Cube | Excel 2007 |
| CUBEVALUENeeds Excel | CUBEVALUE(connection, [member_expression1], [member_expression2], ...) | Cube | Excel 2007 |
| CUMIPMT | CUMIPMT(rate, nper, pv, start_period, end_period, type) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| CUMPRINC | CUMPRINC(rate, nper, pv, start_period, end_period, type) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DATE | DATE(year, month, day) | Date and time | Excel 2003 or older |
| DATEDIF | DATEDIF(start_date, end_date, unit) | Date and time | Excel 2003 or older |
| DATEVALUE | DATEVALUE(date_text) | Date and time | Excel 2003 or older |
| DAVERAGE | DAVERAGE(database, field, criteria) | Database | Excel 2003 or older |
| DAY | DAY(serial_number) | Date and time | Excel 2003 or older |
| DAYS | DAYS(end_date, start_date) | Date and time | Excel 2013 |
| DAYS360 | DAYS360(start_date, end_date, [method]) | Date and time | Excel 2003 or older |
| DB | DB(cost, salvage, life, period, [month]) | Financial | Excel 2003 or older |
| DBCS | DBCS(text) | Text | Excel 2013 |
| DCOUNT | DCOUNT(database, field, criteria) | Database | Excel 2003 or older |
| DCOUNTA | DCOUNTA(database, field, criteria) | Database | Excel 2003 or older |
| DDB | DDB(cost, salvage, life, period, [factor]) | Financial | Excel 2003 or older |
| DEC2BIN | DEC2BIN(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DEC2HEX | DEC2HEX(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DEC2OCT | DEC2OCT(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DECIMAL | DECIMAL(text, radix) | Math and trigonometry | Excel 2013 |
| DEGREES | DEGREES(angle) | Math and trigonometry | Excel 2003 or older |
| DELTA | DELTA(number1, [number2]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DETECTLANGUAGENeeds Excel | DETECTLANGUAGE(text) | Text | Microsoft 365 only, not in perpetual Excel editions |
| DEVSQ | DEVSQ(number1, [number2], ...) | Statistical | Excel 2003 or older |
| DGET | DGET(database, field, criteria) | Database | Excel 2003 or older |
| DISC | DISC(settlement, maturity, pr, redemption, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DMAX | DMAX(database, field, criteria) | Database | Excel 2003 or older |
| DMIN | DMIN(database, field, criteria) | Database | Excel 2003 or older |
| DOLLAR | DOLLAR(number, [decimals]) | Text | Excel 2003 or older |
| DOLLARDE | DOLLARDE(fractional_dollar, fraction) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DOLLARFR | DOLLARFR(decimal_dollar, fraction) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DPRODUCT | DPRODUCT(database, field, criteria) | Database | Excel 2003 or older |
| DROPSpills its result across several cells | DROP(array, rows, [columns]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| DSTDEV | DSTDEV(database, field, criteria) | Database | Excel 2003 or older |
| DSTDEVP | DSTDEVP(database, field, criteria) | Database | Excel 2003 or older |
| DSUM | DSUM(database, field, criteria) | Database | Excel 2003 or older |
| DURATION | DURATION(settlement, maturity, coupon, yld, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| DVAR | DVAR(database, field, criteria) | Database | Excel 2003 or older |
| DVARP | DVARP(database, field, criteria) | Database | Excel 2003 or older |
| EDATE | EDATE(start_date, months) | Date and time | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| EFFECT | EFFECT(nominal_rate, npery) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ENCODEURL | ENCODEURL(text) | Web | Excel 2013 |
| EOMONTH | EOMONTH(start_date, months) | Date and time | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ERF | ERF(lower_limit, [upper_limit]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ERF.PRECISE | ERF.PRECISE(x) | Engineering | Excel 2010 |
| ERFC | ERFC(x) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ERFC.PRECISE | ERFC.PRECISE(x) | Engineering | Excel 2010 |
| ERROR.TYPE | ERROR.TYPE(error_val) | Information | Excel 2003 or older |
| EUROCONVERTNeeds Excel | EUROCONVERT(number, source, target, [full_precision], [triangulation_precision]) | Add-in and automation | Excel 2003 or older |
| EVEN | EVEN(number) | Math and trigonometry | Excel 2003 or older |
| EXACT | EXACT(text1, text2) | Text | Excel 2003 or older |
| EXP | EXP(number) | Math and trigonometry | Excel 2003 or older |
| EXPANDSpills its result across several cells | EXPAND(array, rows, [columns], [pad_with]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| EXPON.DIST | EXPON.DIST(x, lambda, cumulative) | Statistical | Excel 2010 |
| EXPONDISTReplaced by EXPON.DIST | EXPONDIST(x, lambda, cumulative) | Compatibility | Excel 2003 or older |
| F.DIST | F.DIST(x, deg_freedom1, deg_freedom2, cumulative) | Statistical | Excel 2010 |
| F.DIST.RT | F.DIST.RT(x, deg_freedom1, deg_freedom2) | Statistical | Excel 2010 |
| F.INV | F.INV(probability, deg_freedom1, deg_freedom2) | Statistical | Excel 2010 |
| F.INV.RT | F.INV.RT(probability, deg_freedom1, deg_freedom2) | Statistical | Excel 2010 |
| F.TEST | F.TEST(array1, array2) | Statistical | Excel 2010 |
| FACT | FACT(number) | Math and trigonometry | Excel 2003 or older |
| FACTDOUBLE | FACTDOUBLE(number) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| FALSE | FALSE() | Logical | Excel 2003 or older |
| FDISTReplaced by F.DIST.RT | FDIST(x, deg_freedom1, deg_freedom2) | Compatibility | Excel 2003 or older |
| FIELDVALUENeeds Excel | FIELDVALUE(value, field_name) | Lookup and reference | Microsoft 365 only, not in perpetual Excel editions |
| FILTERSpills its result across several cells | FILTER(array, include, [if_empty]) | Lookup and reference | Excel 2021 and Microsoft 365 |
| FILTERXMLNeeds Excel | FILTERXML(xml, xpath) | Web | Excel 2013 |
| FIND | FIND(find_text, within_text, [start_num]) | Text | Excel 2003 or older |
| FINDB | FINDB(find_text, within_text, [start_num]) | Text | Excel 2003 or older |
| FINVReplaced by F.INV.RT | FINV(probability, deg_freedom1, deg_freedom2) | Compatibility | Excel 2003 or older |
| FISHER | FISHER(x) | Statistical | Excel 2003 or older |
| FISHERINV | FISHERINV(y) | Statistical | Excel 2003 or older |
| FIXED | FIXED(number, [decimals], [no_commas]) | Text | Excel 2003 or older |
| FLOORReplaced by FLOOR.MATH | FLOOR(number, significance) | Math and trigonometry | Excel 2003 or older |
| FLOOR.MATH | FLOOR.MATH(number, [significance], [mode]) | Math and trigonometry | Excel 2013 |
| FLOOR.PRECISE | FLOOR.PRECISE(number, [significance]) | Math and trigonometry | Excel 2010 |
| FORECASTReplaced by FORECAST.LINEAR | FORECAST(x, known_ys, known_xs) | Statistical | Excel 2003 or older |
| FORECAST.ETSNeeds Excel | FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation]) | Statistical | Excel 2016 |
| FORECAST.ETS.CONFINTNeeds Excel | FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]) | Statistical | Excel 2016 |
| FORECAST.ETS.SEASONALITYNeeds Excel | FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation]) | Statistical | Excel 2016 |
| FORECAST.ETS.STATNeeds Excel | FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]) | Statistical | Excel 2016 |
| FORECAST.LINEAR | FORECAST.LINEAR(x, known_ys, known_xs) | Statistical | Excel 2016 |
| FORMULATEXT | FORMULATEXT(reference) | Lookup and reference | Excel 2013 |
| FREQUENCYSpills its result across several cells | FREQUENCY(data_array, bins_array) | Statistical | Excel 2003 or older |
| FTESTReplaced by F.TEST | FTEST(array1, array2) | Compatibility | Excel 2003 or older |
| FV | FV(rate, nper, pmt, [pv], [type]) | Financial | Excel 2003 or older |
| FVSCHEDULE | FVSCHEDULE(principal, schedule) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| GAMMA | GAMMA(x) | Statistical | Excel 2013 |
| GAMMA.DIST | GAMMA.DIST(x, alpha, beta, cumulative) | Statistical | Excel 2010 |
| GAMMA.INV | GAMMA.INV(probability, alpha, beta) | Statistical | Excel 2010 |
| GAMMADISTReplaced by GAMMA.DIST | GAMMADIST(x, alpha, beta, cumulative) | Compatibility | Excel 2003 or older |
| GAMMAINVReplaced by GAMMA.INV | GAMMAINV(probability, alpha, beta) | Compatibility | Excel 2003 or older |
| GAMMALN | GAMMALN(x) | Statistical | Excel 2003 or older |
| GAMMALN.PRECISE | GAMMALN.PRECISE(x) | Statistical | Excel 2010 |
| GAUSS | GAUSS(z) | Statistical | Excel 2013 |
| GCD | GCD(number1, [number2], ...) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| GEOMEAN | GEOMEAN(number1, [number2], ...) | Statistical | Excel 2003 or older |
| GESTEP | GESTEP(number, [step]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| GETPIVOTDATANeeds Excel | GETPIVOTDATA(data_field, pivot_table, [field1, item1], [field2, item2], ...) | Lookup and reference | Excel 2003 or older |
| GROUPBYSpills its result across several cellsNeeds Excel | GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship]) | Lookup and reference | Microsoft 365 only, not in perpetual Excel editions |
| GROWTHSpills its result across several cells | GROWTH(known_ys, [known_xs], [new_xs], [const]) | Statistical | Excel 2003 or older |
| HARMEAN | HARMEAN(number1, [number2], ...) | Statistical | Excel 2003 or older |
| HEX2BIN | HEX2BIN(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| HEX2DEC | HEX2DEC(number) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| HEX2OCT | HEX2OCT(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| HLOOKUPReplaced by XLOOKUP | HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) | Lookup and reference | Excel 2003 or older |
| HOUR | HOUR(serial_number) | Date and time | Excel 2003 or older |
| HSTACKSpills its result across several cells | HSTACK(array1, [array2], ...) | Lookup and reference | Excel 2024 and Microsoft 365 |
| HYPERLINKNeeds Excel | HYPERLINK(link_location, [friendly_name]) | Lookup and reference | Excel 2003 or older |
| HYPGEOM.DIST | HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative) | Statistical | Excel 2010 |
| HYPGEOMDISTReplaced by HYPGEOM.DIST | HYPGEOMDIST(sample_s, number_sample, population_s, number_pop) | Compatibility | Excel 2003 or older |
| IF | IF(logical_test, [value_if_true], [value_if_false]) | Logical | Excel 2003 or older |
| IFERROR | IFERROR(value, value_if_error) | Logical | Excel 2007 |
| IFNA | IFNA(value, value_if_na) | Logical | Excel 2013 |
| IFS | IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...) | Logical | Excel 2019 |
| IMABS | IMABS(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMAGESpills its result across several cellsNeeds Excel | IMAGE(source, [alt_text], [sizing], [height], [width]) | Lookup and reference | Microsoft 365 only, not in perpetual Excel editions |
| IMAGINARY | IMAGINARY(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMARGUMENT | IMARGUMENT(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMCONJUGATE | IMCONJUGATE(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMCOS | IMCOS(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMCOSH | IMCOSH(inumber) | Engineering | Excel 2013 |
| IMCOT | IMCOT(inumber) | Engineering | Excel 2013 |
| IMCSC | IMCSC(inumber) | Engineering | Excel 2013 |
| IMCSCH | IMCSCH(inumber) | Engineering | Excel 2013 |
| IMDIV | IMDIV(inumber1, inumber2) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMEXP | IMEXP(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMLN | IMLN(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMLOG10 | IMLOG10(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMLOG2 | IMLOG2(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMPOWER | IMPOWER(inumber, number) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMPRODUCT | IMPRODUCT(inumber1, [inumber2], ...) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMREAL | IMREAL(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMSEC | IMSEC(inumber) | Engineering | Excel 2013 |
| IMSECH | IMSECH(inumber) | Engineering | Excel 2013 |
| IMSIN | IMSIN(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMSINH | IMSINH(inumber) | Engineering | Excel 2013 |
| IMSQRT | IMSQRT(inumber) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMSUB | IMSUB(inumber1, inumber2) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMSUM | IMSUM(inumber1, [inumber2], ...) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IMTAN | IMTAN(inumber) | Engineering | Excel 2013 |
| INDEX | INDEX(array, row_num, [column_num]) | Lookup and reference | Excel 2003 or older |
| INDIRECTRecalculates on every change | INDIRECT(ref_text, [a1]) | Lookup and reference | Excel 2003 or older |
| INFORecalculates on every changeNeeds Excel | INFO(type_text) | Information | Excel 2003 or older |
| INT | INT(number) | Math and trigonometry | Excel 2003 or older |
| INTERCEPT | INTERCEPT(known_ys, known_xs) | Statistical | Excel 2003 or older |
| INTRATE | INTRATE(settlement, maturity, investment, redemption, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| IPMT | IPMT(rate, per, nper, pv, [fv], [type]) | Financial | Excel 2003 or older |
| IRR | IRR(values, [guess]) | Financial | Excel 2003 or older |
| ISBLANK | ISBLANK(value) | Information | Excel 2003 or older |
| ISERR | ISERR(value) | Information | Excel 2003 or older |
| ISERROR | ISERROR(value) | Information | Excel 2003 or older |
| ISEVEN | ISEVEN(number) | Information | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ISFORMULA | ISFORMULA(reference) | Information | Excel 2013 |
| ISLOGICAL | ISLOGICAL(value) | Information | Excel 2003 or older |
| ISNA | ISNA(value) | Information | Excel 2003 or older |
| ISNONTEXT | ISNONTEXT(value) | Information | Excel 2003 or older |
| ISNUMBER | ISNUMBER(value) | Information | Excel 2003 or older |
| ISO.CEILING | ISO.CEILING(number, [significance]) | Math and trigonometry | Excel 2010 |
| ISODD | ISODD(number) | Information | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ISOMITTEDSpills its result across several cells | ISOMITTED(argument) | Information | Excel 2024 and Microsoft 365 |
| ISOWEEKNUM | ISOWEEKNUM(date) | Date and time | Excel 2013 |
| ISPMT | ISPMT(rate, per, nper, pv) | Financial | Excel 2003 or older |
| ISREF | ISREF(value) | Information | Excel 2003 or older |
| ISTEXT | ISTEXT(value) | Information | Excel 2003 or older |
| JIS | JIS(text) | Text | Excel 2003 or older |
| KURT | KURT(number1, [number2], ...) | Statistical | Excel 2003 or older |
| LAMBDASpills its result across several cells | LAMBDA([parameter1, parameter2, ...], calculation) | Logical | Excel 2024 and Microsoft 365 |
| LARGE | LARGE(array, k) | Statistical | Excel 2003 or older |
| LCM | LCM(number1, [number2], ...) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| LEFT | LEFT(text, [num_chars]) | Text | Excel 2003 or older |
| LEFTB | LEFTB(text, [num_bytes]) | Text | Excel 2003 or older |
| LEN | LEN(text) | Text | Excel 2003 or older |
| LENB | LENB(text) | Text | Excel 2003 or older |
| LETSpills its result across several cells | LET(name1, name_value1, [name2, name_value2], ..., calculation) | Logical | Excel 2021 and Microsoft 365 |
| LINESTSpills its result across several cells | LINEST(known_ys, [known_xs], [const], [stats]) | Statistical | Excel 2003 or older |
| LN | LN(number) | Math and trigonometry | Excel 2003 or older |
| LOG | LOG(number, [base]) | Math and trigonometry | Excel 2003 or older |
| LOG10 | LOG10(number) | Math and trigonometry | Excel 2003 or older |
| LOGESTSpills its result across several cells | LOGEST(known_ys, [known_xs], [const], [stats]) | Statistical | Excel 2003 or older |
| LOGINVReplaced by LOGNORM.INV | LOGINV(probability, mean, standard_dev) | Compatibility | Excel 2003 or older |
| LOGNORM.DIST | LOGNORM.DIST(x, mean, standard_dev, cumulative) | Statistical | Excel 2010 |
| LOGNORM.INV | LOGNORM.INV(probability, mean, standard_dev) | Statistical | Excel 2010 |
| LOGNORMDISTReplaced by LOGNORM.DIST | LOGNORMDIST(x, mean, standard_dev) | Compatibility | Excel 2003 or older |
| LOOKUPReplaced by XLOOKUP | LOOKUP(lookup_value, lookup_vector, [result_vector]) | Lookup and reference | Excel 2003 or older |
| LOWER | LOWER(text) | Text | Excel 2003 or older |
| MAKEARRAYSpills its result across several cells | MAKEARRAY(rows, cols, lambda) | Logical | Excel 2024 and Microsoft 365 |
| MAPSpills its result across several cells | MAP(array1, [array2], ..., lambda) | Logical | Excel 2024 and Microsoft 365 |
| MATCHReplaced by XMATCH | MATCH(lookup_value, lookup_array, [match_type]) | Lookup and reference | Excel 2003 or older |
| MAX | MAX(number1, [number2], ...) | Statistical | Excel 2003 or older |
| MAXA | MAXA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| MAXIFS | MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) | Statistical | Excel 2019 |
| MDETERM | MDETERM(array) | Math and trigonometry | Excel 2003 or older |
| MDURATION | MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| MEDIAN | MEDIAN(number1, [number2], ...) | Statistical | Excel 2003 or older |
| MID | MID(text, start_num, num_chars) | Text | Excel 2003 or older |
| MIDB | MIDB(text, start_num, num_bytes) | Text | Excel 2003 or older |
| MIN | MIN(number1, [number2], ...) | Statistical | Excel 2003 or older |
| MINA | MINA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| MINIFS | MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) | Statistical | Excel 2019 |
| MINUTE | MINUTE(serial_number) | Date and time | Excel 2003 or older |
| MINVERSESpills its result across several cells | MINVERSE(array) | Math and trigonometry | Excel 2003 or older |
| MIRR | MIRR(values, finance_rate, reinvest_rate) | Financial | Excel 2003 or older |
| MMULTSpills its result across several cells | MMULT(array1, array2) | Math and trigonometry | Excel 2003 or older |
| MOD | MOD(number, divisor) | Math and trigonometry | Excel 2003 or older |
| MODEReplaced by MODE.SNGL | MODE(number1, [number2], ...) | Compatibility | Excel 2003 or older |
| MODE.MULTSpills its result across several cells | MODE.MULT(number1, [number2], ...) | Statistical | Excel 2010 |
| MODE.SNGL | MODE.SNGL(number1, [number2], ...) | Statistical | Excel 2010 |
| MONTH | MONTH(serial_number) | Date and time | Excel 2003 or older |
| MROUND | MROUND(number, multiple) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| MULTINOMIAL | MULTINOMIAL(number1, [number2], ...) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| MUNITSpills its result across several cells | MUNIT(dimension) | Math and trigonometry | Excel 2013 |
| N | N(value) | Information | Excel 2003 or older |
| NA | NA() | Information | Excel 2003 or older |
| NEGBINOM.DIST | NEGBINOM.DIST(number_f, number_s, probability_s, cumulative) | Statistical | Excel 2010 |
| NEGBINOMDISTReplaced by NEGBINOM.DIST | NEGBINOMDIST(number_f, number_s, probability_s) | Compatibility | Excel 2003 or older |
| NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | Date and time | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) | Date and time | Excel 2010 |
| NOMINAL | NOMINAL(effect_rate, npery) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| NORM.DIST | NORM.DIST(x, mean, standard_dev, cumulative) | Statistical | Excel 2010 |
| NORM.INV | NORM.INV(probability, mean, standard_dev) | Statistical | Excel 2010 |
| NORM.S.DIST | NORM.S.DIST(z, cumulative) | Statistical | Excel 2010 |
| NORM.S.INV | NORM.S.INV(probability) | Statistical | Excel 2010 |
| NORMDISTReplaced by NORM.DIST | NORMDIST(x, mean, standard_dev, cumulative) | Compatibility | Excel 2003 or older |
| NORMINVReplaced by NORM.INV | NORMINV(probability, mean, standard_dev) | Compatibility | Excel 2003 or older |
| NORMSDISTReplaced by NORM.S.DIST | NORMSDIST(z) | Compatibility | Excel 2003 or older |
| NORMSINVReplaced by NORM.S.INV | NORMSINV(probability) | Compatibility | Excel 2003 or older |
| NOT | NOT(logical) | Logical | Excel 2003 or older |
| NOWRecalculates on every change | NOW() | Date and time | Excel 2003 or older |
| NPER | NPER(rate, pmt, pv, [fv], [type]) | Financial | Excel 2003 or older |
| NPV | NPV(rate, value1, [value2], ...) | Financial | Excel 2003 or older |
| NUMBERVALUE | NUMBERVALUE(text, [decimal_separator], [group_separator]) | Text | Excel 2013 |
| OCT2BIN | OCT2BIN(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| OCT2DEC | OCT2DEC(number) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| OCT2HEX | OCT2HEX(number, [places]) | Engineering | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ODD | ODD(number) | Math and trigonometry | Excel 2003 or older |
| ODDFPRICENeeds Excel | ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ODDFYIELDNeeds Excel | ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ODDLPRICENeeds Excel | ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| ODDLYIELD | ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| OFFSETRecalculates on every change | OFFSET(reference, rows, cols, [height], [width]) | Lookup and reference | Excel 2003 or older |
| OR | OR(logical1, [logical2], ...) | Logical | Excel 2003 or older |
| PDURATION | PDURATION(rate, pv, fv) | Financial | Excel 2013 |
| PEARSON | PEARSON(array1, array2) | Statistical | Excel 2003 or older |
| PERCENTILEReplaced by PERCENTILE.INC | PERCENTILE(array, k) | Compatibility | Excel 2003 or older |
| PERCENTILE.EXC | PERCENTILE.EXC(array, k) | Statistical | Excel 2010 |
| PERCENTILE.INC | PERCENTILE.INC(array, k) | Statistical | Excel 2010 |
| PERCENTOFSpills its result across several cells | PERCENTOF(data_subset, data_all) | Math and trigonometry | Microsoft 365 only, not in perpetual Excel editions |
| PERCENTRANKReplaced by PERCENTRANK.INC | PERCENTRANK(array, x, [significance]) | Compatibility | Excel 2003 or older |
| PERCENTRANK.EXC | PERCENTRANK.EXC(array, x, [significance]) | Statistical | Excel 2010 |
| PERCENTRANK.INC | PERCENTRANK.INC(array, x, [significance]) | Statistical | Excel 2010 |
| PERMUT | PERMUT(number, number_chosen) | Statistical | Excel 2003 or older |
| PERMUTATIONA | PERMUTATIONA(number, number_chosen) | Statistical | Excel 2013 |
| PHI | PHI(x) | Statistical | Excel 2013 |
| PHONETICNeeds Excel | PHONETIC(reference) | Text | Excel 2003 or older |
| PI | PI() | Math and trigonometry | Excel 2003 or older |
| PIVOTBYSpills its result across several cellsNeeds Excel | PIVOTBY(row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array], [relative_to]) | Lookup and reference | Microsoft 365 only, not in perpetual Excel editions |
| PMT | PMT(rate, nper, pv, [fv], [type]) | Financial | Excel 2003 or older |
| POISSONReplaced by POISSON.DIST | POISSON(x, mean, cumulative) | Compatibility | Excel 2003 or older |
| POISSON.DIST | POISSON.DIST(x, mean, cumulative) | Statistical | Excel 2010 |
| POWER | POWER(number, power) | Math and trigonometry | Excel 2003 or older |
| PPMT | PPMT(rate, per, nper, pv, [fv], [type]) | Financial | Excel 2003 or older |
| PRICE | PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| PRICEDISC | PRICEDISC(settlement, maturity, discount, redemption, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| PRICEMAT | PRICEMAT(settlement, maturity, issue, rate, yld, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| PROB | PROB(x_range, prob_range, [lower_limit], [upper_limit]) | Statistical | Excel 2003 or older |
| PRODUCT | PRODUCT(number1, [number2], ...) | Math and trigonometry | Excel 2003 or older |
| PROPER | PROPER(text) | Text | Excel 2003 or older |
| PV | PV(rate, nper, pmt, [fv], [type]) | Financial | Excel 2003 or older |
| PYNeeds Excel | PY(python_code, return_type) | Custom functions and linked data types | Microsoft 365 only, not in perpetual Excel editions |
| QUARTILEReplaced by QUARTILE.INC | QUARTILE(array, quart) | Compatibility | Excel 2003 or older |
| QUARTILE.EXC | QUARTILE.EXC(array, quart) | Statistical | Excel 2010 |
| QUARTILE.INC | QUARTILE.INC(array, quart) | Statistical | Excel 2010 |
| QUOTIENT | QUOTIENT(numerator, denominator) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| RADIANS | RADIANS(angle) | Math and trigonometry | Excel 2003 or older |
| RANDRecalculates on every change | RAND() | Math and trigonometry | Excel 2003 or older |
| RANDARRAYRecalculates on every changeSpills its result across several cells | RANDARRAY([rows], [columns], [min], [max], [whole_number]) | Math and trigonometry | Excel 2021 and Microsoft 365 |
| RANDBETWEENRecalculates on every change | RANDBETWEEN(bottom, top) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| RANKReplaced by RANK.EQ | RANK(number, ref, [order]) | Compatibility | Excel 2003 or older |
| RANK.AVG | RANK.AVG(number, ref, [order]) | Statistical | Excel 2010 |
| RANK.EQ | RANK.EQ(number, ref, [order]) | Statistical | Excel 2010 |
| RATE | RATE(nper, pmt, pv, [fv], [type], [guess]) | Financial | Excel 2003 or older |
| RECEIVED | RECEIVED(settlement, maturity, investment, discount, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| REDUCESpills its result across several cells | REDUCE([initial_value], array, lambda) | Logical | Excel 2024 and Microsoft 365 |
| REGEXEXTRACTSpills its result across several cells | REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity]) | Text | Microsoft 365 only, not in perpetual Excel editions |
| REGEXREPLACESpills its result across several cells | REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity]) | Text | Microsoft 365 only, not in perpetual Excel editions |
| REGEXTESTSpills its result across several cells | REGEXTEST(text, pattern, [case_sensitivity]) | Text | Microsoft 365 only, not in perpetual Excel editions |
| REGISTER.IDNeeds Excel | REGISTER.ID(module_text, procedure, [type_text]) | Add-in and automation | Excel 2003 or older |
| REPLACE | REPLACE(old_text, start_num, num_chars, new_text) | Text | Excel 2003 or older |
| REPLACEB | REPLACEB(old_text, start_num, num_bytes, new_text) | Text | Excel 2003 or older |
| REPT | REPT(text, number_times) | Text | Excel 2003 or older |
| RIGHT | RIGHT(text, [num_chars]) | Text | Excel 2003 or older |
| RIGHTB | RIGHTB(text, [num_bytes]) | Text | Excel 2003 or older |
| ROMAN | ROMAN(number, [form]) | Math and trigonometry | Excel 2003 or older |
| ROUND | ROUND(number, num_digits) | Math and trigonometry | Excel 2003 or older |
| ROUNDDOWN | ROUNDDOWN(number, num_digits) | Math and trigonometry | Excel 2003 or older |
| ROUNDUP | ROUNDUP(number, num_digits) | Math and trigonometry | Excel 2003 or older |
| ROW | ROW([reference]) | Lookup and reference | Excel 2003 or older |
| ROWS | ROWS(array) | Lookup and reference | Excel 2003 or older |
| RRI | RRI(nper, pv, fv) | Financial | Excel 2013 |
| RSQ | RSQ(known_ys, known_xs) | Statistical | Excel 2003 or older |
| RTDRecalculates on every changeNeeds Excel | RTD(ProgID, server, topic1, [topic2], ...) | Lookup and reference | Excel 2003 or older |
| SCANSpills its result across several cells | SCAN([initial_value], array, lambda) | Logical | Excel 2024 and Microsoft 365 |
| SEARCH | SEARCH(find_text, within_text, [start_num]) | Text | Excel 2003 or older |
| SEARCHB | SEARCHB(find_text, within_text, [start_num]) | Text | Excel 2003 or older |
| SEC | SEC(number) | Math and trigonometry | Excel 2013 |
| SECH | SECH(number) | Math and trigonometry | Excel 2013 |
| SECOND | SECOND(serial_number) | Date and time | Excel 2003 or older |
| SEQUENCESpills its result across several cells | SEQUENCE(rows, [columns], [start], [step]) | Math and trigonometry | Excel 2021 and Microsoft 365 |
| SERIESSUM | SERIESSUM(x, n, m, coefficients) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| SHEETNeeds Excel | SHEET([value]) | Information | Excel 2013 |
| SHEETSNeeds Excel | SHEETS([reference]) | Information | Excel 2013 |
| SIGN | SIGN(number) | Math and trigonometry | Excel 2003 or older |
| SIN | SIN(number) | Math and trigonometry | Excel 2003 or older |
| SINH | SINH(number) | Math and trigonometry | Excel 2003 or older |
| SKEW | SKEW(number1, [number2], ...) | Statistical | Excel 2003 or older |
| SKEW.P | SKEW.P(number1, [number2], ...) | Statistical | Excel 2013 |
| SLN | SLN(cost, salvage, life) | Financial | Excel 2003 or older |
| SLOPE | SLOPE(known_ys, known_xs) | Statistical | Excel 2003 or older |
| SMALL | SMALL(array, k) | Statistical | Excel 2003 or older |
| SORTSpills its result across several cells | SORT(array, [sort_index], [sort_order], [by_col]) | Lookup and reference | Excel 2021 and Microsoft 365 |
| SORTBYSpills its result across several cells | SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2], ...) | Lookup and reference | Excel 2021 and Microsoft 365 |
| SQRT | SQRT(number) | Math and trigonometry | Excel 2003 or older |
| SQRTPI | SQRTPI(number) | Math and trigonometry | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| STANDARDIZE | STANDARDIZE(x, mean, standard_dev) | Statistical | Excel 2003 or older |
| STDEVReplaced by STDEV.S | STDEV(number1, [number2], ...) | Compatibility | Excel 2003 or older |
| STDEV.P | STDEV.P(number1, [number2], ...) | Statistical | Excel 2010 |
| STDEV.S | STDEV.S(number1, [number2], ...) | Statistical | Excel 2010 |
| STDEVA | STDEVA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| STDEVPReplaced by STDEV.P | STDEVP(number1, [number2], ...) | Compatibility | Excel 2003 or older |
| STDEVPA | STDEVPA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| STEYX | STEYX(known_ys, known_xs) | Statistical | Excel 2003 or older |
| STOCKHISTORYSpills its result across several cellsNeeds Excel | STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], ...) | Information | Microsoft 365 only, not in perpetual Excel editions |
| SUBSTITUTE | SUBSTITUTE(text, old_text, new_text, [instance_num]) | Text | Excel 2003 or older |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2], ...) | Math and trigonometry | Excel 2003 or older |
| SUM | SUM(number1, [number2], ...) | Math and trigonometry | Excel 2003 or older |
| SUMIF | SUMIF(range, criteria, [sum_range]) | Math and trigonometry | Excel 2003 or older |
| SUMIFS | SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) | Math and trigonometry | Excel 2007 |
| SUMPRODUCT | SUMPRODUCT(array1, [array2], ...) | Math and trigonometry | Excel 2003 or older |
| SUMSQ | SUMSQ(number1, [number2], ...) | Math and trigonometry | Excel 2003 or older |
| SUMX2MY2 | SUMX2MY2(array_x, array_y) | Math and trigonometry | Excel 2003 or older |
| SUMX2PY2 | SUMX2PY2(array_x, array_y) | Math and trigonometry | Excel 2003 or older |
| SUMXMY2 | SUMXMY2(array_x, array_y) | Math and trigonometry | Excel 2003 or older |
| SWITCH | SWITCH(expression, value1, result1, [default_or_value2], [result2], ...) | Logical | Excel 2019 |
| SYD | SYD(cost, salvage, life, per) | Financial | Excel 2003 or older |
| T | T(value) | Text | Excel 2003 or older |
| T.DIST | T.DIST(x, deg_freedom, cumulative) | Statistical | Excel 2010 |
| T.DIST.2T | T.DIST.2T(x, deg_freedom) | Statistical | Excel 2010 |
| T.DIST.RT | T.DIST.RT(x, deg_freedom) | Statistical | Excel 2010 |
| T.INV | T.INV(probability, deg_freedom) | Statistical | Excel 2010 |
| T.INV.2T | T.INV.2T(probability, deg_freedom) | Statistical | Excel 2010 |
| T.TEST | T.TEST(array1, array2, tails, type) | Statistical | Excel 2010 |
| TAKESpills its result across several cells | TAKE(array, rows, [columns]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| TAN | TAN(number) | Math and trigonometry | Excel 2003 or older |
| TANH | TANH(number) | Math and trigonometry | Excel 2003 or older |
| TBILLEQ | TBILLEQ(settlement, maturity, discount) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| TBILLPRICE | TBILLPRICE(settlement, maturity, discount) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| TBILLYIELD | TBILLYIELD(settlement, maturity, pr) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| TDISTReplaced by T.DIST.2T atau T.DIST.RT | TDIST(x, deg_freedom, tails) | Compatibility | Excel 2003 or older |
| TEXT | TEXT(value, format_text) | Text | Excel 2003 or older |
| TEXTAFTERSpills its result across several cells | TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]) | Text | Excel 2024 and Microsoft 365 |
| TEXTBEFORESpills its result across several cells | TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]) | Text | Excel 2024 and Microsoft 365 |
| TEXTJOIN | TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) | Text | Excel 2019 |
| TEXTSPLITSpills its result across several cells | TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]) | Text | Excel 2024 and Microsoft 365 |
| TIME | TIME(hour, minute, second) | Date and time | Excel 2003 or older |
| TIMEVALUE | TIMEVALUE(time_text) | Date and time | Excel 2003 or older |
| TINVReplaced by T.INV.2T | TINV(probability, deg_freedom) | Compatibility | Excel 2003 or older |
| TOCOLSpills its result across several cells | TOCOL(array, [ignore], [scan_by_column]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| TODAYRecalculates on every change | TODAY() | Date and time | Excel 2003 or older |
| TOROWSpills its result across several cells | TOROW(array, [ignore], [scan_by_column]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| TRANSLATENeeds Excel | TRANSLATE(text, [source_language], [target_language]) | Text | Microsoft 365 only, not in perpetual Excel editions |
| TRANSPOSESpills its result across several cells | TRANSPOSE(array) | Lookup and reference | Excel 2003 or older |
| TRENDSpills its result across several cells | TREND(known_ys, [known_xs], [new_xs], [const]) | Statistical | Excel 2003 or older |
| TRIM | TRIM(text) | Text | Excel 2003 or older |
| TRIMMEAN | TRIMMEAN(array, percent) | Statistical | Excel 2003 or older |
| TRIMRANGESpills its result across several cellsNeeds Excel | TRIMRANGE(range, [trim_rows], [trim_cols]) | Lookup and reference | Microsoft 365 only, not in perpetual Excel editions |
| TRUE | TRUE() | Logical | Excel 2003 or older |
| TRUNC | TRUNC(number, [num_digits]) | Math and trigonometry | Excel 2003 or older |
| TTESTReplaced by T.TEST | TTEST(array1, array2, tails, type) | Compatibility | Excel 2003 or older |
| TYPE | TYPE(value) | Information | Excel 2003 or older |
| UNICHAR | UNICHAR(number) | Text | Excel 2013 |
| UNICODE | UNICODE(text) | Text | Excel 2013 |
| UNIQUESpills its result across several cells | UNIQUE(array, [by_col], [exactly_once]) | Lookup and reference | Excel 2021 and Microsoft 365 |
| UPPER | UPPER(text) | Text | Excel 2003 or older |
| VALUE | VALUE(text) | Text | Excel 2003 or older |
| VALUETOTEXTSpills its result across several cells | VALUETOTEXT(value, [format]) | Text | Excel 2024 and Microsoft 365 |
| VARReplaced by VAR.S | VAR(number1, [number2], ...) | Compatibility | Excel 2003 or older |
| VAR.P | VAR.P(number1, [number2], ...) | Statistical | Excel 2010 |
| VAR.S | VAR.S(number1, [number2], ...) | Statistical | Excel 2010 |
| VARA | VARA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| VARPReplaced by VAR.P | VARP(number1, [number2], ...) | Compatibility | Excel 2003 or older |
| VARPA | VARPA(value1, [value2], ...) | Statistical | Excel 2003 or older |
| VDB | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) | Financial | Excel 2003 or older |
| VLOOKUPReplaced by XLOOKUP | VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) | Lookup and reference | Excel 2003 or older |
| VSTACKSpills its result across several cells | VSTACK(array1, [array2], ...) | Lookup and reference | Excel 2024 and Microsoft 365 |
| WEBSERVICERecalculates on every changeNeeds Excel | WEBSERVICE(url) | Web | Excel 2013 |
| WEEKDAY | WEEKDAY(serial_number, [return_type]) | Date and time | Excel 2003 or older |
| WEEKNUM | WEEKNUM(serial_number, [return_type]) | Date and time | Excel 2003 or older |
| WEIBULLReplaced by WEIBULL.DIST | WEIBULL(x, alpha, beta, cumulative) | Compatibility | Excel 2003 or older |
| WEIBULL.DIST | WEIBULL.DIST(x, alpha, beta, cumulative) | Statistical | Excel 2010 |
| WORKDAY | WORKDAY(start_date, days, [holidays]) | Date and time | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| WORKDAY.INTL | WORKDAY.INTL(start_date, days, [weekend], [holidays]) | Date and time | Excel 2010 |
| WRAPCOLSSpills its result across several cells | WRAPCOLS(vector, wrap_count, [pad_with]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| WRAPROWSSpills its result across several cells | WRAPROWS(vector, wrap_count, [pad_with]) | Lookup and reference | Excel 2024 and Microsoft 365 |
| XIRR | XIRR(values, dates, [guess]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| XLOOKUPSpills its result across several cells | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Lookup and reference | Excel 2021 and Microsoft 365 |
| XMATCHSpills its result across several cells | XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) | Lookup and reference | Excel 2021 and Microsoft 365 |
| XNPV | XNPV(rate, values, dates) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| XOR | XOR(logical1, [logical2], ...) | Logical | Excel 2013 |
| YEAR | YEAR(serial_number) | Date and time | Excel 2003 or older |
| YEARFRAC | YEARFRAC(start_date, end_date, [basis]) | Date and time | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| YIELD | YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| YIELDDISC | YIELDDISC(settlement, maturity, pr, redemption, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| YIELDMAT | YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) | Financial | Excel 2007 (previously an Analysis ToolPak add-in in Excel 2003) |
| Z.TEST | Z.TEST(array, x, [sigma]) | Statistical | Excel 2010 |
| ZTESTReplaced by Z.TEST | ZTEST(array, x, [sigma]) | Compatibility | Excel 2003 or older |
