Fungsi¶
Spreadsheet functions are divided in the following categories:
Catatan
Rumus yang berisi fungsi yang tidak kompatibel dengan Excel diganti dengan hasil evaluasinya saat mengekspor spreadsheet.
Array¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ARRAY.CONSTRAIN(input_range, rows, columns) |
Mengembalikan array hasil yang dibatasi pada lebar dan tinggi tertentu (tidak kompatibel dengan Excel) |
CHOOSECOLS(array, col_num, [col_num2, ...]) |
|
CHOOSEROWS(array, row_num, [row_num2, ...]) |
|
EXPAND(array, rows, [columns], [pad_with]) |
|
FLATTEN(range, [range2, ...]) |
Meratakan semua nilai dari satu atau lebih rentang ke dalam satu kolom (tidak kompatibel dengan Excel) |
FREQUENCY(data, classes) |
|
HSTACK(range1, [range2, ...]) |
|
MDETERM(square_matrix) |
|
MINVERSE(square_matrix) |
|
MMULT(matrix1, matrix2) |
|
SUMPRODUCT(range1, [range2, ...]) |
|
SUMX2MY2(array_x, array_y) |
|
SUMX2PY2(array_x, array_y) |
|
SUMXMY2(array_x, array_y) |
|
TOCOL(array, [ignore], [scan_by_column]) |
|
TOROW(array, [ignore], [scan_by_column]) |
|
TRANSPOSE(range) |
|
VSTACK(range1, [range2, ...]) |
|
WRAPCOLS(range, wrap_count, [pad_with]) |
|
WRAPROWS(range, wrap_count, [pad_with]) |
Database¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
DAVERAGE(database, field, criteria) |
|
DCOUNT(database, field, criteria) |
|
DCOUNTA(database, field, criteria) |
|
DGET(database, field, criteria) |
|
DMAX(database, field, criteria) |
|
DMIN(database, field, criteria) |
|
DPRODUCT(database, field, criteria) |
|
DSTDEV(database, field, criteria) |
|
DSTDEVP(database, field, criteria) |
|
DSUM(database, field, criteria) |
|
DVAR(database, field, criteria) |
|
DVARP(database, field, criteria) |
Tanggal¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
DATE(year, month, day) |
|
DATEDIF(start_date, end_date, unit) |
|
DATEVALUE(date_string) |
|
DAY(date) |
|
DAYS(end_date, start_date) |
|
DAYS360(start_date, end_date, [method]) |
|
EDATE(start_date, months) |
|
EOMONTH(start_date, months) |
|
HOUR(time) |
|
ISOWEEKNUM(tanggal) |
|
MINUTE(waktu) |
|
MONTH(tanggal) |
|
NETWORKDAYS(tanggal_mulai, tanggal_akhir, [hari_libur]) |
|
NETWORKDAYS.INTL(tanggal_mulai, tanggal_akhir, [akhir_pekan], [hari_libur]) |
|
NOW() |
|
SECOND(waktu) |
|
TIME(jam, menit, detik) |
|
TIMEVALUE(string_waktu) |
|
TODAY() |
|
WEEKDAY(tanggal, [tipe]) |
|
WEEKNUM(tanggal, [tipe]) |
|
WORKDAY(tanggal_mulai, jumlah_hari, [libur]) |
|
WORKDAY.INTL(tanggal_mulai, jumlah_hari, [akhir_pekan], [libur]) |
|
YEAR(tanggal) |
|
YEARFRAC(tanggal_awal, tanggal_akhir, [konvensi_penghitungan_hari]) |
Jumlah tahun yang tepat antara dua tanggal (tidak kompatibel dengan Excel) |
MONTH.START(tanggal) |
Hari pertama bulan sebelum tanggal tertentu (tidak kompatibel dengan Excel) |
MONTH.END(tanggal) |
Hari terakhir bulan setelah tanggal tertentu (tidak kompatibel dengan Excel) |
QUARTER(tanggal) |
Kuartal tahun di mana tanggal tertentu berada (tidak kompatibel dengan Excel) |
QUARTER.START(tanggal) |
Hari pertama kuartal tahun di mana tanggal tertentu berada (tidak kompatibel dengan Excel) |
QUARTER.END(tanggal) |
Hari terakhir kuartal tahun di mana tanggal tertentu berada (tidak kompatibel dengan Excel) |
YEAR.START(tanggal) |
Hari pertama tahun di mana tanggal tertentu berada (tidak kompatibel dengan Excel) |
YEAR.END(tanggal) |
Hari terakhir tahun di mana tanggal tertentu berada (tidak kompatibel dengan Excel) |
Insinyur¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
DELTA(angka1, [angka2]) |
Saring¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
FILTER(rentang, kondisi1, [kondisi2, ...]) |
|
UNIQUE(rentang, [berdasarkan_kolom], [tepat_sekali]) |
Keuangan¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ACCRINTM(penerbitan, jatuh_tempo, suku_bunga, penebusan, [konvensi_penghitungan_hari]) |
|
AMORLINC(biaya, tanggal_pembelian, akhir_periode_pertama, nilai_sisa, periode, suku_bunga, [konvensi_penghitungan_hari]) |
|
COUPDAYS(penyelesaian, jatuh_tempo, frekuensi, [konvensi_penghitungan_hari]) |
|
COUPDAYBS(penyelesaian, jatuh_tempo, frekuensi, [konvensi_penghitungan_hari]) |
|
COUPDAYSNC(penyelesaian, jatuh_tempo, frekuensi, [konvensi_penghitungan_hari]) |
|
COUPNCD(penyelesaian, jatuh_tempo, frekuensi, [konvensi_penghitungan_hari]) |
|
COUPNUM(penyelesaian, jatuh_tempo, frekuensi, [konvensi_penghitungan_hari]) |
|
COUPPCD(penyelesaian, jatuh_tempo, frekuensi, [konvensi_penghitungan_hari]) |
|
CUMIPMT(tingkat, jumlah_periode, nilai_sekarang, periode_pertama, periode_terakhir, [akhir_atau_awal]) |
|
CUMPRINC(tingkat, jumlah_periode, nilai_sekarang, periode_pertama, periode_terakhir, [akhir_atau_awal]) |
|
DB(biaya, nilai_sisa, umur, periode, [bulan]) |
|
DDB(biaya, nilai_sisa, umur, periode, [faktor]) |
|
DISC(settlement, maturity, price, redemption, [day_count_convention]) |
|
DOLLARDE(fractional_price, unit) |
|
DOLLARFR(decimal_price, unit) |
|
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) |
|
EFFECT(nominal_rate, periods_per_year) |
|
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) |
|
FVSCHEDULE(principal, rate_schedule) |
|
INTRATE(settlement, maturity, investment, redemption, [day_count_convention]) |
|
IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) |
|
IRR(cashflow_amounts, [rate_guess]) |
|
ISPMT(rate, period, number_of_periods, present_value) |
|
MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) |
|
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate) |
|
NOMINAL(effective_rate, periods_per_year) |
|
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning]) |
|
NPV(discount, cashflow1, [cashflow2, ...]) |
|
PDURATION(rate, present_value, future_value) |
|
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) |
|
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) |
|
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) |
|
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention]) |
|
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention]) |
|
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention]) |
|
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) |
|
RECEIVED(settlement, maturity, investment, discount, [day_count_convention]) |
|
RRI(number_of_periods, present_value, future_value) |
|
SLN(cost, salvage, life) |
|
SYD(cost, salvage, life, period) |
|
TBILLPRICE(settlement, maturity, discount) |
|
TBILLEQ(settlement, maturity, discount) |
|
TBILLYIELD(settlement, maturity, price) |
|
VDB(cost, salvage, life, start, end, [factor], [no_switch]) |
|
XIRR(cashflow_amounts, cashflow_dates, [rate_guess]) |
|
XNPV(discount, cashflow_amounts, cashflow_dates) |
|
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention]) |
|
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) |
|
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]) |
Informasi¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ISERR(value) |
|
ISERROR(value) |
|
ISLOGICAL(value) |
|
ISNA(value) |
|
ISNONTEXT(value) |
|
ISNUMBER(value) |
|
ISTEXT(value) |
|
ISBLANK(value) |
|
NA() |
Logical¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
AND(logical_expression1, [logical_expression2, ...]) |
|
FALSE() |
|
IF(ekspresi_logika, nilai_jika_benar, [nilai_jika_salah]) |
|
IFERROR(nilai, [nilai_jika_error]) |
|
IFNA(nilai, [nilai_jika_error]) |
|
IFS(kondisi1, nilai1, [kondisi2, ...], [nilai2, ...]) |
|
NOT(ekspresi_logika) |
|
OR(ekspresi_logika1, [ekspresi_logika2, ...]) |
|
TRUE() |
|
XOR(ekspresi_logika1, [ekspresi_logika2, ...]) |
Lookup¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ADDRESS(baris, kolom, [mode_absolut_relatif], [gunakan_notasi_a1], [lembar]) |
Artikel Excel ADDRESS https://support.microsoft.com/office/address-function-d0c26c0d-3991-446b-8de4-ab46431d4f89 |
COLUMN([cell_reference]) |
Artikel Excel COLUMN https://support.microsoft.com/office/column-function-44e8c754-711c-4df3-9da4-47a55042554b |
COLUMNS(range) |
Artikel Excel COLUMNS https://support.microsoft.com/office/columns-function-4e8e7b4e-e603-43e8-b177-956088fa48ca |
HLOOKUP(search_key, range, index, [is_sorted]) |
Artikel Excel HLOOKUP https://support.microsoft.com/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f |
INDEX(reference, row, column) |
Artikel Excel INDEX https://support.microsoft.com/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd |
LOOKUP(search_key, search_array, [result_range]) |
Artikel Excel LOOKUP https://support.microsoft.com/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb |
MATCH(search_key, range, [search_type]) |
Artikel Excel MATCH https://support.microsoft.com/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a |
ROW([cell_reference]) |
|
ROWS(range) |
|
VLOOKUP(search_key, range, index, [is_sorted]) |
|
XLOOKUP(search_key, lookup_range, return_range, [if_not_found], [match_mode], [search_mode]) |
Mat¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ABS(value) |
|
ACOS(value) |
|
ACOSH(value) |
|
ACOT(value) |
|
ACOTH(value) |
|
ASIN(value) |
|
ASINH(nilai) |
|
ATAN(nilai) |
|
ATAN2(x, y) |
|
ATANH(nilai) |
|
CEILING(nilai, [faktor]) |
|
CEILING.MATH(angka, [signifikansi], [mode]) |
|
CEILING.PRECISE(angka, [signifikansi]) |
|
COS(sudut) |
|
COSH(nilai) |
|
COT(sudut) |
|
COTH(nilai) |
|
COUNTBLANK(nilai1, [nilai2, ...]) |
|
COUNTIF(rentang, kriteria) |
|
COUNTIFS(rentang_kriteria1, kriteria1, [rentang_kriteria2, ...], [kriteria2, ...]) |
|
COUNTUNIQUE(value1, [value2, ...]) |
Menghitung jumlah nilai unik dalam rentang (tidak kompatibel dengan Excel) |
COUNTUNIQUEIFS(range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) |
Menghitung jumlah nilai unik dalam rentang, difilter berdasarkan serangkaian kriteria (tidak kompatibel dengan Excel) |
CSC(sudut) |
|
CSCH(nilai) |
|
DECIMAL(nilai, basis) |
|
DEGREES(sudut) |
|
EXP(nilai) |
|
FLOOR(nilai, [faktor]) |
|
FLOOR.MATH(number, [significance], [mode]) |
|
FLOOR.PRECISE(number, [significance]) |
|
INT(value) |
|
ISEVEN(value) |
|
ISO.CEILING(number, [significance]) |
|
ISODD(value) |
|
LN(value) |
|
MOD(dividend, divisor) |
|
MUNIT(dimension) |
|
ODD(value) |
Artikel Excel ODD <https://support.microsoft.com/office/odd-function-deae64eb-e08a-4c88-8b40-6d0b42575c98>`_ |
PI() |
|
POWER(basis, eksponen) |
|
PRODUCT(faktor1, [faktor2, ...]) |
|
RAND() |
|
RANDARRAY([baris], [kolom], [min], [maks], [bilangan_bulat]) |
|
RANDBETWEEN(rendah, tinggi) |
|
ROUND(nilai, [tempat]) |
|
ROUNDDOWN(nilai, [tempat]) |
|
ROUNDUP(nilai, [tempat]) |
|
SEC(sudut) |
|
SECH(nilai) |
|
SIN(sudut) |
|
SINH(nilai) |
|
SQRT(nilai) |
|
SUM(nilai1, [nilai2, ...]) |
|
SUMIF(rentang_kriteria, kriteria, [rentang_jumlah]) |
|
SUMIFS(rentang_jumlah, rentang_kriteria1, kriteria1, [rentang_kriteria2, ...], [kriteria2, ...]) |
|
TAN(sudut) |
|
TANH(nilai) |
|
TRUNC(nilai, [tempat]) |
Lain-lain¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
FORMAT.LARGE.NUMBER(value, [unit]) |
Apply a large number format (not compatible with Excel) |
Odoo¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ODOO.CREDIT(account_codes, date_range, [offset], [company_id], [include_unposted]) |
Get the total credit for the specified account(s) and period (not compatible with Excel) |
ODOO.DEBIT(account_codes, date_range, [offset], [company_id], [include_unposted]) |
Get the total debit for the specified account(s) and period (not compatible with Excel) |
ODOO.BALANCE(account_codes, date_range, [offset], [company_id], [include_unposted]) |
Get the total balance for the specified account(s) and period (not compatible with Excel) |
ODOO.FISCALYEAR.START(day, [company_id]) |
Mengembalikan tanggal awal tahun fiskal yang mencakup tanggal yang diberikan (tidak kompatibel dengan Excel) |
ODOO.FISCALYEAR.END(day, [company_id]) |
Mengembalikan tanggal akhir tahun fiskal yang mencakup tanggal yang diberikan (tidak kompatibel dengan Excel) |
ODOO.ACCOUNT.GROUP(type) |
Mengembalikan id akun dari grup tertentu (tidak kompatibel dengan Excel) |
ODOO.CURRENCY.RATE(currency_from, currency_to, [date]) |
This function takes in two currency codes as arguments, and returns the exchange rate from the first currency to the second as float (not compatible with Excel) |
ODOO.LIST(list_id, index, field_name) |
Get the value from a list (not compatible with Excel) |
ODOO.LIST.HEADER(list_id, field_name) |
Get the header of a list (not compatible with Excel) |
ODOO.FILTER.VALUE(nama_filter) |
Return the current value of a spreadsheet filter (not compatible with Excel) |
ODOO.PIVOT(pivot_id, measure_name, [domain_field_name, ...], [domain_value, ...]) |
Get the value from a pivot (not compatible with Excel) |
ODOO.PIVOT.HEADER(pivot_id, [domain_field_name, ...], [domain_value, ...]) |
Get the header of a pivot (not compatible with Excel) |
ODOO.PIVOT.TABLE(pivot_id, [row_count], [include_total], [include_column_titles]) |
Get a pivot table (not compatible with Excel) |
Operator-Operator¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
ADD(nilai1, nilai2) |
Jumlah dua angka (tidak kompatibel dengan Excel) |
CONCAT(nilai1, nilai2) |
|
DIVIDE(dividen, pembagi) |
Satu angka dibagi dengan angka lainnya (tidak kompatibel dengan Excel) |
EQ(nilai1, nilai2) |
Sama dengan (tidak kompatibel dengan Excel) |
GT(nilai1, nilai2) |
Lebih besar dari (tidak kompatibel dengan Excel) |
GTE(nilai1, nilai2) |
Lebih besar dari atau sama dengan (tidak kompatibel dengan Excel) |
LT(nilai1, nilai2) |
Kurang dari (tidak kompatibel dengan Excel) |
LTE(nilai1, nilai2) |
Kurang dari atau sama dengan (tidak kompatibel dengan Excel) |
MINUS(nilai1, nilai2) |
Selisih dua angka (tidak kompatibel dengan Excel) |
MULTIPLY(faktor1, faktor2) |
Hasil kali dua angka (tidak kompatibel dengan Excel) |
NE(nilai1, nilai2) |
Tidak sama dengan (tidak kompatibel dengan Excel) |
POW(basis, eksponen) |
Angka yang dipangkatkan (tidak kompatibel dengan Excel) |
UMINUS(nilai) |
Angka dengan tanda yang dibalik (tidak kompatibel dengan Excel) |
UNARY.PERCENT(persentase) |
Nilai yang diinterpretasikan sebagai persentase (tidak kompatibel dengan Excel) |
UPLUS(nilai) |
Angka yang ditentukan, tidak berubah (tidak kompatibel dengan Excel) |
Statistik¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
AVEDEV(nilai1, [nilai2, ...]) |
|
AVERAGE(nilai1, [nilai2, ...]) |
|
AVERAGE.WEIGHTED(values, weights, [additional_values, ...], [additional_weights, ...]) |
Rata-rata tertimbang (tidak kompatibel dengan Excel) |
AVERAGEA(nilai1, [nilai2, ...]) |
Artikel AVERAGEA Excel <https://support.microsoft.com/office/averagea-function-f5f84098-d453-4f4c-bbba-3d2c66356091> |
AVERAGEIF(criteria_range, criterion, [average_range]) |
Artikel AVERAGEIF Excel <https://support.microsoft.com/office/averageif-function-faec8e2e-0dec-4308-af69-f5576d8ac642> |
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) |
Artikel AVERAGEIFS Excel <https://support.microsoft.com/office/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690> |
CORREL(data_y, data_x) |
Artikel CORREL Excel <https://support.microsoft.com/office/correl-function-995dcef7-0c0a-4bed-a3fb-239d7b68ca92> |
COUNT(value1, [value2, ...]) |
Artikel COUNT Excel <https://support.microsoft.com/office/count-function-a59cd7fc-b623-4d93-87a4-d23bf411294c> |
COUNTA(value1, [value2, ...]) |
Artikel COUNTA Excel <https://support.microsoft.com/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509> |
COVAR(data_y, data_x) |
Artikel COVAR Excel <https://support.microsoft.com/office/covar-function-50479552-2c03-4daf-bd71-a5ab88b2db03> |
COVARIANCE.P(data_y, data_x) |
Artikel COVARIANCE.P Excel <https://support.microsoft.com/office/covariance-p-function-6f0e1e6d-956d-4e4b-9943-cfef0bf9edfc> |
COVARIANCE.S(data_y, data_x) |
Artikel COVARIANCE.S Excel <https://support.microsoft.com/office/covariance-s-function-0a539b74-7371-42aa-a18f-1f5320314977> |
FORECAST(x, data_y, data_x) |
|
GROWTH(known_data_y, [known_data_x], [new_data_x], [b]) |
Menyesuaikan titik-titik ke tren pertumbuhan eksponensial (tidak kompatibel dengan Excel) |
INTERCEPT(data_y, data_x) |
|
LARGE(data, n) |
|
LINEST(data_y, [data_x], [calculate_b], [verbose]) |
|
LOGEST(data_y, [data_x], [calculate_b], [verbose]) |
|
MATTHEWS(data_x, data_y) |
Compute the Matthews correlation coefficient of a dataset (not compatible with Excel) |
MAX(value1, [value2, ...]) |
|
MAXA(value1, [value2, ...]) |
|
MAXIFS(range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) |
|
MEDIAN(value1, [value2, ...]) |
|
MIN(nilai1, [nilai2, ...]) |
|
MINA(nilai1, [nilai2, ...]) |
|
MINIFS(rentang, rentang_kriteria1, kriteria1, [rentang_kriteria2, ...], [kriteria2, ...]) |
|
PEARSON(data_y, data_x) |
|
PERCENTILE(data, persentil) |
|
PERCENTILE.EXC(data, persentil) |
|
PERCENTILE.INC(data, persentil) |
|
POLYFIT.COEFFS(data_y, data_x, orde, [intersep]) |
Compute the coefficients of polynomial regression of the dataset (not compatible with Excel) |
POLYFIT.FORECAST(x, data_y, data_x, orde, [intersep]) |
Predict value by computing a polynomial regression of the dataset (not compatible with Excel) |
QUARTILE(data, nomor_kuartil) |
|
QUARTILE.EXC(data, nomor_kuartil) |
|
QUARTILE.INC(data, quartile_number) |
|
RANK(value, data, [is_ascending]) |
|
RSQ(data_y, data_x) |
|
SMALL(data, n) |
|
SLOPE(data_y, data_x) |
|
SPEARMAN(data_y, data_x) |
Compute the Spearman rank correlation coefficient of a dataset (not compatible with Excel) |
STDEV(value1, [value2, ...]) |
|
STDEV.P(value1, [value2, ...]) |
|
STDEV.S(value1, [value2, ...]) |
|
STDEVA(value1, [value2, ...]) |
|
STDEVP(value1, [value2, ...]) |
|
STDEVPA(nilai1, [nilai2, ...]) |
|
STEYX(data_y, data_x) |
|
TREND(known_data_y, [known_data_x], [new_data_x], [b]) |
Menyesuaikan titik dengan tren linear yang diturunkan melalui metode kuadrat terkecil (tidak kompatibel dengan Excel) |
VAR(nilai1, [nilai2, ...]) |
|
VAR.P(nilai1, [nilai2, ...]) |
|
VAR.S(nilai1, [nilai2, ...]) |
|
VARA(nilai1, [nilai2, ...]) |
|
VARP(nilai1, [nilai2, ...]) |
|
VARPA(nilai1, [nilai2, ...]) |
Teks¶
Web¶
Nama dan argumen |
Deskripsi atau tautan |
|---|---|
HYPERLINK(url, [link_label]) |