Fungsi Excel dan Google Sheets
564 fungsi, dikelompokkan per kategori. Setiap halaman memuat sintaks, contoh rumus, dan hasilnya.
Matematika & Trigonometri 79 fungsi
- ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- AGGREGATE
- ARABIC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- BASE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- COMBIN
- COMBINA
- COS
- COSH
- COT
- COTH
- CSC
- CSCH
- DECIMAL
- DEGREES
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- FLOOR.MATH
- FLOOR.PRECISE
- GCD
- INT
- ISO.CEILING
- LCM
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEC
- SECH
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
Statistik 151 fungsi
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BINOM.DIST
- BINOM.DIST.RANGE
- BINOM.INV
- BINOMDIST
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- DEVSQ
- EXPON.DIST
- EXPONDIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FDIST
- FDISTRT
- FINV
- FISHER
- FISHERINV
- FORECAST
- FORECAST.ETSExcel
- FORECAST.ETS.CONFINTExcel
- FORECAST.ETS.SEASONALITYExcel
- FORECAST.ETS.STATExcel
- FORECAST.LINEAR
- FREQUENCY
- FTEST
- GAMMA
- GAMMA.DIST
- GAMMA.INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GAMMALN.PRECISE
- GAUSS
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOM.DIST
- HYPGEOM.DIST.RANGE
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGEST
- LOGINV
- LOGNORM.DIST
- LOGNORM.INV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- MODE.MULT
- MODE.SNGL
- NEGBINOM.DIST
- NEGBINOMDIST
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- POISSON
- POISSON.DIST
- PROB
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- RANK
- RANK.AVG
- RANK.EQ
- RSQ
- SKEW
- SKEW.P
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEV.P
- STDEV.S
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- VAR
- VAR.P
- VAR.S
- VARA
- VARP
- VARPA
- WEIBULL
- WEIBULL.DIST
- Z.TEST
- ZTEST
Keuangan 57 fungsi
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- EUROCONVERTExcel
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PDURATION
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- RRI
- SLN
- STOCKHISTORYExcel
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
Teks 46 fungsi
- ARRAYTOTEXTExcel
- ASCExcel
- BAHTTEXTExcel
- CHAR
- CLEAN
- CODE
- CONCAT
- CONCATENATE
- DBCSExcel
- DOLLAR
- EXACT
- FIND
- FINDB
- FINDEN
- FIXED
- JISExcel
- LEFT
- LEFTB
- LEN
- LENB
- LOWER
- MID
- MIDB
- NUMBERVALUE
- PHONETICExcel
- PROPER
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- SEARCH
- SEARCHB
- SUBSTITUTE
- T
- TEXT
- TEXTAFTERExcel
- TEXTBEFOREExcel
- TEXTJOIN
- TEXTSPLITExcel
- TRIM
- UNICHAR
- UNICODE
- UPPER
- VALUE
- VALUETOTEXTExcel
Tanggal & Waktu 25 fungsi
Pencarian & Referensi 22 fungsi
Informasi 21 fungsi
Database 19 fungsi
Array Dinamis 17 fungsi
Teknik 30 fungsi
Bilangan Kompleks 26 fungsi
Web 3 fungsi
Khusus Google Sheets 49 fungsi
- ADDSheets
- ARRAY_CONSTRAINSheets
- ARRAYFORMULASheets
- AVERAGE.WEIGHTEDSheets
- COUNTUNIQUESheets
- DETECTLANGUAGESheets
- DIVIDESheets
- EPOCHTODATESheets
- EQSheets
- FLATTENSheets
- GOOGLEFINANCESheets
- GOOGLETRANSLATESheets
- GTSheets
- GTESheets
- IMCOTHSheets
- IMLOGSheets
- IMPORTDATASheets
- IMPORTFEEDSheets
- IMPORTHTMLSheets
- IMPORTRANGESheets
- IMPORTXMLSheets
- IMTANHSheets
- ISBETWEENSheets
- ISDATESheets
- ISEMAILSheets
- ISURLSheets
- JOINSheets
- LTSheets
- LTESheets
- MARGINOFERRORSheets
- MINUSSheets
- MULTIPLYSheets
- NESheets
- POWSheets
- QUERYSheets
- REGEXEXTRACTSheets
- REGEXMATCHSheets
- REGEXREPLACESheets
- SORTNSheets
- SPARKLINESheets
- SPLITSheets
- TO_DATESheets
- TO_DOLLARSSheets
- TO_PERCENTSheets
- TO_PURE_NUMBERSheets
- TO_TEXTSheets
- UMINUSSheets
- UNARY_PERCENTSheets
- UPLUSSheets
Indeks A–Z
A
B
C
- CALL
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMBINA
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUNTUNIQUE
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CSC
- CSCH
- CUBEKPIMEMBER
- CUBEMEMBER
- CUBEMEMBERPROPERTY
- CUBERANKEDMEMBER
- CUBESET
- CUBESETCOUNT
- CUBEVALUE
- CUMIPMT
- CUMPRINC
D
E
F
G
I
- IF
- IFERROR
- IFNA
- IFS
- IMABS
- IMAGE
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCOTH
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG
- IMLOG10
- IMLOG2
- IMPORTDATA
- IMPORTFEED
- IMPORTHTML
- IMPORTRANGE
- IMPORTXML
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- IMTANH
- INDEX
- INDIRECT
- INFO
- INT
- INTERCEPT
- INTRATE
- IPMT
- IRR
- ISBETWEEN
- ISBLANK
- ISDATE
- ISEMAIL
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISO.CEILING
- ISODD
- ISOMITTED
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
- ISURL