Daftar fungsi Excel
Semuanya dalam satu tabel: nama, kategori, sintaks, dan sejak versi berapa ada.
Pemisah argumen
Excel memakai titik koma di wilayah yang menulis desimal dengan koma, dan koma di wilayah yang memakai titik. Ubah di sini kalau rumusnya ditolak saat ditempel.
SUM(A1; A2)
524 fungsi
| Fungsi | Sintaks | Kategori | Tersedia sejak |
|---|---|---|---|
| ABS | ABS(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ACCRINT | ACCRINT(issue; first_interest; settlement; rate; par; frequency; [basis]; [calc_method]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ACCRINTM | ACCRINTM(issue; settlement; rate; par; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ACOS | ACOS(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ACOSH | ACOSH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ACOT | ACOT(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| ACOTH | ACOTH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| ADDRESS | ADDRESS(row_num; column_num; [abs_num]; [a1]; [sheet_text]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| AGGREGATE | AGGREGATE(function_num; options; ref1; [ref2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2010 |
| AMORDEGRC | AMORDEGRC(cost; date_purchased; first_period; salvage; period; rate; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| AMORLINC | AMORLINC(cost; date_purchased; first_period; salvage; period; rate; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| AND | AND(logical1; [logical2]; ...) | Logika (Logical) | Excel 2003 atau lebih lama |
| ARABIC | ARABIC(text) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| AREAS | AREAS(reference) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| ARRAYTOTEXTMenumpahkan hasil ke banyak sel | ARRAYTOTEXT(array; [format]) | Teks (Text) | Excel 2024 dan Microsoft 365 |
| ASC | ASC(text) | Teks (Text) | Excel 2003 atau lebih lama |
| ASIN | ASIN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ASINH | ASINH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ATAN | ATAN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ATAN2 | ATAN2(x_num; y_num) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ATANH | ATANH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| AVEDEV | AVEDEV(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| AVERAGE | AVERAGE(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| AVERAGEA | AVERAGEA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| AVERAGEIF | AVERAGEIF(range; criteria; [average_range]) | Statistik (Statistical) | Excel 2007 |
| AVERAGEIFS | AVERAGEIFS(average_range; criteria_range1; criteria1; [criteria_range2; criteria2]; ...) | Statistik (Statistical) | Excel 2007 |
| BAHTTEXTPerlu Excel | BAHTTEXT(number) | Teks (Text) | Excel 2003 atau lebih lama |
| BASE | BASE(number; radix; [min_length]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| BESSELI | BESSELI(x; n) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BESSELJ | BESSELJ(x; n) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BESSELK | BESSELK(x; n) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BESSELY | BESSELY(x; n) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BETA.DIST | BETA.DIST(x; alpha; beta; cumulative; [A]; [B]) | Statistik (Statistical) | Excel 2010 |
| BETA.INV | BETA.INV(probability; alpha; beta; [A]; [B]) | Statistik (Statistical) | Excel 2010 |
| BETADISTDigantikan BETA.DIST | BETADIST(x; alpha; beta; [A]; [B]) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| BETAINVDigantikan BETA.INV | BETAINV(probability; alpha; beta; [A]; [B]) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| BIN2DEC | BIN2DEC(number) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BIN2HEX | BIN2HEX(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BIN2OCT | BIN2OCT(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| BINOM.DIST | BINOM.DIST(number_s; trials; probability_s; cumulative) | Statistik (Statistical) | Excel 2010 |
| BINOM.DIST.RANGE | BINOM.DIST.RANGE(trials; probability_s; number_s; [number_s2]) | Statistik (Statistical) | Excel 2013 |
| BINOM.INV | BINOM.INV(trials; probability_s; alpha) | Statistik (Statistical) | Excel 2010 |
| BINOMDISTDigantikan BINOM.DIST | BINOMDIST(number_s; trials; probability_s; cumulative) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| BITAND | BITAND(number1; number2) | Teknik (Engineering) | Excel 2013 |
| BITLSHIFT | BITLSHIFT(number; shift_amount) | Teknik (Engineering) | Excel 2013 |
| BITOR | BITOR(number1; number2) | Teknik (Engineering) | Excel 2013 |
| BITRSHIFT | BITRSHIFT(number; shift_amount) | Teknik (Engineering) | Excel 2013 |
| BITXOR | BITXOR(number1; number2) | Teknik (Engineering) | Excel 2013 |
| BYCOLMenumpahkan hasil ke banyak sel | BYCOL(array; lambda) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| BYROWMenumpahkan hasil ke banyak sel | BYROW(array; lambda) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| CALLPerlu Excel | CALL(register_id; [argument1]; ...) | Add-in dan otomatisasi | Excel 2003 atau lebih lama |
| CEILINGDigantikan CEILING.MATH | CEILING(number; significance) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| CEILING.MATH | CEILING.MATH(number; [significance]; [mode]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| CEILING.PRECISE | CEILING.PRECISE(number; [significance]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2010 |
| CELLDihitung ulang terus-menerusPerlu Excel | CELL(info_type; [reference]) | Informasi (Information) | Excel 2003 atau lebih lama |
| CHAR | CHAR(number) | Teks (Text) | Excel 2003 atau lebih lama |
| CHIDISTDigantikan CHISQ.DIST.RT | CHIDIST(x; deg_freedom) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| CHIINVDigantikan CHISQ.INV.RT | CHIINV(probability; deg_freedom) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| CHISQ.DIST | CHISQ.DIST(x; deg_freedom; cumulative) | Statistik (Statistical) | Excel 2010 |
| CHISQ.DIST.RT | CHISQ.DIST.RT(x; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| CHISQ.INV | CHISQ.INV(probability; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| CHISQ.INV.RT | CHISQ.INV.RT(probability; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| CHISQ.TEST | CHISQ.TEST(actual_range; expected_range) | Statistik (Statistical) | Excel 2010 |
| CHITESTDigantikan CHISQ.TEST | CHITEST(actual_range; expected_range) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| CHOOSE | CHOOSE(index_num; value1; [value2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| CHOOSECOLSMenumpahkan hasil ke banyak sel | CHOOSECOLS(array; col_num1; [col_num2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| CHOOSEROWSMenumpahkan hasil ke banyak sel | CHOOSEROWS(array; row_num1; [row_num2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| CLEAN | CLEAN(text) | Teks (Text) | Excel 2003 atau lebih lama |
| CODE | CODE(text) | Teks (Text) | Excel 2003 atau lebih lama |
| COLUMN | COLUMN([reference]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| COLUMNS | COLUMNS(array) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| COMBIN | COMBIN(number; number_chosen) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| COMBINA | COMBINA(number; number_chosen) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| COMPLEX | COMPLEX(real_num; i_num; [suffix]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| CONCATDigantikan CONCATENATE | CONCAT(text1; [text2]; ...) | Teks (Text) | Excel 2019 |
| CONCATENATEDigantikan CONCAT atau TEXTJOIN | CONCATENATE(text1; [text2]; ...) | Teks (Text) | Excel 2003 atau lebih lama |
| CONFIDENCEDigantikan CONFIDENCE.NORM | CONFIDENCE(alpha; standard_dev; size) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| CONFIDENCE.NORM | CONFIDENCE.NORM(alpha; standard_dev; size) | Statistik (Statistical) | Excel 2010 |
| CONFIDENCE.T | CONFIDENCE.T(alpha; standard_dev; size) | Statistik (Statistical) | Excel 2010 |
| CONVERT | CONVERT(number; from_unit; to_unit) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COPILOTDihitung ulang terus-menerusPerlu ExcelDigantikan Copilot di panel samping | COPILOT(prompt_part1; [context1]; [prompt_part2]; [context2]; ...) | Fungsi khusus dan tipe data tertaut | Microsoft 365 saja, belum ada di Excel edisi abadi |
| CORREL | CORREL(array1; array2) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| COS | COS(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| COSH | COSH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| COT | COT(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| COTH | COTH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| COUNT | COUNT(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| COUNTA | COUNTA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| COUNTBLANK | COUNTBLANK(range) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| COUNTIF | COUNTIF(range; criteria) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| COUNTIFS | COUNTIFS(criteria_range1; criteria1; [criteria_range2; criteria2]; ...) | Statistik (Statistical) | Excel 2007 |
| COUPDAYBS | COUPDAYBS(settlement; maturity; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COUPDAYS | COUPDAYS(settlement; maturity; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COUPDAYSNC | COUPDAYSNC(settlement; maturity; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COUPNCD | COUPNCD(settlement; maturity; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COUPNUM | COUPNUM(settlement; maturity; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COUPPCD | COUPPCD(settlement; maturity; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| COVARDigantikan COVARIANCE.P | COVAR(array1; array2) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| COVARIANCE.P | COVARIANCE.P(array1; array2) | Statistik (Statistical) | Excel 2010 |
| COVARIANCE.S | COVARIANCE.S(array1; array2) | Statistik (Statistical) | Excel 2010 |
| CRITBINOMDigantikan BINOM.INV | CRITBINOM(trials; probability_s; alpha) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| CSC | CSC(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| CSCH | CSCH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| CUBEKPIMEMBERPerlu Excel | CUBEKPIMEMBER(connection; kpi_name; kpi_property; [caption]) | Kubus (Cube) | Excel 2007 |
| CUBEMEMBERPerlu Excel | CUBEMEMBER(connection; member_expression; [caption]) | Kubus (Cube) | Excel 2007 |
| CUBEMEMBERPROPERTYPerlu Excel | CUBEMEMBERPROPERTY(connection; member_expression; property) | Kubus (Cube) | Excel 2007 |
| CUBERANKEDMEMBERPerlu Excel | CUBERANKEDMEMBER(connection; set_expression; rank; [caption]) | Kubus (Cube) | Excel 2007 |
| CUBESETPerlu Excel | CUBESET(connection; set_expression; [caption]; [sort_order]; [sort_by]) | Kubus (Cube) | Excel 2007 |
| CUBESETCOUNTPerlu Excel | CUBESETCOUNT(set) | Kubus (Cube) | Excel 2007 |
| CUBEVALUEPerlu Excel | CUBEVALUE(connection; [member_expression1]; [member_expression2]; ...) | Kubus (Cube) | Excel 2007 |
| CUMIPMT | CUMIPMT(rate; nper; pv; start_period; end_period; type) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| CUMPRINC | CUMPRINC(rate; nper; pv; start_period; end_period; type) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DATE | DATE(year; month; day) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| DATEDIF | DATEDIF(start_date; end_date; unit) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| DATEVALUE | DATEVALUE(date_text) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| DAVERAGE | DAVERAGE(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DAY | DAY(serial_number) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| DAYS | DAYS(end_date; start_date) | Tanggal dan waktu (Date and time) | Excel 2013 |
| DAYS360 | DAYS360(start_date; end_date; [method]) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| DB | DB(cost; salvage; life; period; [month]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| DBCS | DBCS(text) | Teks (Text) | Excel 2013 |
| DCOUNT | DCOUNT(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DCOUNTA | DCOUNTA(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DDB | DDB(cost; salvage; life; period; [factor]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| DEC2BIN | DEC2BIN(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DEC2HEX | DEC2HEX(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DEC2OCT | DEC2OCT(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DECIMAL | DECIMAL(text; radix) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| DEGREES | DEGREES(angle) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| DELTA | DELTA(number1; [number2]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DETECTLANGUAGEPerlu Excel | DETECTLANGUAGE(text) | Teks (Text) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| DEVSQ | DEVSQ(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| DGET | DGET(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DISC | DISC(settlement; maturity; pr; redemption; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DMAX | DMAX(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DMIN | DMIN(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DOLLAR | DOLLAR(number; [decimals]) | Teks (Text) | Excel 2003 atau lebih lama |
| DOLLARDE | DOLLARDE(fractional_dollar; fraction) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DOLLARFR | DOLLARFR(decimal_dollar; fraction) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DPRODUCT | DPRODUCT(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DROPMenumpahkan hasil ke banyak sel | DROP(array; rows; [columns]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| DSTDEV | DSTDEV(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DSTDEVP | DSTDEVP(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DSUM | DSUM(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DURATION | DURATION(settlement; maturity; coupon; yld; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| DVAR | DVAR(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| DVARP | DVARP(database; field; criteria) | Database | Excel 2003 atau lebih lama |
| EDATE | EDATE(start_date; months) | Tanggal dan waktu (Date and time) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| EFFECT | EFFECT(nominal_rate; npery) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ENCODEURL | ENCODEURL(text) | Web | Excel 2013 |
| EOMONTH | EOMONTH(start_date; months) | Tanggal dan waktu (Date and time) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ERF | ERF(lower_limit; [upper_limit]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ERF.PRECISE | ERF.PRECISE(x) | Teknik (Engineering) | Excel 2010 |
| ERFC | ERFC(x) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ERFC.PRECISE | ERFC.PRECISE(x) | Teknik (Engineering) | Excel 2010 |
| ERROR.TYPE | ERROR.TYPE(error_val) | Informasi (Information) | Excel 2003 atau lebih lama |
| EUROCONVERTPerlu Excel | EUROCONVERT(number; source; target; [full_precision]; [triangulation_precision]) | Add-in dan otomatisasi | Excel 2003 atau lebih lama |
| EVEN | EVEN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| EXACT | EXACT(text1; text2) | Teks (Text) | Excel 2003 atau lebih lama |
| EXP | EXP(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| EXPANDMenumpahkan hasil ke banyak sel | EXPAND(array; rows; [columns]; [pad_with]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| EXPON.DIST | EXPON.DIST(x; lambda; cumulative) | Statistik (Statistical) | Excel 2010 |
| EXPONDISTDigantikan EXPON.DIST | EXPONDIST(x; lambda; cumulative) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| F.DIST | F.DIST(x; deg_freedom1; deg_freedom2; cumulative) | Statistik (Statistical) | Excel 2010 |
| F.DIST.RT | F.DIST.RT(x; deg_freedom1; deg_freedom2) | Statistik (Statistical) | Excel 2010 |
| F.INV | F.INV(probability; deg_freedom1; deg_freedom2) | Statistik (Statistical) | Excel 2010 |
| F.INV.RT | F.INV.RT(probability; deg_freedom1; deg_freedom2) | Statistik (Statistical) | Excel 2010 |
| F.TEST | F.TEST(array1; array2) | Statistik (Statistical) | Excel 2010 |
| FACT | FACT(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| FACTDOUBLE | FACTDOUBLE(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| FALSE | FALSE() | Logika (Logical) | Excel 2003 atau lebih lama |
| FDISTDigantikan F.DIST.RT | FDIST(x; deg_freedom1; deg_freedom2) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| FIELDVALUEPerlu Excel | FIELDVALUE(value; field_name) | Pencarian dan referensi (Lookup and reference) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| FILTERMenumpahkan hasil ke banyak sel | FILTER(array; include; [if_empty]) | Pencarian dan referensi (Lookup and reference) | Excel 2021 dan Microsoft 365 |
| FILTERXMLPerlu Excel | FILTERXML(xml; xpath) | Web | Excel 2013 |
| FIND | FIND(find_text; within_text; [start_num]) | Teks (Text) | Excel 2003 atau lebih lama |
| FINDB | FINDB(find_text; within_text; [start_num]) | Teks (Text) | Excel 2003 atau lebih lama |
| FINVDigantikan F.INV.RT | FINV(probability; deg_freedom1; deg_freedom2) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| FISHER | FISHER(x) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| FISHERINV | FISHERINV(y) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| FIXED | FIXED(number; [decimals]; [no_commas]) | Teks (Text) | Excel 2003 atau lebih lama |
| FLOORDigantikan FLOOR.MATH | FLOOR(number; significance) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| FLOOR.MATH | FLOOR.MATH(number; [significance]; [mode]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| FLOOR.PRECISE | FLOOR.PRECISE(number; [significance]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2010 |
| FORECASTDigantikan FORECAST.LINEAR | FORECAST(x; known_ys; known_xs) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| FORECAST.ETSPerlu Excel | FORECAST.ETS(target_date; values; timeline; [seasonality]; [data_completion]; [aggregation]) | Statistik (Statistical) | Excel 2016 |
| FORECAST.ETS.CONFINTPerlu Excel | FORECAST.ETS.CONFINT(target_date; values; timeline; [confidence_level]; [seasonality]; [data_completion]; [aggregation]) | Statistik (Statistical) | Excel 2016 |
| FORECAST.ETS.SEASONALITYPerlu Excel | FORECAST.ETS.SEASONALITY(values; timeline; [data_completion]; [aggregation]) | Statistik (Statistical) | Excel 2016 |
| FORECAST.ETS.STATPerlu Excel | FORECAST.ETS.STAT(values; timeline; statistic_type; [seasonality]; [data_completion]; [aggregation]) | Statistik (Statistical) | Excel 2016 |
| FORECAST.LINEAR | FORECAST.LINEAR(x; known_ys; known_xs) | Statistik (Statistical) | Excel 2016 |
| FORMULATEXT | FORMULATEXT(reference) | Pencarian dan referensi (Lookup and reference) | Excel 2013 |
| FREQUENCYMenumpahkan hasil ke banyak sel | FREQUENCY(data_array; bins_array) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| FTESTDigantikan F.TEST | FTEST(array1; array2) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| FV | FV(rate; nper; pmt; [pv]; [type]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| FVSCHEDULE | FVSCHEDULE(principal; schedule) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| GAMMA | GAMMA(x) | Statistik (Statistical) | Excel 2013 |
| GAMMA.DIST | GAMMA.DIST(x; alpha; beta; cumulative) | Statistik (Statistical) | Excel 2010 |
| GAMMA.INV | GAMMA.INV(probability; alpha; beta) | Statistik (Statistical) | Excel 2010 |
| GAMMADISTDigantikan GAMMA.DIST | GAMMADIST(x; alpha; beta; cumulative) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| GAMMAINVDigantikan GAMMA.INV | GAMMAINV(probability; alpha; beta) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| GAMMALN | GAMMALN(x) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| GAMMALN.PRECISE | GAMMALN.PRECISE(x) | Statistik (Statistical) | Excel 2010 |
| GAUSS | GAUSS(z) | Statistik (Statistical) | Excel 2013 |
| GCD | GCD(number1; [number2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| GEOMEAN | GEOMEAN(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| GESTEP | GESTEP(number; [step]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| GETPIVOTDATAPerlu Excel | GETPIVOTDATA(data_field; pivot_table; [field1; item1]; [field2; item2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| GROUPBYMenumpahkan hasil ke banyak selPerlu Excel | GROUPBY(row_fields; values; function; [field_headers]; [total_depth]; [sort_order]; [filter_array]; [field_relationship]) | Pencarian dan referensi (Lookup and reference) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| GROWTHMenumpahkan hasil ke banyak sel | GROWTH(known_ys; [known_xs]; [new_xs]; [const]) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| HARMEAN | HARMEAN(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| HEX2BIN | HEX2BIN(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| HEX2DEC | HEX2DEC(number) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| HEX2OCT | HEX2OCT(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| HLOOKUPDigantikan XLOOKUP | HLOOKUP(lookup_value; table_array; row_index_num; [range_lookup]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| HOUR | HOUR(serial_number) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| HSTACKMenumpahkan hasil ke banyak sel | HSTACK(array1; [array2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| HYPERLINKPerlu Excel | HYPERLINK(link_location; [friendly_name]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| HYPGEOM.DIST | HYPGEOM.DIST(sample_s; number_sample; population_s; number_pop; cumulative) | Statistik (Statistical) | Excel 2010 |
| HYPGEOMDISTDigantikan HYPGEOM.DIST | HYPGEOMDIST(sample_s; number_sample; population_s; number_pop) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| IF | IF(logical_test; [value_if_true]; [value_if_false]) | Logika (Logical) | Excel 2003 atau lebih lama |
| IFERROR | IFERROR(value; value_if_error) | Logika (Logical) | Excel 2007 |
| IFNA | IFNA(value; value_if_na) | Logika (Logical) | Excel 2013 |
| IFS | IFS(logical_test1; value_if_true1; [logical_test2; value_if_true2]; ...) | Logika (Logical) | Excel 2019 |
| IMABS | IMABS(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMAGEMenumpahkan hasil ke banyak selPerlu Excel | IMAGE(source; [alt_text]; [sizing]; [height]; [width]) | Pencarian dan referensi (Lookup and reference) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| IMAGINARY | IMAGINARY(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMARGUMENT | IMARGUMENT(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMCONJUGATE | IMCONJUGATE(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMCOS | IMCOS(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMCOSH | IMCOSH(inumber) | Teknik (Engineering) | Excel 2013 |
| IMCOT | IMCOT(inumber) | Teknik (Engineering) | Excel 2013 |
| IMCSC | IMCSC(inumber) | Teknik (Engineering) | Excel 2013 |
| IMCSCH | IMCSCH(inumber) | Teknik (Engineering) | Excel 2013 |
| IMDIV | IMDIV(inumber1; inumber2) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMEXP | IMEXP(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMLN | IMLN(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMLOG10 | IMLOG10(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMLOG2 | IMLOG2(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMPOWER | IMPOWER(inumber; number) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMPRODUCT | IMPRODUCT(inumber1; [inumber2]; ...) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMREAL | IMREAL(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMSEC | IMSEC(inumber) | Teknik (Engineering) | Excel 2013 |
| IMSECH | IMSECH(inumber) | Teknik (Engineering) | Excel 2013 |
| IMSIN | IMSIN(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMSINH | IMSINH(inumber) | Teknik (Engineering) | Excel 2013 |
| IMSQRT | IMSQRT(inumber) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMSUB | IMSUB(inumber1; inumber2) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMSUM | IMSUM(inumber1; [inumber2]; ...) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IMTAN | IMTAN(inumber) | Teknik (Engineering) | Excel 2013 |
| INDEX | INDEX(array; row_num; [column_num]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| INDIRECTDihitung ulang terus-menerus | INDIRECT(ref_text; [a1]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| INFODihitung ulang terus-menerusPerlu Excel | INFO(type_text) | Informasi (Information) | Excel 2003 atau lebih lama |
| INT | INT(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| INTERCEPT | INTERCEPT(known_ys; known_xs) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| INTRATE | INTRATE(settlement; maturity; investment; redemption; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| IPMT | IPMT(rate; per; nper; pv; [fv]; [type]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| IRR | IRR(values; [guess]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| ISBLANK | ISBLANK(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISERR | ISERR(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISERROR | ISERROR(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISEVEN | ISEVEN(number) | Informasi (Information) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ISFORMULA | ISFORMULA(reference) | Informasi (Information) | Excel 2013 |
| ISLOGICAL | ISLOGICAL(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISNA | ISNA(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISNONTEXT | ISNONTEXT(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISNUMBER | ISNUMBER(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISO.CEILING | ISO.CEILING(number; [significance]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2010 |
| ISODD | ISODD(number) | Informasi (Information) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ISOMITTEDMenumpahkan hasil ke banyak sel | ISOMITTED(argument) | Informasi (Information) | Excel 2024 dan Microsoft 365 |
| ISOWEEKNUM | ISOWEEKNUM(date) | Tanggal dan waktu (Date and time) | Excel 2013 |
| ISPMT | ISPMT(rate; per; nper; pv) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| ISREF | ISREF(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| ISTEXT | ISTEXT(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| JIS | JIS(text) | Teks (Text) | Excel 2003 atau lebih lama |
| KURT | KURT(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| LAMBDAMenumpahkan hasil ke banyak sel | LAMBDA([parameter1; parameter2; ...]; calculation) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| LARGE | LARGE(array; k) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| LCM | LCM(number1; [number2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| LEFT | LEFT(text; [num_chars]) | Teks (Text) | Excel 2003 atau lebih lama |
| LEFTB | LEFTB(text; [num_bytes]) | Teks (Text) | Excel 2003 atau lebih lama |
| LEN | LEN(text) | Teks (Text) | Excel 2003 atau lebih lama |
| LENB | LENB(text) | Teks (Text) | Excel 2003 atau lebih lama |
| LETMenumpahkan hasil ke banyak sel | LET(name1; name_value1; [name2; name_value2]; ...; calculation) | Logika (Logical) | Excel 2021 dan Microsoft 365 |
| LINESTMenumpahkan hasil ke banyak sel | LINEST(known_ys; [known_xs]; [const]; [stats]) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| LN | LN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| LOG | LOG(number; [base]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| LOG10 | LOG10(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| LOGESTMenumpahkan hasil ke banyak sel | LOGEST(known_ys; [known_xs]; [const]; [stats]) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| LOGINVDigantikan LOGNORM.INV | LOGINV(probability; mean; standard_dev) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| LOGNORM.DIST | LOGNORM.DIST(x; mean; standard_dev; cumulative) | Statistik (Statistical) | Excel 2010 |
| LOGNORM.INV | LOGNORM.INV(probability; mean; standard_dev) | Statistik (Statistical) | Excel 2010 |
| LOGNORMDISTDigantikan LOGNORM.DIST | LOGNORMDIST(x; mean; standard_dev) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| LOOKUPDigantikan XLOOKUP | LOOKUP(lookup_value; lookup_vector; [result_vector]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| LOWER | LOWER(text) | Teks (Text) | Excel 2003 atau lebih lama |
| MAKEARRAYMenumpahkan hasil ke banyak sel | MAKEARRAY(rows; cols; lambda) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| MAPMenumpahkan hasil ke banyak sel | MAP(array1; [array2]; ...; lambda) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| MATCHDigantikan XMATCH | MATCH(lookup_value; lookup_array; [match_type]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| MAX | MAX(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| MAXA | MAXA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| MAXIFS | MAXIFS(max_range; criteria_range1; criteria1; [criteria_range2; criteria2]; ...) | Statistik (Statistical) | Excel 2019 |
| MDETERM | MDETERM(array) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| MDURATION | MDURATION(settlement; maturity; coupon; yld; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| MEDIAN | MEDIAN(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| MID | MID(text; start_num; num_chars) | Teks (Text) | Excel 2003 atau lebih lama |
| MIDB | MIDB(text; start_num; num_bytes) | Teks (Text) | Excel 2003 atau lebih lama |
| MIN | MIN(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| MINA | MINA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| MINIFS | MINIFS(min_range; criteria_range1; criteria1; [criteria_range2; criteria2]; ...) | Statistik (Statistical) | Excel 2019 |
| MINUTE | MINUTE(serial_number) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| MINVERSEMenumpahkan hasil ke banyak sel | MINVERSE(array) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| MIRR | MIRR(values; finance_rate; reinvest_rate) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| MMULTMenumpahkan hasil ke banyak sel | MMULT(array1; array2) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| MOD | MOD(number; divisor) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| MODEDigantikan MODE.SNGL | MODE(number1; [number2]; ...) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| MODE.MULTMenumpahkan hasil ke banyak sel | MODE.MULT(number1; [number2]; ...) | Statistik (Statistical) | Excel 2010 |
| MODE.SNGL | MODE.SNGL(number1; [number2]; ...) | Statistik (Statistical) | Excel 2010 |
| MONTH | MONTH(serial_number) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| MROUND | MROUND(number; multiple) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| MULTINOMIAL | MULTINOMIAL(number1; [number2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| MUNITMenumpahkan hasil ke banyak sel | MUNIT(dimension) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| N | N(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| NA | NA() | Informasi (Information) | Excel 2003 atau lebih lama |
| NEGBINOM.DIST | NEGBINOM.DIST(number_f; number_s; probability_s; cumulative) | Statistik (Statistical) | Excel 2010 |
| NEGBINOMDISTDigantikan NEGBINOM.DIST | NEGBINOMDIST(number_f; number_s; probability_s) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| NETWORKDAYS | NETWORKDAYS(start_date; end_date; [holidays]) | Tanggal dan waktu (Date and time) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date; end_date; [weekend]; [holidays]) | Tanggal dan waktu (Date and time) | Excel 2010 |
| NOMINAL | NOMINAL(effect_rate; npery) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| NORM.DIST | NORM.DIST(x; mean; standard_dev; cumulative) | Statistik (Statistical) | Excel 2010 |
| NORM.INV | NORM.INV(probability; mean; standard_dev) | Statistik (Statistical) | Excel 2010 |
| NORM.S.DIST | NORM.S.DIST(z; cumulative) | Statistik (Statistical) | Excel 2010 |
| NORM.S.INV | NORM.S.INV(probability) | Statistik (Statistical) | Excel 2010 |
| NORMDISTDigantikan NORM.DIST | NORMDIST(x; mean; standard_dev; cumulative) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| NORMINVDigantikan NORM.INV | NORMINV(probability; mean; standard_dev) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| NORMSDISTDigantikan NORM.S.DIST | NORMSDIST(z) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| NORMSINVDigantikan NORM.S.INV | NORMSINV(probability) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| NOT | NOT(logical) | Logika (Logical) | Excel 2003 atau lebih lama |
| NOWDihitung ulang terus-menerus | NOW() | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| NPER | NPER(rate; pmt; pv; [fv]; [type]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| NPV | NPV(rate; value1; [value2]; ...) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| NUMBERVALUE | NUMBERVALUE(text; [decimal_separator]; [group_separator]) | Teks (Text) | Excel 2013 |
| OCT2BIN | OCT2BIN(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| OCT2DEC | OCT2DEC(number) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| OCT2HEX | OCT2HEX(number; [places]) | Teknik (Engineering) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ODD | ODD(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ODDFPRICEPerlu Excel | ODDFPRICE(settlement; maturity; issue; first_coupon; rate; yld; redemption; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ODDFYIELDPerlu Excel | ODDFYIELD(settlement; maturity; issue; first_coupon; rate; pr; redemption; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ODDLPRICEPerlu Excel | ODDLPRICE(settlement; maturity; last_interest; rate; yld; redemption; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| ODDLYIELD | ODDLYIELD(settlement; maturity; last_interest; rate; pr; redemption; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| OFFSETDihitung ulang terus-menerus | OFFSET(reference; rows; cols; [height]; [width]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| OR | OR(logical1; [logical2]; ...) | Logika (Logical) | Excel 2003 atau lebih lama |
| PDURATION | PDURATION(rate; pv; fv) | Keuangan (Financial) | Excel 2013 |
| PEARSON | PEARSON(array1; array2) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| PERCENTILEDigantikan PERCENTILE.INC | PERCENTILE(array; k) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| PERCENTILE.EXC | PERCENTILE.EXC(array; k) | Statistik (Statistical) | Excel 2010 |
| PERCENTILE.INC | PERCENTILE.INC(array; k) | Statistik (Statistical) | Excel 2010 |
| PERCENTOFMenumpahkan hasil ke banyak sel | PERCENTOF(data_subset; data_all) | Matematika dan trigonometri (Math and trigonometry) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| PERCENTRANKDigantikan PERCENTRANK.INC | PERCENTRANK(array; x; [significance]) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| PERCENTRANK.EXC | PERCENTRANK.EXC(array; x; [significance]) | Statistik (Statistical) | Excel 2010 |
| PERCENTRANK.INC | PERCENTRANK.INC(array; x; [significance]) | Statistik (Statistical) | Excel 2010 |
| PERMUT | PERMUT(number; number_chosen) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| PERMUTATIONA | PERMUTATIONA(number; number_chosen) | Statistik (Statistical) | Excel 2013 |
| PHI | PHI(x) | Statistik (Statistical) | Excel 2013 |
| PHONETICPerlu Excel | PHONETIC(reference) | Teks (Text) | Excel 2003 atau lebih lama |
| PI | PI() | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| PIVOTBYMenumpahkan hasil ke banyak selPerlu 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]) | Pencarian dan referensi (Lookup and reference) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| PMT | PMT(rate; nper; pv; [fv]; [type]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| POISSONDigantikan POISSON.DIST | POISSON(x; mean; cumulative) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| POISSON.DIST | POISSON.DIST(x; mean; cumulative) | Statistik (Statistical) | Excel 2010 |
| POWER | POWER(number; power) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| PPMT | PPMT(rate; per; nper; pv; [fv]; [type]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| PRICE | PRICE(settlement; maturity; rate; yld; redemption; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| PRICEDISC | PRICEDISC(settlement; maturity; discount; redemption; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| PRICEMAT | PRICEMAT(settlement; maturity; issue; rate; yld; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| PROB | PROB(x_range; prob_range; [lower_limit]; [upper_limit]) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| PRODUCT | PRODUCT(number1; [number2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| PROPER | PROPER(text) | Teks (Text) | Excel 2003 atau lebih lama |
| PV | PV(rate; nper; pmt; [fv]; [type]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| PYPerlu Excel | PY(python_code; return_type) | Fungsi khusus dan tipe data tertaut | Microsoft 365 saja, belum ada di Excel edisi abadi |
| QUARTILEDigantikan QUARTILE.INC | QUARTILE(array; quart) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| QUARTILE.EXC | QUARTILE.EXC(array; quart) | Statistik (Statistical) | Excel 2010 |
| QUARTILE.INC | QUARTILE.INC(array; quart) | Statistik (Statistical) | Excel 2010 |
| QUOTIENT | QUOTIENT(numerator; denominator) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| RADIANS | RADIANS(angle) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| RANDDihitung ulang terus-menerus | RAND() | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| RANDARRAYDihitung ulang terus-menerusMenumpahkan hasil ke banyak sel | RANDARRAY([rows]; [columns]; [min]; [max]; [whole_number]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2021 dan Microsoft 365 |
| RANDBETWEENDihitung ulang terus-menerus | RANDBETWEEN(bottom; top) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| RANKDigantikan RANK.EQ | RANK(number; ref; [order]) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| RANK.AVG | RANK.AVG(number; ref; [order]) | Statistik (Statistical) | Excel 2010 |
| RANK.EQ | RANK.EQ(number; ref; [order]) | Statistik (Statistical) | Excel 2010 |
| RATE | RATE(nper; pmt; pv; [fv]; [type]; [guess]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| RECEIVED | RECEIVED(settlement; maturity; investment; discount; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| REDUCEMenumpahkan hasil ke banyak sel | REDUCE([initial_value]; array; lambda) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| REGEXEXTRACTMenumpahkan hasil ke banyak sel | REGEXEXTRACT(text; pattern; [return_mode]; [case_sensitivity]) | Teks (Text) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| REGEXREPLACEMenumpahkan hasil ke banyak sel | REGEXREPLACE(text; pattern; replacement; [occurrence]; [case_sensitivity]) | Teks (Text) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| REGEXTESTMenumpahkan hasil ke banyak sel | REGEXTEST(text; pattern; [case_sensitivity]) | Teks (Text) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| REGISTER.IDPerlu Excel | REGISTER.ID(module_text; procedure; [type_text]) | Add-in dan otomatisasi | Excel 2003 atau lebih lama |
| REPLACE | REPLACE(old_text; start_num; num_chars; new_text) | Teks (Text) | Excel 2003 atau lebih lama |
| REPLACEB | REPLACEB(old_text; start_num; num_bytes; new_text) | Teks (Text) | Excel 2003 atau lebih lama |
| REPT | REPT(text; number_times) | Teks (Text) | Excel 2003 atau lebih lama |
| RIGHT | RIGHT(text; [num_chars]) | Teks (Text) | Excel 2003 atau lebih lama |
| RIGHTB | RIGHTB(text; [num_bytes]) | Teks (Text) | Excel 2003 atau lebih lama |
| ROMAN | ROMAN(number; [form]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ROUND | ROUND(number; num_digits) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ROUNDDOWN | ROUNDDOWN(number; num_digits) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ROUNDUP | ROUNDUP(number; num_digits) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| ROW | ROW([reference]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| ROWS | ROWS(array) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| RRI | RRI(nper; pv; fv) | Keuangan (Financial) | Excel 2013 |
| RSQ | RSQ(known_ys; known_xs) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| RTDDihitung ulang terus-menerusPerlu Excel | RTD(ProgID; server; topic1; [topic2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| SCANMenumpahkan hasil ke banyak sel | SCAN([initial_value]; array; lambda) | Logika (Logical) | Excel 2024 dan Microsoft 365 |
| SEARCH | SEARCH(find_text; within_text; [start_num]) | Teks (Text) | Excel 2003 atau lebih lama |
| SEARCHB | SEARCHB(find_text; within_text; [start_num]) | Teks (Text) | Excel 2003 atau lebih lama |
| SEC | SEC(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| SECH | SECH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2013 |
| SECOND | SECOND(serial_number) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| SEQUENCEMenumpahkan hasil ke banyak sel | SEQUENCE(rows; [columns]; [start]; [step]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2021 dan Microsoft 365 |
| SERIESSUM | SERIESSUM(x; n; m; coefficients) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| SHEETPerlu Excel | SHEET([value]) | Informasi (Information) | Excel 2013 |
| SHEETSPerlu Excel | SHEETS([reference]) | Informasi (Information) | Excel 2013 |
| SIGN | SIGN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SIN | SIN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SINH | SINH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SKEW | SKEW(number1; [number2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| SKEW.P | SKEW.P(number1; [number2]; ...) | Statistik (Statistical) | Excel 2013 |
| SLN | SLN(cost; salvage; life) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| SLOPE | SLOPE(known_ys; known_xs) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| SMALL | SMALL(array; k) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| SORTMenumpahkan hasil ke banyak sel | SORT(array; [sort_index]; [sort_order]; [by_col]) | Pencarian dan referensi (Lookup and reference) | Excel 2021 dan Microsoft 365 |
| SORTBYMenumpahkan hasil ke banyak sel | SORTBY(array; by_array1; [sort_order1]; [by_array2; sort_order2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2021 dan Microsoft 365 |
| SQRT | SQRT(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SQRTPI | SQRTPI(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| STANDARDIZE | STANDARDIZE(x; mean; standard_dev) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| STDEVDigantikan STDEV.S | STDEV(number1; [number2]; ...) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| STDEV.P | STDEV.P(number1; [number2]; ...) | Statistik (Statistical) | Excel 2010 |
| STDEV.S | STDEV.S(number1; [number2]; ...) | Statistik (Statistical) | Excel 2010 |
| STDEVA | STDEVA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| STDEVPDigantikan STDEV.P | STDEVP(number1; [number2]; ...) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| STDEVPA | STDEVPA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| STEYX | STEYX(known_ys; known_xs) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| STOCKHISTORYMenumpahkan hasil ke banyak selPerlu Excel | STOCKHISTORY(stock; start_date; [end_date]; [interval]; [headers]; [property0]; [property1]; ...) | Informasi (Information) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| SUBSTITUTE | SUBSTITUTE(text; old_text; new_text; [instance_num]) | Teks (Text) | Excel 2003 atau lebih lama |
| SUBTOTAL | SUBTOTAL(function_num; ref1; [ref2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUM | SUM(number1; [number2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUMIF | SUMIF(range; criteria; [sum_range]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUMIFS | SUMIFS(sum_range; criteria_range1; criteria1; [criteria_range2; criteria2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2007 |
| SUMPRODUCT | SUMPRODUCT(array1; [array2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUMSQ | SUMSQ(number1; [number2]; ...) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUMX2MY2 | SUMX2MY2(array_x; array_y) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUMX2PY2 | SUMX2PY2(array_x; array_y) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SUMXMY2 | SUMXMY2(array_x; array_y) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| SWITCH | SWITCH(expression; value1; result1; [default_or_value2]; [result2]; ...) | Logika (Logical) | Excel 2019 |
| SYD | SYD(cost; salvage; life; per) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| T | T(value) | Teks (Text) | Excel 2003 atau lebih lama |
| T.DIST | T.DIST(x; deg_freedom; cumulative) | Statistik (Statistical) | Excel 2010 |
| T.DIST.2T | T.DIST.2T(x; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| T.DIST.RT | T.DIST.RT(x; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| T.INV | T.INV(probability; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| T.INV.2T | T.INV.2T(probability; deg_freedom) | Statistik (Statistical) | Excel 2010 |
| T.TEST | T.TEST(array1; array2; tails; type) | Statistik (Statistical) | Excel 2010 |
| TAKEMenumpahkan hasil ke banyak sel | TAKE(array; rows; [columns]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| TAN | TAN(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| TANH | TANH(number) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| TBILLEQ | TBILLEQ(settlement; maturity; discount) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| TBILLPRICE | TBILLPRICE(settlement; maturity; discount) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| TBILLYIELD | TBILLYIELD(settlement; maturity; pr) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| TDISTDigantikan T.DIST.2T atau T.DIST.RT | TDIST(x; deg_freedom; tails) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| TEXT | TEXT(value; format_text) | Teks (Text) | Excel 2003 atau lebih lama |
| TEXTAFTERMenumpahkan hasil ke banyak sel | TEXTAFTER(text; delimiter; [instance_num]; [match_mode]; [match_end]; [if_not_found]) | Teks (Text) | Excel 2024 dan Microsoft 365 |
| TEXTBEFOREMenumpahkan hasil ke banyak sel | TEXTBEFORE(text; delimiter; [instance_num]; [match_mode]; [match_end]; [if_not_found]) | Teks (Text) | Excel 2024 dan Microsoft 365 |
| TEXTJOIN | TEXTJOIN(delimiter; ignore_empty; text1; [text2]; ...) | Teks (Text) | Excel 2019 |
| TEXTSPLITMenumpahkan hasil ke banyak sel | TEXTSPLIT(text; col_delimiter; [row_delimiter]; [ignore_empty]; [match_mode]; [pad_with]) | Teks (Text) | Excel 2024 dan Microsoft 365 |
| TIME | TIME(hour; minute; second) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| TIMEVALUE | TIMEVALUE(time_text) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| TINVDigantikan T.INV.2T | TINV(probability; deg_freedom) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| TOCOLMenumpahkan hasil ke banyak sel | TOCOL(array; [ignore]; [scan_by_column]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| TODAYDihitung ulang terus-menerus | TODAY() | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| TOROWMenumpahkan hasil ke banyak sel | TOROW(array; [ignore]; [scan_by_column]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| TRANSLATEPerlu Excel | TRANSLATE(text; [source_language]; [target_language]) | Teks (Text) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| TRANSPOSEMenumpahkan hasil ke banyak sel | TRANSPOSE(array) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| TRENDMenumpahkan hasil ke banyak sel | TREND(known_ys; [known_xs]; [new_xs]; [const]) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| TRIM | TRIM(text) | Teks (Text) | Excel 2003 atau lebih lama |
| TRIMMEAN | TRIMMEAN(array; percent) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| TRIMRANGEMenumpahkan hasil ke banyak selPerlu Excel | TRIMRANGE(range; [trim_rows]; [trim_cols]) | Pencarian dan referensi (Lookup and reference) | Microsoft 365 saja, belum ada di Excel edisi abadi |
| TRUE | TRUE() | Logika (Logical) | Excel 2003 atau lebih lama |
| TRUNC | TRUNC(number; [num_digits]) | Matematika dan trigonometri (Math and trigonometry) | Excel 2003 atau lebih lama |
| TTESTDigantikan T.TEST | TTEST(array1; array2; tails; type) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| TYPE | TYPE(value) | Informasi (Information) | Excel 2003 atau lebih lama |
| UNICHAR | UNICHAR(number) | Teks (Text) | Excel 2013 |
| UNICODE | UNICODE(text) | Teks (Text) | Excel 2013 |
| UNIQUEMenumpahkan hasil ke banyak sel | UNIQUE(array; [by_col]; [exactly_once]) | Pencarian dan referensi (Lookup and reference) | Excel 2021 dan Microsoft 365 |
| UPPER | UPPER(text) | Teks (Text) | Excel 2003 atau lebih lama |
| VALUE | VALUE(text) | Teks (Text) | Excel 2003 atau lebih lama |
| VALUETOTEXTMenumpahkan hasil ke banyak sel | VALUETOTEXT(value; [format]) | Teks (Text) | Excel 2024 dan Microsoft 365 |
| VARDigantikan VAR.S | VAR(number1; [number2]; ...) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| VAR.P | VAR.P(number1; [number2]; ...) | Statistik (Statistical) | Excel 2010 |
| VAR.S | VAR.S(number1; [number2]; ...) | Statistik (Statistical) | Excel 2010 |
| VARA | VARA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| VARPDigantikan VAR.P | VARP(number1; [number2]; ...) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| VARPA | VARPA(value1; [value2]; ...) | Statistik (Statistical) | Excel 2003 atau lebih lama |
| VDB | VDB(cost; salvage; life; start_period; end_period; [factor]; [no_switch]) | Keuangan (Financial) | Excel 2003 atau lebih lama |
| VLOOKUPDigantikan XLOOKUP | VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup]) | Pencarian dan referensi (Lookup and reference) | Excel 2003 atau lebih lama |
| VSTACKMenumpahkan hasil ke banyak sel | VSTACK(array1; [array2]; ...) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| WEBSERVICEDihitung ulang terus-menerusPerlu Excel | WEBSERVICE(url) | Web | Excel 2013 |
| WEEKDAY | WEEKDAY(serial_number; [return_type]) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| WEEKNUM | WEEKNUM(serial_number; [return_type]) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| WEIBULLDigantikan WEIBULL.DIST | WEIBULL(x; alpha; beta; cumulative) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
| WEIBULL.DIST | WEIBULL.DIST(x; alpha; beta; cumulative) | Statistik (Statistical) | Excel 2010 |
| WORKDAY | WORKDAY(start_date; days; [holidays]) | Tanggal dan waktu (Date and time) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| WORKDAY.INTL | WORKDAY.INTL(start_date; days; [weekend]; [holidays]) | Tanggal dan waktu (Date and time) | Excel 2010 |
| WRAPCOLSMenumpahkan hasil ke banyak sel | WRAPCOLS(vector; wrap_count; [pad_with]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| WRAPROWSMenumpahkan hasil ke banyak sel | WRAPROWS(vector; wrap_count; [pad_with]) | Pencarian dan referensi (Lookup and reference) | Excel 2024 dan Microsoft 365 |
| XIRR | XIRR(values; dates; [guess]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| XLOOKUPMenumpahkan hasil ke banyak sel | XLOOKUP(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode]) | Pencarian dan referensi (Lookup and reference) | Excel 2021 dan Microsoft 365 |
| XMATCHMenumpahkan hasil ke banyak sel | XMATCH(lookup_value; lookup_array; [match_mode]; [search_mode]) | Pencarian dan referensi (Lookup and reference) | Excel 2021 dan Microsoft 365 |
| XNPV | XNPV(rate; values; dates) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| XOR | XOR(logical1; [logical2]; ...) | Logika (Logical) | Excel 2013 |
| YEAR | YEAR(serial_number) | Tanggal dan waktu (Date and time) | Excel 2003 atau lebih lama |
| YEARFRAC | YEARFRAC(start_date; end_date; [basis]) | Tanggal dan waktu (Date and time) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| YIELD | YIELD(settlement; maturity; rate; pr; redemption; frequency; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| YIELDDISC | YIELDDISC(settlement; maturity; pr; redemption; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| YIELDMAT | YIELDMAT(settlement; maturity; issue; rate; pr; [basis]) | Keuangan (Financial) | Excel 2007 (sebelumnya add-in Analysis ToolPak di Excel 2003) |
| Z.TEST | Z.TEST(array; x; [sigma]) | Statistik (Statistical) | Excel 2010 |
| ZTESTDigantikan Z.TEST | ZTEST(array; x; [sigma]) | Kompatibilitas (Compatibility) | Excel 2003 atau lebih lama |
