499 functions Excel — semua kategori, searchable, dengan contoh praktikal Bahasa Melayu.
Cari yang basic je? Buka Formula Penting (curated) dulu. Tekan / untuk focus search.
499 functions ditemui
Syntax
ABS(number)
Return nilai mutlak (absolute) — buang tanda negatif.
Contoh
=ABS(-15)
Hasil: 15
💡 Variance calc, ignore sign in distance.
Syntax
ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Accrued interest untuk security periodic interest.
Contoh
=ACCRINT(...)
Syntax
ACCRINTM(issue, settlement, rate, par, [basis])
Accrued interest at maturity security.
Contoh
=ACCRINTM(...)
Syntax
ACOS(number)
Arc cosine (inverse cosine) — return sudut dalam radian.
Contoh
=ACOS(0.5)
≈ 1.047 (60°)
Syntax
ACOSH(number)
Inverse hyperbolic cosine.
Contoh
=ACOSH(1)
Syntax
ACOT(number)
Arc cotangent — return sudut dalam radian.
Contoh
=ACOT(2)
Syntax
ACOTH(number)
Inverse hyperbolic cotangent.
Contoh
=ACOTH(6)
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Bina text address dari row/column number.
Contoh
=ADDRESS(2,3)
"$C$2"
Syntax
AGGREGATE(function_num, options, ref1, ...)
Run aggregation (SUM, AVG, etc.) dengan options ignore errors/hidden rows.
Contoh
=AGGREGATE(9,6,B2:B10)
SUM ignore errors
💡 Bersihkan dashboard dari error values.
Syntax
AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Depreciation untuk setiap accounting period (French).
Contoh
=AMORDEGRC(...)
Syntax
AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Linear depreciation (French accounting).
Contoh
=AMORLINC(...)
Syntax
AND(logical1, [logical2], ...)
TRUE kalau SEMUA syarat betul.
Contoh
=IF(AND(B2>500,C2<100),"OK","No")
💡 Multi-criteria validation.
Syntax
ARABIC(text)
Convert Roman numeral ke nombor Arabic.
Contoh
=ARABIC("MCMXC")
1990
Syntax
AREAS(reference)
Jumlah areas dalam reference.
Contoh
=AREAS((A1:B2,C3:D4))
2
Syntax
ARRAYTOTEXT(array, [format])
Convert array ke text representation.
Contoh
=ARRAYTOTEXT(A1:B2)
Syntax
ASC(text)
Convert full-width characters ke half-width (for double-byte languages).
Contoh
=ASC("ABC")
Syntax
ASIN(number)
Arc sine — return sudut dalam radian (-π/2 ke π/2).
Contoh
=ASIN(1)
≈ 1.571 (90°)
Syntax
ASINH(number)
Inverse hyperbolic sine.
Contoh
=ASINH(1)
Syntax
ATAN(number)
Arc tangent — return sudut dalam radian.
Contoh
=ATAN(1)
≈ 0.785 (45°)
Syntax
ATAN2(x_num, y_num)
Arc tangent dari x dan y coordinates.
Contoh
=ATAN2(1,1)
≈ 0.785 (45°)
Syntax
ATANH(number)
Inverse hyperbolic tangent.
Contoh
=ATANH(0.5)
Syntax
AVEDEV(number1, [number2], ...)
Average of absolute deviations dari mean.
Contoh
=AVEDEV(B2:B10)
Syntax
AVERAGE(number1, [number2], ...)
Mean (purata) nombor dalam range.
Contoh
=AVERAGE(B2:B13)
Purata revenue 12 bulan
💡 Average monthly sales.
Syntax
AVERAGEA(value1, [value2], ...)
Mean termasuk text (TRUE=1, FALSE=0, text=0).
Contoh
=AVERAGEA(A2:A10)
Syntax
AVERAGEIF(range, criteria, [average_range])
Average dengan satu syarat.
Contoh
=AVERAGEIF(B:B,"VIP",C:C)
Avg spend VIP
Syntax
AVERAGEIFS(avg_range, criteria_range1, criteria1, ...)
Average dengan multiple syarat.
Contoh
=AVERAGEIFS(C:C,A:A,"2026",B:B,"Q1")
💡 Quarterly benchmarks.
Syntax
BAHTTEXT(number)
Convert number ke Thai baht text.
Contoh
=BAHTTEXT(1234)
Syntax
BASE(number, radix, [min_length])
Convert nombor ke representation text dalam radix tertentu.
Contoh
=BASE(15,2)
"1111" (binary)
Syntax
BESSELI(x, n)
Modified Bessel function In(x).
Contoh
=BESSELI(1.5,1)
Syntax
BESSELJ(x, n)
Bessel function Jn(x).
Contoh
=BESSELJ(1.9,2)
Syntax
BESSELK(x, n)
Modified Bessel function Kn(x).
Contoh
=BESSELK(1.5,1)
Syntax
BESSELY(x, n)
Bessel function Yn(x).
Contoh
=BESSELY(2.5,1)
Syntax
BETA.DIST(x, alpha, beta, cumulative, [A], [B])
Beta probability distribution function.
Contoh
=BETA.DIST(2,8,10,TRUE,1,3)
Syntax
BETA.INV(probability, alpha, beta, [A], [B])
Inverse beta cumulative distribution.
Contoh
=BETA.INV(0.685,8,10,1,3)
Syntax
BETADIST(x, alpha, beta, [A], [B])
Legacy beta cumulative distribution. Pakai BETA.DIST.
Contoh
=BETADIST(2,8,10,1,3)
Syntax
BETAINV(probability, alpha, beta, [A], [B])
Legacy inverse beta. Pakai BETA.INV.
Contoh
=BETAINV(0.685,8,10,1,3)
Syntax
BIN2DEC(number)
Convert binary ke decimal.
Contoh
=BIN2DEC("1010")
10
Syntax
BIN2HEX(number, [places])
Convert binary ke hexadecimal.
Contoh
=BIN2HEX("11111011")
"FB"
Syntax
BIN2OCT(number, [places])
Convert binary ke octal.
Contoh
=BIN2OCT("1001")
"11"
Syntax
BINOM.DIST(number_s, trials, prob_s, cumulative)
Binomial distribution probability.
Contoh
=BINOM.DIST(6,10,0.5,FALSE)
Syntax
BINOM.DIST.RANGE(trials, prob_s, num_s, [num_s2])
Probability of trial result dalam range.
Contoh
=BINOM.DIST.RANGE(60,0.75,48)
Syntax
BINOM.INV(trials, probability_s, alpha)
Smallest value yang cumulative binomial ≥ alpha.
Contoh
=BINOM.INV(6,0.5,0.75)
Syntax
BINOMDIST(number_s, trials, prob_s, cumulative)
Legacy. Pakai BINOM.DIST.
Contoh
=BINOMDIST(6,10,0.5,FALSE)
Syntax
BITAND(number1, number2)
Bitwise AND of two numbers.
Contoh
=BITAND(13,25)
9
Syntax
BITLSHIFT(number, shift_amount)
Left-shift bits.
Contoh
=BITLSHIFT(4,2)
16
Syntax
BITOR(number1, number2)
Bitwise OR.
Contoh
=BITOR(23,10)
31
Syntax
BITRSHIFT(number, shift_amount)
Right-shift bits.
Contoh
=BITRSHIFT(13,2)
3
Syntax
BITXOR(number1, number2)
Bitwise XOR.
Contoh
=BITXOR(5,3)
6
Syntax
BYCOL(array, lambda)
Apply LAMBDA function ke setiap column.
Contoh
=BYCOL(A1:C10,LAMBDA(c,SUM(c)))
Syntax
BYROW(array, lambda)
Apply LAMBDA function ke setiap row.
Contoh
=BYROW(A1:C10,LAMBDA(r,SUM(r)))
Syntax
CEILING(number, significance)
Bulatkan ke atas ke multiple terdekat. (Legacy — pakai CEILING.MATH)
Contoh
=CEILING(2.5,1)
3
Syntax
CEILING.MATH(number, [significance], [mode])
Bulatkan ke atas ke nombor bulat atau multiple terdekat.
Contoh
=CEILING.MATH(4.3)
5
Syntax
CEILING.PRECISE(number, [significance])
Bulatkan ke atas, sentiasa positive direction regardless of sign.
Contoh
=CEILING.PRECISE(-4.3)
-4
Syntax
CELL(info_type, [reference])
Info pasal cell (address, format, content type).
Contoh
=CELL("address",A1)
"$A$1"
Syntax
CHAR(number)
Character dari code number (ASCII/Unicode).
Contoh
=CHAR(65)
"A"
Syntax
CHIDIST(x, deg_freedom)
Legacy. Pakai CHISQ.DIST.RT.
Contoh
=CHIDIST(18.307,10)
Syntax
CHIINV(probability, deg_freedom)
Legacy. Pakai CHISQ.INV.RT.
Contoh
=CHIINV(0.05,10)
Syntax
CHISQ.DIST(x, deg_freedom, cumulative)
Chi-squared distribution.
Contoh
=CHISQ.DIST(0.5,1,TRUE)
Syntax
CHISQ.DIST.RT(x, deg_freedom)
Right-tailed chi-squared distribution.
Contoh
=CHISQ.DIST.RT(18.307,10)
Syntax
CHISQ.INV(probability, deg_freedom)
Inverse chi-squared cumulative distribution.
Contoh
=CHISQ.INV(0.93,1)
Syntax
CHISQ.INV.RT(probability, deg_freedom)
Inverse right-tailed chi-squared distribution.
Contoh
=CHISQ.INV.RT(0.05,10)
Syntax
CHISQ.TEST(actual_range, expected_range)
Chi-squared test independence.
Contoh
=CHISQ.TEST(A1:B3,D1:E3)
Syntax
CHITEST(actual_range, expected_range)
Legacy. Pakai CHISQ.TEST.
Contoh
=CHITEST(A1:B3,D1:E3)
Syntax
CHOOSE(index_num, value1, [value2], ...)
Pick value dari list by index.
Contoh
=CHOOSE(2,"A","B","C")
"B"
💡 Quarter from month, day name.
Syntax
CHOOSECOLS(array, col_num1, [col_num2], ...)
Return specified columns dari array.
Contoh
=CHOOSECOLS(A1:E10,1,3)
Syntax
CHOOSEROWS(array, row_num1, [row_num2], ...)
Return specified rows dari array.
Contoh
=CHOOSEROWS(A1:E10,1,5)
Syntax
CLEAN(text)
Remove non-printable characters dari text.
Contoh
=CLEAN(A2)
💡 Clean imported data.
Syntax
CODE(text)
Code number dari first character.
Contoh
=CODE("A")
65
Syntax
COLUMN([reference])
Column number dari reference.
Contoh
=COLUMN(C5)
3
Syntax
COLUMNS(array)
Jumlah columns dalam reference.
Contoh
=COLUMNS(A1:E10)
5
Syntax
COMBIN(number, number_chosen)
Number of combinations (tanpa ulang) — nCr.
Contoh
=COMBIN(8,2)
28
💡 Probability, lottery odds.
Syntax
COMBINA(number, number_chosen)
Number of combinations with repetitions.
Contoh
=COMBINA(4,3)
20
Syntax
COMPLEX(real_num, i_num, [suffix])
Bina complex number dari real + imaginary.
Contoh
=COMPLEX(3,4)
"3+4i"
Syntax
CONCAT(text1, [text2], ...)
Combine text. Replacement modern untuk CONCATENATE — accepts ranges.
Contoh
=CONCAT(A1:A10)
💡 Combine column values.
Syntax
CONCATENATE(text1, [text2], ...)
Combine text. Legacy — pakai CONCAT atau <code>&</code>.
Contoh
=CONCATENATE(A2," ",B2)
Syntax
CONFIDENCE(alpha, standard_dev, size)
Legacy. Pakai CONFIDENCE.NORM.
Contoh
=CONFIDENCE(0.05,2.5,50)
Syntax
CONFIDENCE.NORM(alpha, std_dev, size)
Confidence interval untuk population mean (normal distribution).
Contoh
=CONFIDENCE.NORM(0.05,2.5,50)
Syntax
CONFIDENCE.T(alpha, std_dev, size)
Confidence interval (Student t distribution).
Contoh
=CONFIDENCE.T(0.05,1,50)
Syntax
CONVERT(number, from_unit, to_unit)
Convert between measurement units.
Contoh
=CONVERT(100,"km","mi")
≈ 62.14 miles
Syntax
CORREL(array1, array2)
Correlation coefficient antara dua dataset (-1 to 1).
Contoh
=CORREL(A:A,B:B)
💡 Test relationship antara variables.
Syntax
COS(number)
Cosine sudut (radian).
Contoh
=COS(0)
1
Syntax
COSH(number)
Hyperbolic cosine.
Contoh
=COSH(1)
Syntax
COT(number)
Cotangent (1/tan).
Contoh
=COT(1)
Syntax
COTH(number)
Hyperbolic cotangent.
Contoh
=COTH(1)
Syntax
COUNT(value1, [value2], ...)
Kira cell yang ada nombor. Text tak masuk.
Contoh
=COUNT(B2:B100)
💡 Berapa numerical entries.
Syntax
COUNTA(value1, [value2], ...)
Kira cell yang TAK kosong (semua jenis data).
Contoh
=COUNTA(A2:A100)
💡 Total active entries.
Syntax
COUNTBLANK(range)
Kira cell kosong dalam range.
Contoh
=COUNTBLANK(B2:B100)
💡 Data quality check.
Syntax
COUNTIF(range, criteria)
Kira cell yang memenuhi syarat.
Contoh
=COUNTIF(B:B,">1000")
Transaksi > RM1000
💡 Count high-value items.
Syntax
COUNTIFS(range1, criteria1, ...)
COUNTIF dengan multiple syarat.
Contoh
=COUNTIFS(A:A,"KL",B:B,">5000")
💡 Segment analysis.
Syntax
COUPDAYBS(settlement, maturity, frequency, [basis])
Days dari coupon period start ke settlement.
Contoh
=COUPDAYBS(...)
Syntax
COUPDAYS(settlement, maturity, frequency, [basis])
Days dalam coupon period that includes settlement.
Contoh
=COUPDAYS(...)
Syntax
COUPDAYSNC(settlement, maturity, frequency, [basis])
Days dari settlement ke next coupon date.
Contoh
=COUPDAYSNC(...)
Syntax
COUPNCD(settlement, maturity, frequency, [basis])
Next coupon date after settlement.
Contoh
=COUPNCD(...)
Syntax
COUPNUM(settlement, maturity, frequency, [basis])
Jumlah coupons payable antara settlement dan maturity.
Contoh
=COUPNUM(...)
Syntax
COUPPCD(settlement, maturity, frequency, [basis])
Previous coupon date before settlement.
Contoh
=COUPPCD(...)
Syntax
COVAR(array1, array2)
Legacy covariance. Pakai COVARIANCE.P.
Contoh
=COVAR(A:A,B:B)
Syntax
COVARIANCE.P(array1, array2)
Population covariance.
Contoh
=COVARIANCE.P(A:A,B:B)
Syntax
COVARIANCE.S(array1, array2)
Sample covariance.
Contoh
=COVARIANCE.S(A:A,B:B)
Syntax
CRITBINOM(trials, probability_s, alpha)
Legacy. Pakai BINOM.INV.
Contoh
=CRITBINOM(6,0.5,0.75)
Syntax
CSC(number)
Cosecant (1/sin).
Contoh
=CSC(1)
Syntax
CSCH(number)
Hyperbolic cosecant.
Contoh
=CSCH(1)
Syntax
CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
KPI property dari Power Pivot cube.
Contoh
=CUBEKPIMEMBER("Sales","KPI",1)
Syntax
CUBEMEMBER(connection, member_expression, [caption])
Member dari cube hierarchy.
Contoh
=CUBEMEMBER("Sales","[Product].[All]")
Syntax
CUBEMEMBERPROPERTY(connection, member_expression, property)
Property value dari cube member.
Contoh
=CUBEMEMBERPROPERTY("Sales","[Product]","Color")
Syntax
CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
Nth member dari ranked set.
Contoh
=CUBERANKEDMEMBER("Sales","[Top10Products]",1)
Syntax
CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
Define set of members from cube.
Contoh
=CUBESET("Sales","[Product].MEMBERS")
Syntax
CUBESETCOUNT(set)
Number of items dalam set.
Contoh
=CUBESETCOUNT(A1)
Syntax
CUBEVALUE(connection, [member_expression1], ...)
Aggregate value from cube.
Contoh
=CUBEVALUE("Sales","[Measures].[Sales]")
Syntax
CUMIPMT(rate, nper, pv, start_period, end_period, type)
Cumulative interest paid between periods.
Contoh
=CUMIPMT(0.05/12,360,200000,1,12,0)
Syntax
CUMPRINC(rate, nper, pv, start_period, end_period, type)
Cumulative principal paid between periods.
Contoh
=CUMPRINC(0.05/12,360,200000,1,12,0)
Syntax
DATE(year, month, day)
Bina date dari 3 nombor.
Contoh
=DATE(2026,5,15)
15/05/2026
💡 Build date dari user input.
Syntax
DATEDIF(start_date, end_date, unit)
Selisih dua tarikh. Unit: Y, M, D, MD, YM, YD.
Contoh
=DATEDIF(A2,TODAY(),"Y")
Umur dalam tahun
💡 Age, tenure, age-in-service.
Syntax
DATEVALUE(date_text)
Convert date text ke serial number.
Contoh
=DATEVALUE("15/5/2026")
Syntax
DAVERAGE(database, field, criteria)
Average dari field dalam database yang match criteria.
Contoh
=DAVERAGE(A1:E20,"Sales",G1:G2)
Syntax
DAY(serial_number)
Hari (1-31) dari tarikh.
Contoh
=DAY(A2)
Syntax
DAYS(end_date, start_date)
Selisih hari antara dua tarikh.
Contoh
=DAYS(B2,A2)
💡 Days outstanding, age.
Syntax
DAYS360(start_date, end_date, [method])
Days based on 360-day year (12×30, accounting).
Contoh
=DAYS360(A2,B2)
Syntax
DB(cost, salvage, life, period, [month])
Fixed-declining balance depreciation.
Contoh
=DB(10000,1000,5,1)
Syntax
DBCS(text)
Convert half-width characters ke full-width.
Contoh
=DBCS("ABC")
Syntax
DCOUNT(database, field, criteria)
Count cells berisi numbers dalam database matching criteria.
Contoh
=DCOUNT(A1:E20,"Sales",G1:G2)
Syntax
DCOUNTA(database, field, criteria)
Count non-blank cells dalam database matching criteria.
Contoh
=DCOUNTA(A1:E20,"Name",G1:G2)
Syntax
DDB(cost, salvage, life, period, [factor])
Double-declining balance depreciation.
Contoh
=DDB(10000,1000,5,1)
Syntax
DEC2BIN(number, [places])
Convert decimal ke binary.
Contoh
=DEC2BIN(10)
"1010"
Syntax
DEC2HEX(number, [places])
Convert decimal ke hexadecimal.
Contoh
=DEC2HEX(255)
"FF"
Syntax
DEC2OCT(number, [places])
Convert decimal ke octal.
Contoh
=DEC2OCT(8)
"10"
Syntax
DECIMAL(text, radix)
Convert text representation dalam base tertentu ke decimal.
Contoh
=DECIMAL("FF",16)
255
Syntax
DEGREES(angle)
Convert radian ke degrees.
Contoh
=DEGREES(PI())
180
Syntax
DELTA(number1, [number2])
Test 2 values equal — return 1 atau 0.
Contoh
=DELTA(5,5)
1
Syntax
DEVSQ(number1, ...)
Sum of squared deviations dari mean.
Contoh
=DEVSQ(B2:B10)
Syntax
DGET(database, field, criteria)
Single record dari database matching criteria.
Contoh
=DGET(A1:E20,"Email",G1:G2)
Syntax
DISC(settlement, maturity, pr, redemption, [basis])
Discount rate untuk security.
Contoh
=DISC(...)
Syntax
DMAX(database, field, criteria)
MAX dari field dalam database matching criteria.
Contoh
=DMAX(A1:E20,"Sales",G1:G2)
Syntax
DMIN(database, field, criteria)
MIN dari field matching criteria.
Contoh
=DMIN(A1:E20,"Sales",G1:G2)
Syntax
DOLLAR(number, [decimals])
Convert number ke text dengan currency format.
Contoh
=DOLLAR(1234.567,2)
"$1,234.57"
Syntax
DOLLARDE(fractional_dollar, fraction)
Convert dollar fraction ke decimal.
Contoh
=DOLLARDE(1.02,16)
Syntax
DOLLARFR(decimal_dollar, fraction)
Convert decimal ke dollar fraction.
Contoh
=DOLLARFR(1.125,16)
Syntax
DPRODUCT(database, field, criteria)
Product of values matching criteria.
Contoh
=DPRODUCT(A1:E20,"Qty",G1:G2)
Syntax
DROP(array, rows, [columns])
Drop specified rows/columns dari array.
Contoh
=DROP(A1:E10,2)
Syntax
DSTDEV(database, field, criteria)
Sample stddev untuk values matching criteria.
Contoh
=DSTDEV(A1:E20,"Score",G1:G2)
Syntax
DSTDEVP(database, field, criteria)
Population stddev untuk matching values.
Contoh
=DSTDEVP(A1:E20,"Score",G1:G2)
Syntax
DSUM(database, field, criteria)
SUM dari field matching criteria.
Contoh
=DSUM(A1:E20,"Sales",G1:G2)
Syntax
DURATION(settlement, maturity, coupon, yld, frequency, [basis])
Macaulay duration of security.
Contoh
=DURATION(...)
Syntax
DVAR(database, field, criteria)
Sample variance untuk matching values.
Contoh
=DVAR(A1:E20,"Score",G1:G2)
Syntax
DVARP(database, field, criteria)
Population variance untuk matching values.
Contoh
=DVARP(A1:E20,"Score",G1:G2)
Syntax
EDATE(start_date, months)
Date N months from start_date.
Contoh
=EDATE(TODAY(),3)
3 bulan dari sekarang
💡 Subscription end date.
Syntax
EFFECT(nominal_rate, npery)
Effective annual interest rate.
Contoh
=EFFECT(0.0525,4)
≈ 5.35%
Syntax
ENCODEURL(text)
URL-encode text (escape special chars).
Contoh
=ENCODEURL("hello world")
"hello%20world"
Syntax
EOMONTH(start_date, months)
Last day of month, N months offset.
Contoh
=EOMONTH(TODAY(),0)
Akhir bulan ni
💡 Month-end reporting.
Syntax
ERF(lower_limit, [upper_limit])
Error function (gauss).
Contoh
=ERF(0.74500)
Syntax
ERF.PRECISE(x)
Error function with precision.
Contoh
=ERF.PRECISE(0.74500)
Syntax
ERFC(x)
Complementary error function.
Contoh
=ERFC(1)
Syntax
ERFC.PRECISE(x)
Complementary error function with precision.
Contoh
=ERFC.PRECISE(1)
Syntax
ERROR.TYPE(error_val)
Number corresponding to error type (1=#NULL!, 2=#DIV/0!, etc.).
Contoh
=ERROR.TYPE(A1)
Syntax
EVEN(number)
Bulatkan ke even integer terdekat (away from zero).
Contoh
=EVEN(3)
4
Syntax
EXACT(text1, text2)
Case-sensitive comparison (return TRUE/FALSE).
Contoh
=EXACT("ABC","abc")
FALSE
Syntax
EXP(number)
e^x — exponential function.
Contoh
=EXP(1)
≈ 2.718 (e)
Syntax
EXPAND(array, rows, [columns], [pad_with])
Expand array ke saiz tertentu, pad dengan value.
Contoh
=EXPAND(A1:B2,3,3,0)
Syntax
EXPON.DIST(x, lambda, cumulative)
Exponential distribution.
Contoh
=EXPON.DIST(0.2,10,TRUE)
Syntax
EXPONDIST(x, lambda, cumulative)
Legacy. Pakai EXPON.DIST.
Contoh
=EXPONDIST(0.2,10,TRUE)
Syntax
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
F probability distribution.
Contoh
=F.DIST(15.2069,6,4,TRUE)
Syntax
F.DIST.RT(x, deg_freedom1, deg_freedom2)
Right-tailed F probability distribution.
Contoh
=F.DIST.RT(15.2069,6,4)
Syntax
F.INV(probability, deg_freedom1, deg_freedom2)
Inverse F probability distribution.
Contoh
=F.INV(0.01,6,4)
Syntax
F.INV.RT(probability, deg_freedom1, deg_freedom2)
Inverse right-tailed F distribution.
Contoh
=F.INV.RT(0.01,6,4)
Syntax
F.TEST(array1, array2)
F-test result — variance equality test.
Contoh
=F.TEST(A:A,B:B)
Syntax
FACT(number)
Factorial — n!.
Contoh
=FACT(5)
120
💡 Probability, combinatorics.
Syntax
FACTDOUBLE(number)
Double factorial (n!! — alternate multiplication).
Contoh
=FACTDOUBLE(7)
105 (7×5×3×1)
Syntax
FALSE()
Logical value FALSE.
Contoh
=FALSE()
Syntax
FDIST(x, deg_freedom1, deg_freedom2)
Legacy. Pakai F.DIST.RT.
Contoh
=FDIST(15.2069,6,4)
Syntax
FILTER(array, include, [if_empty])
Filter range based on boolean criteria. Dynamic array.
Contoh
=FILTER(A:C,B:B>1000)
Rows dengan amount >1000
💡 Dynamic filtered list (Excel 365).
Syntax
FILTERXML(xml, xpath)
Extract data dari XML guna XPath.
Contoh
=FILTERXML(A1,"//item/name")
Syntax
FIND(find_text, within_text, [start_num])
Position of substring (case-sensitive).
Syntax
FINV(probability, deg_freedom1, deg_freedom2)
Legacy. Pakai F.INV.RT.
Contoh
=FINV(0.01,6,4)
Syntax
FISHER(x)
Fisher transformation.
Contoh
=FISHER(0.75)
Syntax
FISHERINV(y)
Inverse Fisher transformation.
Contoh
=FISHERINV(0.9729)
Syntax
FIXED(number, [decimals], [no_commas])
Format number sebagai text dengan fixed decimals.
Contoh
=FIXED(1234.567,1)
"1,234.6"
Syntax
FLOOR(number, significance)
Bulatkan ke bawah ke multiple terdekat. (Legacy — pakai FLOOR.MATH)
Contoh
=FLOOR(2.7,1)
2
Syntax
FLOOR.MATH(number, [significance], [mode])
Bulatkan ke bawah ke nombor bulat atau multiple terdekat.
Contoh
=FLOOR.MATH(4.7)
4
Syntax
FLOOR.PRECISE(number, [significance])
Bulatkan ke bawah, sentiasa negative direction regardless of sign.
Contoh
=FLOOR.PRECISE(-4.3)
-5
Syntax
FLOOR.PRECISE(number)
Same as FLOOR.PRECISE.
Contoh
=FLOOR.PRECISE(4.3)
Syntax
FORECAST(x, known_ys, known_xs)
Legacy. Pakai FORECAST.LINEAR.
Contoh
=FORECAST(30,B:B,A:A)
Syntax
FORECAST.ETS(target_date, values, timeline, ...)
Forecast future value guna exponential triple smoothing (ETS).
Contoh
=FORECAST.ETS(A50,B2:B49,A2:A49)
💡 Sales forecasting.
Syntax
FORECAST.ETS.CONFINT(target_date, values, timeline, ...)
Confidence interval untuk ETS forecast.
Contoh
=FORECAST.ETS.CONFINT(A50,B2:B49,A2:A49)
Syntax
FORECAST.ETS.SEASONALITY(values, timeline, ...)
Detect seasonality pattern dalam time series.
Contoh
=FORECAST.ETS.SEASONALITY(B2:B49,A2:A49)
Syntax
FORECAST.ETS.STAT(values, timeline, statistic_type, ...)
Forecast statistic value.
Contoh
=FORECAST.ETS.STAT(B2:B49,A2:A49,1)
Syntax
FORECAST.LINEAR(x, known_ys, known_xs)
Forecast linear regression value.
Contoh
=FORECAST.LINEAR(30,B:B,A:A)
Syntax
FORMULATEXT(reference)
Return formula sebagai text.
Contoh
=FORMULATEXT(B2)
💡 Document workbook.
Syntax
FREQUENCY(data_array, bins_array)
Frequency distribution — count dalam each bin.
Contoh
=FREQUENCY(A1:A20,B1:B5)
💡 Histogram data.
Syntax
FTEST(array1, array2)
Legacy. Pakai F.TEST.
Contoh
=FTEST(A:A,B:B)
Syntax
FV(rate, nper, pmt, [pv], [type])
Future value of investment dengan regular payments.
Contoh
=FV(6%/12,240,-500)
Save RM500/bulan 20 tahun 6%
💡 Retirement planning.
Syntax
FVSCHEDULE(principal, schedule)
Future value with variable interest rates.
Contoh
=FVSCHEDULE(1000,{0.03,0.04,0.05})
Syntax
GAMMA(number)
Gamma function value.
Contoh
=GAMMA(2.5)
Syntax
GAMMA.DIST(x, alpha, beta, cumulative)
Gamma distribution.
Contoh
=GAMMA.DIST(10.00001131,9,2,TRUE)
Syntax
GAMMA.INV(probability, alpha, beta)
Inverse gamma cumulative distribution.
Contoh
=GAMMA.INV(0.068094,9,2)
Syntax
GAMMADIST(x, alpha, beta, cumulative)
Legacy. Pakai GAMMA.DIST.
Contoh
=GAMMADIST(10,9,2,TRUE)
Syntax
GAMMAINV(probability, alpha, beta)
Legacy. Pakai GAMMA.INV.
Contoh
=GAMMAINV(0.068,9,2)
Syntax
GAMMALN(x)
Natural log of gamma function.
Contoh
=GAMMALN(4.5)
Syntax
GAMMALN.PRECISE(x)
GAMMALN dengan precision tinggi.
Contoh
=GAMMALN.PRECISE(4)
Syntax
GAUSS(x)
0.5 lebih sikit dari standard normal cumulative.
Contoh
=GAUSS(2)
Syntax
GCD(number1, [number2], ...)
Greatest common divisor — terbesar antara nombor.
Contoh
=GCD(12,18)
6
Syntax
GEOMEAN(number1, ...)
Geometric mean — Nth root of product.
Contoh
=GEOMEAN(B2:B10)
💡 Average growth rate.
Syntax
GESTEP(number, [step])
Test number ≥ step — return 1 atau 0.
Contoh
=GESTEP(5,4)
1
Syntax
GETPIVOTDATA(data_field, pivot_table, ...)
Extract data dari Pivot Table.
Contoh
=GETPIVOTDATA("Sales",A3,"Region","KL")
Syntax
GROWTH(known_ys, [known_xs], [new_xs], [const])
Predict exponential growth values.
Contoh
=GROWTH(B2:B10)
Syntax
HARMEAN(number1, ...)
Harmonic mean.
Contoh
=HARMEAN(B2:B10)
Syntax
HEX2BIN(number, [places])
Convert hexadecimal ke binary.
Contoh
=HEX2BIN("F",8)
"00001111"
Syntax
HEX2DEC(number)
Convert hexadecimal ke decimal.
Contoh
=HEX2DEC("A5")
165
Syntax
HEX2OCT(number, [places])
Convert hexadecimal ke octal.
Contoh
=HEX2OCT("F",3)
"017"
Syntax
HLOOKUP(lookup_value, table_array, row_index, [range_lookup])
Lookup horizontal (search dalam baris). Legacy — pakai XLOOKUP.
Contoh
=HLOOKUP("Jan",A1:M5,3,FALSE)
Syntax
HOUR(serial_number)
Jam (0-23) dari time value.
Contoh
=HOUR(NOW())
Syntax
HSTACK(array1, [array2], ...)
Stack arrays horizontally.
Contoh
=HSTACK(A1:A5,B1:B5)
Syntax
HYPERLINK(link_location, [friendly_name])
Create clickable hyperlink.
Contoh
=HYPERLINK("https://excel.dhumy.com","Go")
Syntax
HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)
Hypergeometric distribution.
Contoh
=HYPGEOM.DIST(1,4,8,20,TRUE)
Syntax
HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)
Legacy. Pakai HYPGEOM.DIST.
Contoh
=HYPGEOMDIST(1,4,8,20)
Syntax
IF(logical_test, value_if_true, value_if_false)
Conditional. Test syarat, return satu daripada dua nilai.
Contoh
=IF(B2>1000,"High","Low")
💡 Pass/fail, threshold checks.
Syntax
IFERROR(value, value_if_error)
Catch any error → alternative value.
Contoh
=IFERROR(A2/B2,0)
Avoid #DIV/0!
💡 Clean dashboard dari error messages.
Syntax
IFNA(value, value_if_na)
Catch #N/A error specifically.
Contoh
=IFNA(VLOOKUP(A2,D,2,0),"Not Found")
Syntax
IFS(condition1, value1, [condition2, value2], ...)
Multiple conditions tanpa nested IF.
Contoh
=IFS(B2>=80,"A",B2>=60,"B",TRUE,"C")
💡 Grading, tier classification.
Syntax
IMABS(inumber)
Absolute value (modulus) of complex number.
Contoh
=IMABS("5+12i")
13
Syntax
IMAGE(source, [alt_text], [sizing], [height], [width])
Insert image dari URL.
Contoh
=IMAGE("https://example.com/logo.png")
Syntax
IMAGINARY(inumber)
Imaginary coefficient of complex number.
Contoh
=IMAGINARY("3+4i")
4
Syntax
IMARGUMENT(inumber)
Argument theta of complex number.
Contoh
=IMARGUMENT("3+4i")
Syntax
IMCONJUGATE(inumber)
Complex conjugate.
Contoh
=IMCONJUGATE("3+4i")
"3-4i"
Syntax
IMCOS(inumber)
Cosine of complex number.
Contoh
=IMCOS("1+i")
Syntax
IMCOSH(inumber)
Hyperbolic cosine of complex.
Contoh
=IMCOSH("4+3i")
Syntax
IMCOT(inumber)
Cotangent of complex.
Contoh
=IMCOT("4+3i")
Syntax
IMCSC(inumber)
Cosecant of complex.
Contoh
=IMCSC("4+3i")
Syntax
IMCSCH(inumber)
Hyperbolic cosecant of complex.
Contoh
=IMCSCH("4+3i")
Syntax
IMDIV(inumber1, inumber2)
Quotient of two complex numbers.
Contoh
=IMDIV("-238+240i","10+24i")
Syntax
IMEXP(inumber)
Exponential of complex.
Contoh
=IMEXP("1+i")
Syntax
IMLN(inumber)
Natural log of complex.
Contoh
=IMLN("3+4i")
Syntax
IMLOG10(inumber)
Base-10 log of complex.
Contoh
=IMLOG10("3+4i")
Syntax
IMLOG2(inumber)
Base-2 log of complex.
Contoh
=IMLOG2("3+4i")
Syntax
IMPOWER(inumber, number)
Complex number raised to integer power.
Contoh
=IMPOWER("2+3i",3)
Syntax
IMPRODUCT(inumber1, ...)
Product of complex numbers.
Contoh
=IMPRODUCT("3+4i","5-3i")
Syntax
IMREAL(inumber)
Real coefficient of complex.
Contoh
=IMREAL("6-9i")
6
Syntax
IMSEC(inumber)
Secant of complex.
Contoh
=IMSEC("4+3i")
Syntax
IMSECH(inumber)
Hyperbolic secant of complex.
Contoh
=IMSECH("4+3i")
Syntax
IMSIN(inumber)
Sine of complex.
Contoh
=IMSIN("3+4i")
Syntax
IMSINH(inumber)
Hyperbolic sine of complex.
Contoh
=IMSINH("4+3i")
Syntax
IMSQRT(inumber)
Square root of complex.
Contoh
=IMSQRT("1+i")
Syntax
IMSUB(inumber1, inumber2)
Difference of complex numbers.
Contoh
=IMSUB("13+4i","5+3i")
Syntax
IMSUM(inumber1, ...)
Sum of complex numbers.
Contoh
=IMSUM("3+4i","5-3i")
Syntax
IMTAN(inumber)
Tangent of complex.
Contoh
=IMTAN("4+3i")
Syntax
INDEX(array, row_num, [column_num])
Return cell di posisi (row, col) tertentu.
Contoh
=INDEX(A:C,5,2)
💡 Combo dengan MATCH untuk flexible lookup.
Syntax
INDIRECT(ref_text, [a1])
Convert text string ke cell reference.
Contoh
=INDIRECT("A"&B1)
💡 Dynamic sheet references.
Syntax
INFO(type_text)
Info pasal operating environment.
Contoh
=INFO("system")
"pcdos"/"mac"
Syntax
INT(number)
Bulatkan ke bawah ke integer terdekat (towards negative infinity).
Contoh
=INT(8.9)
8
💡 Truncate decimal portion.
Syntax
INTERCEPT(known_ys, known_xs)
Y-intercept of linear regression line.
Contoh
=INTERCEPT(B:B,A:A)
Syntax
INTRATE(settlement, maturity, investment, redemption, [basis])
Interest rate untuk fully invested security.
Contoh
=INTRATE(...)
Syntax
IPMT(rate, per, nper, pv, [fv], [type])
Interest portion of loan payment.
Contoh
=IPMT(5%/12,1,360,200000)
Syntax
IRR(values, [guess])
Internal rate of return untuk cash flows.
Contoh
=IRR(A1:A6)
💡 Investment return analysis.
Syntax
ISBLANK(value)
TRUE kalau cell kosong.
Contoh
=ISBLANK(A1)
💡 Validate input completeness.
Syntax
ISERR(value)
TRUE kalau error (kecuali #N/A).
Contoh
=ISERR(A1/B1)
Syntax
ISERROR(value)
TRUE kalau ada error (any type).
Contoh
=ISERROR(VLOOKUP(...))
💡 Defensive checks.
Syntax
ISEVEN(number)
TRUE kalau number even.
Contoh
=ISEVEN(4)
TRUE
Syntax
ISFORMULA(reference)
TRUE kalau cell ada formula.
Contoh
=ISFORMULA(B2)
Syntax
ISLOGICAL(value)
TRUE kalau value logical (TRUE/FALSE).
Contoh
=ISLOGICAL(A1)
Syntax
ISNA(value)
TRUE kalau #N/A error.
Contoh
=ISNA(VLOOKUP(...))
Syntax
ISNONTEXT(value)
TRUE kalau bukan text.
Contoh
=ISNONTEXT(A1)
Syntax
ISNUMBER(value)
TRUE kalau number.
Contoh
=ISNUMBER(A1)
💡 Validate numeric input.
Syntax
ISO.CEILING(number, [significance])
Bulatkan ke atas (ISO standard — sama macam CEILING.PRECISE).
Contoh
=ISO.CEILING(4.3)
5
Syntax
ISODD(number)
TRUE kalau number odd.
Contoh
=ISODD(7)
TRUE
Syntax
ISOMITTED(argument)
TRUE kalau argument LAMBDA tak diberikan.
Contoh
=LAMBDA(x,IF(ISOMITTED(x),0,x))
Syntax
ISOWEEKNUM(date)
ISO 8601 week number.
Contoh
=ISOWEEKNUM(TODAY())
Syntax
ISPMT(rate, per, nper, pv)
Interest paid during specific period.
Contoh
=ISPMT(5%/12,1,360,200000)
Syntax
ISREF(value)
TRUE kalau value reference.
Contoh
=ISREF(A1)
Syntax
ISTEXT(value)
TRUE kalau value text.
Contoh
=ISTEXT(A1)
Syntax
KURT(number1, ...)
Kurtosis — peakedness of distribution.
Contoh
=KURT(B2:B10)
Syntax
LAMBDA([parameter1, parameter2, ...], calculation)
Define reusable custom function tanpa VBA.
Contoh
=LAMBDA(x,x*2)(5)
10
Syntax
LARGE(array, k)
Nth largest value dalam range.
Contoh
=LARGE(B:B,2)
2nd highest
💡 Top-N dashboard metric.
Syntax
LCM(number1, [number2], ...)
Least common multiple — terkecil yang divisible.
Contoh
=LCM(4,6)
12
Syntax
LEFT(text, [num_chars])
X karakter dari kiri.
Contoh
=LEFT(A2,3)
3 huruf pertama
💡 Extract prefix code.
Syntax
LEN(text)
Jumlah karakter dalam text.
Contoh
=LEN(A2)
💡 Validate IC length.
Syntax
LET(name1, value1, [name2, value2], ..., calculation)
Assign names ke values dalam formula untuk readability.
Contoh
=LET(x,B2,x*0.06)
💡 Simplify complex formulas.
Syntax
LINEST(known_ys, [known_xs], [const], [stats])
Linear regression statistics array.
Contoh
=LINEST(B:B,A:A)
Syntax
LN(number)
Natural logarithm (base e).
Contoh
=LN(EXP(1))
1
Syntax
LOG(number, [base])
Logarithm dengan base custom (default base 10).
Contoh
=LOG(100,10)
2
Syntax
LOG10(number)
Logarithm base 10.
Contoh
=LOG10(1000)
3
Syntax
LOGEST(known_ys, [known_xs], [const], [stats])
Exponential regression statistics array.
Contoh
=LOGEST(B:B,A:A)
Syntax
LOGINV(probability, mean, standard_dev)
Legacy. Pakai LOGNORM.INV.
Contoh
=LOGINV(0.039,3.5,1.2)
Syntax
LOGNORM.DIST(x, mean, standard_dev, cumulative)
Lognormal distribution.
Contoh
=LOGNORM.DIST(4,3.5,1.2,TRUE)
Syntax
LOGNORM.INV(probability, mean, standard_dev)
Inverse lognormal cumulative distribution.
Contoh
=LOGNORM.INV(0.0390835,3.5,1.2)
Syntax
LOGNORMDIST(x, mean, standard_dev)
Legacy. Pakai LOGNORM.DIST.
Contoh
=LOGNORMDIST(4,3.5,1.2)
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
Lookup dalam single row/column. Legacy — pakai XLOOKUP/VLOOKUP.
Contoh
=LOOKUP("Apple",A:A,B:B)
Syntax
LOWER(text)
Tukar text ke huruf kecil.
Contoh
=LOWER(A2)
💡 Email standardization.
Syntax
MAKEARRAY(rows, cols, lambda)
Create array dengan formula per cell.
Contoh
=MAKEARRAY(3,3,LAMBDA(r,c,r*c))
Syntax
MAP(array1, [array2], ..., lambda)
Apply LAMBDA to each element of array(s).
Contoh
=MAP(A1:A5,LAMBDA(x,x*2))
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Position of value dalam array.
Contoh
=MATCH("Apple",A:A,0)
💡 Pair dengan INDEX untuk lookup.
Syntax
MAX(number1, [number2], ...)
Nilai terbesar dalam range.
Contoh
=MAX(B2:B13)
Bulan revenue tertinggi
💡 Peak revenue, highest expense.
Syntax
MAXA(value1, [value2], ...)
MAX termasuk text (TRUE=1, FALSE=0).
Contoh
=MAXA(A:A)
Syntax
MAXIFS(max_range, criteria_range1, criteria1, ...)
MAX dengan multiple conditions.
Contoh
=MAXIFS(C:C,A:A,"KL",B:B,"2026")
💡 Highest sale in region.
Syntax
MDETERM(array)
Matrix determinant.
Contoh
=MDETERM(A1:B2)
Syntax
MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
Modified Macaulay duration.
Contoh
=MDURATION(...)
Syntax
MEDIAN(number1, [number2], ...)
Middle value (nilai tengah).
Contoh
=MEDIAN(B:B)
💡 Robust central tendency (ignores outliers).
Syntax
MID(text, start_num, num_chars)
Karakter dari tengah, mulai posisi tertentu.
Contoh
=MID(A2,4,3)
💡 Parse IC, structured codes.
Syntax
MIN(number1, [number2], ...)
Nilai terkecil dalam range.
Contoh
=MIN(B2:B13)
Bulan paling sikit
💡 Lowest stock price.
Syntax
MINA(value1, [value2], ...)
MIN termasuk text.
Contoh
=MINA(A:A)
Syntax
MINIFS(min_range, criteria_range1, criteria1, ...)
MIN dengan multiple conditions.
Contoh
=MINIFS(C:C,A:A,"KL")
Syntax
MINUTE(serial_number)
Minit (0-59) dari time value.
Contoh
=MINUTE(NOW())
Syntax
MINVERSE(array)
Matrix inverse.
Contoh
=MINVERSE(A1:B2)
Syntax
MIRR(values, finance_rate, reinvest_rate)
Modified IRR — different finance/reinvest rates.
Contoh
=MIRR(A1:A6,5%,3%)
Syntax
MMULT(array1, array2)
Matrix multiplication.
Contoh
=MMULT(A1:B2,C1:D2)
Syntax
MOD(number, divisor)
Remainder selepas division.
Contoh
=MOD(10,3)
1 (baki)
💡 Even/odd check, alternating rows.
Syntax
MODE(number1, ...)
Legacy. Pakai MODE.SNGL.
Contoh
=MODE(B:B)
Syntax
MODE.MULT(number1, ...)
Return multiple modes (jika ada).
Contoh
=MODE.MULT(B:B)
Syntax
MODE.SNGL(number1, ...)
Most frequent value (single mode).
Contoh
=MODE.SNGL(B:B)
Syntax
MONTH(serial_number)
Bulan (1-12) dari tarikh.
Contoh
=MONTH(A2)
💡 Group data by month.
Syntax
MROUND(number, multiple)
Bulatkan ke multiple terdekat (nearest).
Contoh
=MROUND(7,5)
5
Syntax
MULTINOMIAL(number1, [number2], ...)
Multinomial coefficient — (sum)! / (prod of factorials).
Contoh
=MULTINOMIAL(2,3,4)
1260
Syntax
MUNIT(dimension)
Unit matrix (identity matrix) dengan dimensi tertentu.
Contoh
=MUNIT(3)
3×3 identity
Syntax
N(value)
Convert value ke number (text → 0).
Contoh
=N("text")
Syntax
NA()
Force #N/A error.
Contoh
=NA()
Syntax
NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
Negative binomial distribution.
Contoh
=NEGBINOM.DIST(10,5,0.25,TRUE)
Syntax
NEGBINOMDIST(number_f, number_s, probability_s)
Legacy. Pakai NEGBINOM.DIST.
Contoh
=NEGBINOMDIST(10,5,0.25)
Syntax
NETWORKDAYS(start_date, end_date, [holidays])
Working days (excl. weekends & holidays).
Contoh
=NETWORKDAYS(A2,B2)
💡 Project days calculation.
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Working days dengan custom weekend definition.
Contoh
=NETWORKDAYS.INTL(A2,B2,11)
Syntax
NOMINAL(effect_rate, npery)
Nominal annual interest rate.
Contoh
=NOMINAL(0.053543,4)
≈ 5.25%
Syntax
NORM.DIST(x, mean, standard_dev, cumulative)
Normal distribution.
Contoh
=NORM.DIST(42,40,1.5,TRUE)
Syntax
NORM.INV(probability, mean, standard_dev)
Inverse normal cumulative distribution.
Contoh
=NORM.INV(0.908789,40,1.5)
Syntax
NORM.S.DIST(z, cumulative)
Standard normal distribution.
Contoh
=NORM.S.DIST(1.333333,TRUE)
Syntax
NORM.S.INV(probability)
Inverse standard normal cumulative.
Contoh
=NORM.S.INV(0.908789)
Syntax
NORMDIST(x, mean, standard_dev, cumulative)
Legacy. Pakai NORM.DIST.
Contoh
=NORMDIST(42,40,1.5,TRUE)
Syntax
NORMINV(probability, mean, standard_dev)
Legacy. Pakai NORM.INV.
Contoh
=NORMINV(0.908,40,1.5)
Syntax
NORMSDIST(z)
Legacy. Pakai NORM.S.DIST.
Contoh
=NORMSDIST(1.33)
Syntax
NORMSINV(probability)
Legacy. Pakai NORM.S.INV.
Contoh
=NORMSINV(0.908)
Syntax
NOT(logical)
Reverse boolean (TRUE↔FALSE).
Contoh
=NOT(B2=0)
Syntax
NOW()
Tarikh + masa semasa (auto-update).
Contoh
=NOW()
15/5/2026 14:30
💡 Timestamp log.
Syntax
NPER(rate, pmt, pv, [fv], [type])
Number of periods untuk investment.
Contoh
=NPER(5%/12,-500,200000)
💡 Years to pay off loan.
Syntax
NPV(rate, value1, [value2], ...)
Net Present Value of cash flows.
Contoh
=NPV(10%,-10000,3000,4500,6000)
💡 Capital budgeting.
Syntax
NUMBERVALUE(text, [decimal_separator], [group_separator])
Convert text ke number dengan locale-specific separators.
Contoh
=NUMBERVALUE("1.234,56",",",".")
Syntax
OCT2BIN(number, [places])
Convert octal ke binary.
Contoh
=OCT2BIN("3",3)
"011"
Syntax
OCT2DEC(number)
Convert octal ke decimal.
Contoh
=OCT2DEC("54")
44
Syntax
OCT2HEX(number, [places])
Convert octal ke hexadecimal.
Contoh
=OCT2HEX("100",4)
"0040"
Syntax
ODD(number)
Bulatkan ke odd integer terdekat (away from zero).
Contoh
=ODD(2)
3
Syntax
ODDFPRICE(...)
Price for security with odd first period.
Contoh
=ODDFPRICE(...)
Syntax
ODDFYIELD(...)
Yield for security with odd first period.
Contoh
=ODDFYIELD(...)
Syntax
ODDLPRICE(...)
Price for security with odd last period.
Contoh
=ODDLPRICE(...)
Syntax
ODDLYIELD(...)
Yield for security with odd last period.
Contoh
=ODDLYIELD(...)
Syntax
OFFSET(reference, rows, cols, [height], [width])
Return reference offset from base.
Contoh
=OFFSET(A1,5,2)
💡 Dynamic ranges.
Syntax
OR(logical1, [logical2], ...)
TRUE kalau MANA-MANA syarat betul.
Contoh
=IF(OR(B2="VIP",C2>10000),"Priority","Normal")
Syntax
PDURATION(rate, pv, fv)
Periods untuk reach investment target.
Contoh
=PDURATION(0.025,2000,2200)
Syntax
PEARSON(array1, array2)
Pearson correlation coefficient (sama macam CORREL).
Contoh
=PEARSON(A:A,B:B)
Syntax
PERCENTILE(array, k)
Legacy. Pakai PERCENTILE.INC.
Contoh
=PERCENTILE(B:B,0.5)
Syntax
PERCENTILE.EXC(array, k)
Kth percentile (exclusive — k strictly between 0-1).
Contoh
=PERCENTILE.EXC(B:B,0.25)
Syntax
PERCENTILE.INC(array, k)
Kth percentile (inclusive — k between 0-1).
Contoh
=PERCENTILE.INC(B:B,0.5)
Median
Syntax
PERCENTRANK(array, x, [significance])
Legacy. Pakai PERCENTRANK.INC.
Contoh
=PERCENTRANK(A:A,A2)
Syntax
PERCENTRANK.EXC(array, x, [significance])
Rank of value sebagai percentage (exclusive).
Contoh
=PERCENTRANK.EXC(A:A,A2)
Syntax
PERCENTRANK.INC(array, x, [significance])
Rank of value sebagai percentage (inclusive).
Contoh
=PERCENTRANK.INC(A:A,A2)
Syntax
PERMUT(number, number_chosen)
Number of permutations.
Contoh
=PERMUT(100,3)
Syntax
PERMUTATIONA(number, number_chosen)
Permutations with repetition.
Contoh
=PERMUTATIONA(3,2)
9
Syntax
PHI(x)
Density function for standard normal distribution.
Contoh
=PHI(0.75)
Syntax
PI()
Nilai π (≈ 3.14159265358979).
Contoh
=PI()
Syntax
PMT(rate, nper, pv, [fv], [type])
Monthly payment untuk loan. Rate dibahagi 12 untuk monthly.
Contoh
=PMT(5%/12,36,50000)
Car loan monthly
💡 Loan amortization.
Syntax
POISSON(x, mean, cumulative)
Legacy. Pakai POISSON.DIST.
Contoh
=POISSON(2,5,TRUE)
Syntax
POISSON.DIST(x, mean, cumulative)
Poisson distribution.
Contoh
=POISSON.DIST(2,5,TRUE)
Syntax
POWER(number, power)
Kuasa — number^power. Setara dengan operator <code>^</code>.
Contoh
=POWER(2,10)
1024
💡 Compound calculations.
Syntax
PPMT(rate, per, nper, pv, [fv], [type])
Principal portion of loan payment.
Contoh
=PPMT(5%/12,1,360,200000)
Syntax
PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
Price per RM100 face value of security.
Contoh
=PRICE(...)
Syntax
PRICEDISC(settlement, maturity, discount, redemption, [basis])
Price of discounted security.
Contoh
=PRICEDISC(...)
Syntax
PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
Price of security paying interest at maturity.
Contoh
=PRICEMAT(...)
Syntax
PROB(x_range, prob_range, [lower_limit], [upper_limit])
Probability values dalam range.
Contoh
=PROB(A:A,B:B,1,3)
Syntax
PRODUCT(number1, [number2], ...)
Multiply semua nombor dalam range.
Contoh
=PRODUCT(2,3,4)
24
Syntax
PROPER(text)
Title Case — capitalize setiap perkataan.
Contoh
=PROPER("ali baba")
"Ali Baba"
💡 Format nama customer.
Syntax
PV(rate, nper, pmt, [fv], [type])
Present value of investment.
Contoh
=PV(5%/12,60,-1000)
💡 Investment valuation.
Syntax
QUARTILE(array, quart)
Legacy. Pakai QUARTILE.INC.
Contoh
=QUARTILE(A:A,1)
Syntax
QUARTILE.EXC(array, quart)
Quartile (exclusive).
Contoh
=QUARTILE.EXC(A:A,1)
Syntax
QUARTILE.INC(array, quart)
Quartile (inclusive).
Contoh
=QUARTILE.INC(A:A,2)
Median (Q2)
Syntax
QUOTIENT(numerator, denominator)
Integer portion dari division (drop remainder).
Contoh
=QUOTIENT(10,3)
3
Syntax
RADIANS(angle)
Convert degrees ke radians.
Contoh
=RADIANS(180)
π ≈ 3.14159
Syntax
RAND()
Random number antara 0 dan 1 (auto-recalculate).
Contoh
=RAND()
cth: 0.7384
💡 Generate sample data.
Syntax
RANDARRAY([rows], [cols], [min], [max], [integer])
Array of random numbers dengan saiz tertentu (Excel 365).
Contoh
=RANDARRAY(5,2,1,100,TRUE)
5×2 random integers 1-100
Syntax
RANDBETWEEN(bottom, top)
Random integer antara dua nombor.
Contoh
=RANDBETWEEN(1,100)
random 1-100
💡 Sample data generation.
Syntax
RANK(number, ref, [order])
Legacy. Pakai RANK.EQ atau RANK.AVG.
Contoh
=RANK(B2,B:B,0)
Syntax
RANK.AVG(number, ref, [order])
Rank, tied values get average rank.
Contoh
=RANK.AVG(B2,B:B,0)
Syntax
RANK.EQ(number, ref, [order])
Rank, tied values get same (top) rank.
Contoh
=RANK.EQ(B2,B:B,0)
💡 Leaderboard ranking.
Syntax
RATE(nper, pmt, pv, [fv], [type], [guess])
Interest rate per period.
Contoh
=RATE(48,-200,8000)*12
💡 Reverse-engineer loan rate.
Syntax
RECEIVED(settlement, maturity, investment, discount, [basis])
Amount received at maturity for fully invested security.
Contoh
=RECEIVED(...)
Syntax
REDUCE([initial_value], array, lambda)
Reduce array ke single value via accumulator.
Contoh
=REDUCE(0,A1:A5,LAMBDA(acc,x,acc+x))
Syntax
REPLACE(old_text, start_num, num_chars, new_text)
Replace portion of text by position.
Contoh
=REPLACE(A2,1,3,"XXX")
Syntax
REPT(text, number_times)
Repeat text N kali.
Contoh
=REPT("★",5)
"★★★★★"
💡 In-cell rating bars.
Syntax
RIGHT(text, [num_chars])
X karakter dari kanan.
Contoh
=RIGHT(A2,4)
Last 4 digits
Syntax
ROMAN(number, [form])
Convert nombor Arabic ke Roman numeral text.
Contoh
=ROMAN(2024)
"MMXXIV"
Syntax
ROUND(number, num_digits)
Bulatkan nombor ke decimal places tertentu (standard rounding).
Contoh
=ROUND(3.14159,2)
3.14
💡 Display angka cantik dalam dashboard.
Syntax
ROUNDDOWN(number, num_digits)
Bulatkan ke bawah (towards zero).
Contoh
=ROUNDDOWN(3.9,0)
3
Syntax
ROUNDUP(number, num_digits)
Bulatkan ke atas (away from zero).
Contoh
=ROUNDUP(3.1,0)
4
Syntax
ROW([reference])
Row number dari reference.
Contoh
=ROW(B5)
5
Syntax
ROWS(array)
Jumlah rows dalam reference.
Contoh
=ROWS(A1:A10)
10
Syntax
RRI(nper, pv, fv)
Equivalent interest rate untuk investment growth.
Contoh
=RRI(8,10000,11000)
Syntax
RSQ(known_ys, known_xs)
R-squared (coefficient of determination).
Contoh
=RSQ(B:B,A:A)
Syntax
SCAN([initial_value], array, lambda)
Running aggregate — return all intermediate values.
Contoh
=SCAN(0,A1:A5,LAMBDA(a,x,a+x))
Running total
Syntax
SEARCH(find_text, within_text, [start_num])
Position of substring (case-insensitive, supports wildcards).
Contoh
=SEARCH("@",A2)
Syntax
SEC(number)
Secant (1/cos).
Contoh
=SEC(0)
1
Syntax
SECH(number)
Hyperbolic secant.
Contoh
=SECH(0)
1
Syntax
SECOND(serial_number)
Saat (0-59) dari time value.
Contoh
=SECOND(NOW())
Syntax
SERIESSUM(x, n, m, coefficients)
Sum power series — x^n + x^(n+m) + ...
Contoh
=SERIESSUM(2,1,1,{1,2,3})
Syntax
SHEET([value])
Sheet number untuk referenced sheet.
Contoh
=SHEET()
Syntax
SHEETS([reference])
Jumlah sheets dalam reference.
Contoh
=SHEETS()
Syntax
SIGN(number)
Return 1 (positive), -1 (negative), atau 0.
Contoh
=SIGN(-50)
-1
💡 Conditional formatting based on sign.
Syntax
SIN(number)
Sine sudut (radian).
Contoh
=SIN(PI()/2)
1
Syntax
SINH(number)
Hyperbolic sine.
Contoh
=SINH(0)
Syntax
SKEW(number1, ...)
Skewness of distribution (asymmetry).
Contoh
=SKEW(B:B)
Syntax
SKEW.P(number1, ...)
Population skewness.
Contoh
=SKEW.P(B:B)
Syntax
SLN(cost, salvage, life)
Straight-line depreciation per period.
Contoh
=SLN(30000,7500,10)
2,250/year
Syntax
SLOPE(known_ys, known_xs)
Slope of linear regression line.
Contoh
=SLOPE(B:B,A:A)
Syntax
SMALL(array, k)
Nth smallest value dalam range.
Contoh
=SMALL(B:B,2)
2nd lowest
Syntax
SORT(array, [sort_index], [sort_order], [by_col])
Sort array — dynamic. Auto-update bila data berubah.
Contoh
=SORT(A2:B10,2,-1)
Sort by col 2 desc
Syntax
SORTBY(array, by_array1, [sort_order1], ...)
Sort array by reference array.
Contoh
=SORTBY(A2:A10,B2:B10,-1)
Syntax
SQRT(number)
Square root.
Contoh
=SQRT(144)
12
Syntax
SQRTPI(number)
Square root of (number × π).
Contoh
=SQRTPI(1)
≈ 1.7725
Syntax
STANDARDIZE(x, mean, standard_dev)
Z-score (normalized value).
Contoh
=STANDARDIZE(42,40,1.5)
Syntax
STDEV(number1, ...)
Legacy sample stddev. Pakai STDEV.S.
Contoh
=STDEV(B:B)
Syntax
STDEV.P(number1, ...)
Population standard deviation.
Contoh
=STDEV.P(B:B)
Syntax
STDEV.S(number1, ...)
Sample standard deviation.
Contoh
=STDEV.S(B:B)
💡 Variability of data.
Syntax
STDEVA(value1, ...)
Sample stddev termasuk text/logical.
Contoh
=STDEVA(A:A)
Syntax
STDEVP(number1, ...)
Legacy population stddev. Pakai STDEV.P.
Contoh
=STDEVP(B:B)
Syntax
STDEVPA(value1, ...)
Population stddev termasuk text/logical.
Contoh
=STDEVPA(A:A)
Syntax
STEYX(known_ys, known_xs)
Standard error of predicted y for each x.
Contoh
=STEYX(B:B,A:A)
Syntax
STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [properties]...)
Stock price history dari Microsoft data source.
Contoh
=STOCKHISTORY("MSFT","1/1/2024")
Syntax
SUBSTITUTE(text, old_text, new_text, [instance_num])
Replace specific text occurrences.
Contoh
=SUBSTITUTE(A2,"-","")
💡 Remove dashes from phone.
Syntax
SUBTOTAL(function_num, ref1, ...)
Aggregate dengan filtered/hidden rows awareness — SUM, AVG, COUNT, dll.
Contoh
=SUBTOTAL(9,B2:B100)
SUM visible only
💡 Dynamic totals dalam filtered table.
Syntax
SUM(number1, [number2], ...)
Jumlahkan semua nombor dalam range/argument.
Contoh
=SUM(B2:B10)
Total revenue Jan-Dec
💡 Total sales, expenses, quantity.
Syntax
SUMIF(range, criteria, [sum_range])
Sum dengan satu syarat (criteria).
Contoh
=SUMIF(A:A,"Food",B:B)
Total Food expenses
💡 Total by category.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, ...)
Sum dengan multiple syarat. Sum_range dulu (berbeza dari SUMIF).
Contoh
=SUMIFS(C:C,A:A,"2026",B:B,"Sales")
2026 Sales only
💡 Dashboard totals by month + category.
Syntax
SUMPRODUCT(array1, [array2], ...)
Multiply corresponding values then sum. Powerful untuk weighted calcs.
Contoh
=SUMPRODUCT(qty,price)
Total revenue
💡 Weighted average, multi-criteria sum (pre-SUMIFS).
Syntax
SUMSQ(number1, [number2], ...)
Sum of squares — x1² + x2² + ...
Contoh
=SUMSQ(2,3,4)
29 (4+9+16)
Syntax
SUMX2MY2(array_x, array_y)
Sum of (x² - y²) untuk corresponding values.
Contoh
=SUMX2MY2(A:A,B:B)
Syntax
SUMX2PY2(array_x, array_y)
Sum of (x² + y²) untuk corresponding values.
Contoh
=SUMX2PY2(A:A,B:B)
Syntax
SUMXMY2(array_x, array_y)
Sum of (x - y)² — squared differences.
Contoh
=SUMXMY2(actual,forecast)
💡 Forecast accuracy metrics.
Syntax
SWITCH(expression, value1, result1, [value2, result2], ..., [default])
Cleaner alternative untuk nested IF.
Contoh
=SWITCH(A2,"Jan",1,"Feb",2,"Mar",3,0)
Syntax
SYD(cost, salvage, life, per)
Sum-of-years depreciation.
Contoh
=SYD(30000,7500,10,1)
Syntax
T(value)
Return text kalau value text, else empty.
Contoh
=T(A2)
Syntax
T.DIST(x, deg_freedom, cumulative)
Student t distribution.
Contoh
=T.DIST(60,1,TRUE)
Syntax
T.DIST.2T(x, deg_freedom)
Two-tailed Student t distribution.
Contoh
=T.DIST.2T(1.96,60)
Syntax
T.DIST.RT(x, deg_freedom)
Right-tailed Student t distribution.
Contoh
=T.DIST.RT(1.96,60)
Syntax
T.INV(probability, deg_freedom)
Inverse Student t distribution.
Contoh
=T.INV(0.75,2)
Syntax
T.INV.2T(probability, deg_freedom)
Inverse 2-tailed Student t distribution.
Contoh
=T.INV.2T(0.546449,60)
Syntax
T.TEST(array1, array2, tails, type)
Probability from Student t-test.
Contoh
=T.TEST(A:A,B:B,2,1)
Syntax
TAKE(array, rows, [columns])
Take first/last N rows or columns.
Contoh
=TAKE(A:C,5)
First 5 rows
Syntax
TAN(number)
Tangent sudut (radian).
Contoh
=TAN(0)
Syntax
TANH(number)
Hyperbolic tangent.
Contoh
=TANH(0)
Syntax
TBILLEQ(settlement, maturity, discount)
Bond-equivalent yield untuk Treasury bill.
Contoh
=TBILLEQ(...)
Syntax
TBILLPRICE(settlement, maturity, discount)
Price per RM100 face value untuk T-bill.
Contoh
=TBILLPRICE(...)
Syntax
TBILLYIELD(settlement, maturity, pr)
Yield untuk Treasury bill.
Contoh
=TBILLYIELD(...)
Syntax
TDIST(x, deg_freedom, tails)
Legacy. Pakai T.DIST family.
Contoh
=TDIST(1.96,60,2)
Syntax
TEXT(value, format_text)
Format number sebagai text custom (currency, %, date, dll).
Contoh
=TEXT(0.25,"0.0%")
"25.0%"
💡 Format KPI display dalam dashboard.
Syntax
TEXTAFTER(text, delimiter, [instance_num], ...)
Return text after delimiter occurrence.
Syntax
TEXTBEFORE(text, delimiter, [instance_num], ...)
Return text before delimiter.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, ...)
Cantum text dengan delimiter — boleh skip empty cells.
Contoh
=TEXTJOIN(",",TRUE,A:A)
💡 Combine list dengan koma.
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter], ...)
Split text ke array berdasarkan delimiter.
Contoh
=TEXTSPLIT("a,b,c",",")
Syntax
TIME(hour, minute, second)
Bina time dari komponen.
Contoh
=TIME(14,30,0)
2:30 PM
Syntax
TIMEVALUE(time_text)
Convert time text ke serial.
Contoh
=TIMEVALUE("2:30 PM")
Syntax
TINV(probability, deg_freedom)
Legacy. Pakai T.INV.2T.
Contoh
=TINV(0.0546,60)
Syntax
TOCOL(array, [ignore], [scan_by_column])
Convert array ke single column.
Contoh
=TOCOL(A1:C3)
Syntax
TODAY()
Tarikh hari ini (auto-update bila open file).
Contoh
=TODAY()
💡 Dashboard "last updated" stamp.
Syntax
TOROW(array, [ignore], [scan_by_column])
Convert array ke single row.
Contoh
=TOROW(A1:C3)
Syntax
TRANSPOSE(array)
Swap rows dan columns.
Contoh
=TRANSPOSE(A1:E1)
Horizontal → vertical
Syntax
TREND(known_ys, [known_xs], [new_xs], [const])
Predict linear trend values.
Contoh
=TREND(B2:B10,A2:A10)
Syntax
TRIM(text)
Buang extra spaces (leading, trailing, dan multiple internal).
Contoh
=TRIM(A2)
💡 Clean imported CSV data — wajib sebelum VLOOKUP.
Syntax
TRIMMEAN(array, percent)
Mean excluding top/bottom percent of values.
Contoh
=TRIMMEAN(A:A,0.2)
💡 Average minus outliers.
Syntax
TRUE()
Logical value TRUE.
Contoh
=TRUE()
Syntax
TRUNC(number, [num_digits])
Potong decimal places (truncate, no rounding).
Contoh
=TRUNC(3.789,1)
3.7
Syntax
TTEST(array1, array2, tails, type)
Legacy. Pakai T.TEST.
Contoh
=TTEST(A:A,B:B,2,1)
Syntax
TYPE(value)
Type of value (1=num, 2=text, 4=logical, 16=error, 64=array).
Contoh
=TYPE(A1)
Syntax
UNICHAR(number)
Unicode character dari number.
Contoh
=UNICHAR(8364)
"€"
Syntax
UNICODE(text)
Unicode code dari first character.
Contoh
=UNICODE("€")
8364
Syntax
UNIQUE(array, [by_col], [exactly_once])
Distinct values dari range.
Contoh
=UNIQUE(A:A)
Unique customer list
Syntax
UPPER(text)
Tukar text ke HURUF BESAR.
Contoh
=UPPER(A2)
💡 Standardize codes.
Syntax
VALUE(text)
Convert text ke number.
Contoh
=VALUE("1234")
1234
💡 Fix numbers stored as text.
Syntax
VALUETOTEXT(value, [format])
Convert value ke text.
Contoh
=VALUETOTEXT(A2)
Syntax
VAR(number1, ...)
Legacy sample variance. Pakai VAR.S.
Contoh
=VAR(B:B)
Syntax
VAR.P(number1, ...)
Population variance.
Contoh
=VAR.P(B:B)
Syntax
VAR.S(number1, ...)
Sample variance.
Contoh
=VAR.S(B:B)
Syntax
VARA(value1, ...)
Sample variance termasuk text/logical.
Contoh
=VARA(A:A)
Syntax
VARP(number1, ...)
Legacy population variance. Pakai VAR.P.
Contoh
=VARP(B:B)
Syntax
VARPA(value1, ...)
Population variance termasuk text/logical.
Contoh
=VARPA(A:A)
Syntax
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Variable declining balance depreciation.
Contoh
=VDB(2400,300,3650,0,1)
Syntax
VLOOKUP(lookup_value, table, col_index, [exact])
Lookup vertical. WAJIB letak FALSE/0 untuk exact match.
Contoh
=VLOOKUP(A2,Products,3,FALSE)
Cari harga product
💡 Customer/product lookup.
Syntax
VSTACK(array1, [array2], ...)
Stack arrays vertically.
Contoh
=VSTACK(A1:A5,B1:B5)
Syntax
WEBSERVICE(url)
Return data dari web service URL.
Contoh
=WEBSERVICE("https://api.example.com/data")
Syntax
WEEKDAY(serial_number, [return_type])
Hari dalam minggu (1-7) dari tarikh.
Contoh
=WEEKDAY(TODAY(),2)
1=Mon, 7=Sun
💡 Working day check.
Syntax
WEEKNUM(serial_number, [return_type])
Week number tahun (1-54).
Contoh
=WEEKNUM(TODAY())
Syntax
WEIBULL(x, alpha, beta, cumulative)
Legacy. Pakai WEIBULL.DIST.
Contoh
=WEIBULL(105,20,100,TRUE)
Syntax
WEIBULL.DIST(x, alpha, beta, cumulative)
Weibull distribution.
Contoh
=WEIBULL.DIST(105,20,100,TRUE)
Syntax
WORKDAY(start_date, days, [holidays])
Date N working days from start (skip weekends + holidays).
Contoh
=WORKDAY(TODAY(),10)
💡 Project deadline.
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])
WORKDAY dengan custom weekend.
Contoh
=WORKDAY.INTL(A2,10,11)
Syntax
WRAPCOLS(vector, wrap_count, [pad_with])
Wrap row/column vector into 2D array.
Contoh
=WRAPCOLS(A1:A12,3)
Syntax
WRAPROWS(vector, wrap_count, [pad_with])
Wrap vector into 2D array by rows.
Contoh
=WRAPROWS(A1:A12,4)
Syntax
XIRR(values, dates, [guess])
IRR untuk irregular cash flow dates.
Contoh
=XIRR(A1:A5,B1:B5)
💡 Real-world investment returns.
Syntax
XLOOKUP(lookup, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Modern lookup. Exact match default, can return left, has fallback built-in.
Contoh
=XLOOKUP(A2,Codes,Prices,"NA")
💡 Replace VLOOKUP — better in every way.
Syntax
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Modern MATCH dengan wildcard support.
Contoh
=XMATCH("Apple",A:A)
Syntax
XNPV(rate, values, dates)
NPV untuk irregular cash flow dates.
Contoh
=XNPV(0.09,A1:A5,B1:B5)
Syntax
XOR(logical1, [logical2], ...)
Exclusive OR — TRUE kalau odd number arguments true.
Contoh
=XOR(TRUE,FALSE)
TRUE
Syntax
YEAR(serial_number)
Tahun dari tarikh.
Contoh
=YEAR(A2)
💡 Group data by year.
Syntax
YEARFRAC(start_date, end_date, [basis])
Pecahan tahun antara dua tarikh.
Contoh
=YEARFRAC(A2,TODAY())
💡 Prorated calculations.
Syntax
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
Yield on security with periodic interest.
Contoh
=YIELD(...)
Syntax
YIELDDISC(settlement, maturity, pr, redemption, [basis])
Annual yield untuk discounted security.
Contoh
=YIELDDISC(...)
Syntax
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Annual yield untuk security paying interest at maturity.
Contoh
=YIELDMAT(...)
Syntax
Z.TEST(array, x, [sigma])
One-tailed z-test probability.
Contoh
=Z.TEST(A:A,4)
Syntax
ZTEST(array, x, [sigma])
Legacy. Pakai Z.TEST.
Contoh
=ZTEST(A:A,4)
Klik 🤖 Tanya AI kat mana-mana card — AI akan jelaskan dengan contoh.
💬 Buka Chat AIOnline · ready bantu