Rumus-rumus dasar Microsoft Excel
564 rumus Excel & Google Sheets beserta contoh dan penjelasan ringkas Bahasa Indonesia. Klik untuk lihat syntax, contoh, dan studi kasus.
⚡
Generator Rumus Cepat
Cari nilai vertikal
=VLOOKUP(…, …, …, …)Menampilkan semua 564 rumus. Semua tautan di bawah adalah link statis yang bisa di-crawl Google.
A
ABS
matematika,trigonometri
ACCRINT
keuangan
ACCRINTM
keuangan
ACOS
matematika,trigonometri
ACOSH
matematika,trigonometri
ACOT
matematika,trigonometri
ACOTH
matematika,trigonometri
ADD
operator
ADDRESS
lookup,referensi
AGGREGATE
matematika,trigonometri
AMORDEGRC
keuangan
AMORLINC
keuangan
AND
logika
ARABIC
matematika,trigonometri
AREAS
lookup,referensi
ARRAY_CONSTRAIN
array
ARRAYFORMULA
google
ARRAYTOTEXT
text
ASC
text
ASIN
matematika,trigonometri
ASINH
matematika,trigonometri
ATAN
matematika,trigonometri
ATAN2
matematika,trigonometri
ATANH
matematika,trigonometri
AVEDEV
statistik
AVERAGE
statistik
AVERAGE.WEIGHTED
statistik
AVERAGEA
statistik
AVERAGEIF
statistik
AVERAGEIFS
statistik
B
BAHTTEXT
text
BASE
matematika,trigonometri
BESSELI
engineering
BESSELJ
engineering
BESSELK
engineering
BESSELY
engineering
BETA.DIST
statistik
BETA.INV
statistik
BETADIST
kompatibilitas
BETAINV
kompatibilitas
BIN2DEC
engineering
BIN2HEX
engineering
BIN2OCT
engineering
BINOM.DIST
statistik
BINOM.DIST.RANGE
statistik
BINOM.INV
statistik
BINOMDIST
kompatibilitas
BITAND
engineering
BITLSHIFT
engineering
BITOR
engineering
BITRSHIFT
engineering
BITXOR
engineering
BYCOL
logika
BYROW
logika
C
CALL
otomasi,tambahan
CEILING
kompatibilitas
CEILING.MATH
matematika,trigonometri
CEILING.PRECISE
matematika,trigonometri
CELL
informasi
CHAR
text
CHIDIST
kompatibilitas
CHIINV
kompatibilitas
CHISQ.DIST
statistik
CHISQ.DIST.RT
statistik
CHISQ.INV
statistik
CHISQ.INV.RT
statistik
CHISQ.TEST
statistik
CHITEST
kompatibilitas
CHOOSE
lookup,referensi
CHOOSECOLS
lookup,referensi
CHOOSEROWS
lookup,referensi
CLEAN
text
CODE
text
COLUMN
lookup,referensi
COLUMNS
lookup,referensi
COMBIN
matematika,trigonometri
COMBINA
matematika,trigonometri
COMPLEX
engineering
CONCAT
text
CONCATENATE
text
CONFIDENCE
kompatibilitas
CONFIDENCE.NORM
statistik
CONFIDENCE.T
statistik
CONVERT
engineering
CORREL
statistik
COS
matematika,trigonometri
COSH
matematika,trigonometri
COT
matematika,trigonometri
COTH
matematika,trigonometri
COUNT
statistik
COUNTA
statistik
COUNTBLANK
statistik
COUNTIF
statistik
COUNTIFS
statistik
COUNTUNIQUE
matematika
COUPDAYBS
keuangan
COUPDAYS
keuangan
COUPDAYSNC
keuangan
COUPNCD
keuangan
COUPNUM
keuangan
COUPPCD
keuangan
COVAR
kompatibilitas
COVARIANCE.P
statistik
COVARIANCE.S
statistik
CRITBINOM
kompatibilitas
CSC
matematika,trigonometri
CSCH
matematika,trigonometri
CUBEKPIMEMBER
cube
CUBEMEMBER
cube
CUBEMEMBERPROPERTY
cube
CUBERANKEDMEMBER
cube
CUBESET
cube
CUBESETCOUNT
cube
CUBEVALUE
cube
CUMIPMT
keuangan
CUMPRINC
keuangan
D
DATE
date,waktu
DATEDIF
date,waktu
DATEVALUE
date,waktu
DAVERAGE
database
DAY
date,waktu
DAYS
date,waktu
DAYS360
date,waktu
DB
keuangan
DBCS
text
DCOUNT
database
DCOUNTA
database
DDB
keuangan
DEC2BIN
engineering
DEC2HEX
engineering
DEC2OCT
engineering
DECIMAL
matematika,trigonometri
DEGREES
matematika,trigonometri
DELTA
engineering
DETECTLANGUAGE
google
DEVSQ
statistik
DGET
database
DISC
keuangan
DIVIDE
operator
DMAX
database
DMIN
database
DOLLAR
text
DOLLARDE
keuangan
DOLLARFR
keuangan
DPRODUCT
database
DROP
lookup,referensi
DSTDEV
database
DSTDEVP
database
DSUM
database
DURATION
keuangan
DVAR
database
DVARP
database
E
EDATE
date,waktu
EFFECT
keuangan
ENCODEURL
web
EOMONTH
date,waktu
EPOCHTODATE
date
EQ
operator
ERF
engineering
ERF.PRECISE
engineering
ERFC
engineering
ERFC.PRECISE
engineering
ERROR.TYPE
informasi
EUROCONVERT
otomasi,tambahan
EVEN
matematika,trigonometri
EXACT
text
EXP
matematika,trigonometri
EXPAND
lookup,referensi
EXPON.DIST
statistik
EXPONDIST
kompatibilitas
F
F.DIST
statistik
F.DIST.RT
statistik
F.INV
statistik
F.INV.RT
statistik
F.TEST
statistik
FACT
matematika,trigonometri
FACTDOUBLE
matematika,trigonometri
FALSE
logika
FDIST
kompatibilitas
FDISTRT
FILTER
lookup,referensi
FILTERXML
web
FIND
text
FINDB
text
FINDEN
text
FINV
kompatibilitas
FISHER
statistik
FISHERINV
statistik
FIXED
text
FLATTEN
array
FLOOR
kompatibilitas
FLOOR.MATH
matematika,trigonometri
FLOOR.PRECISE
matematika,trigonometri
FORECAST
statistik
FORECAST.ETS
statistik
FORECAST.ETS.CONFINT
statistik
FORECAST.ETS.SEASONALITY
statistik
FORECAST.ETS.STAT
statistik
FORECAST.LINEAR
statistik
FORMULATEXT
lookup,referensi
FREQUENCY
statistik
FTEST
kompatibilitas
FV
keuangan
FVSCHEDULE
keuangan
G
GAMMA
statistik
GAMMA.DIST
statistik
GAMMA.INV
statistik
GAMMADIST
kompatibilitas
GAMMAINV
kompatibilitas
GAMMALN
statistik
GAMMALN.PRECISE
statistik
GAUSS
statistik
GCD
matematika,trigonometri
GEOMEAN
statistik
GESTEP
engineering
GETPIVOTDATA
lookup,referensi
GOOGLEFINANCE
google
GOOGLETRANSLATE
google
GROWTH
statistik
GT
operator
GTE
operator
H
I
IF
logika
IFERROR
logika
IFNA
logika
IFS
logika
IMABS
engineering
IMAGE
lookup,referensi
IMAGINARY
engineering
IMARGUMENT
engineering
IMCONJUGATE
engineering
IMCOS
engineering
IMCOSH
engineering
IMCOT
engineering
IMCOTH
engineering
IMCSC
engineering
IMCSCH
engineering
IMDIV
engineering
IMEXP
engineering
IMLN
engineering
IMLOG
engineering
IMLOG10
engineering
IMLOG2
engineering
IMPORTDATA
web
IMPORTFEED
web
IMPORTHTML
web
IMPORTRANGE
web
IMPORTXML
web
IMPOWER
engineering
IMPRODUCT
engineering
IMREAL
engineering
IMSEC
engineering
IMSECH
engineering
IMSIN
engineering
IMSINH
engineering
IMSQRT
engineering
IMSUB
engineering
IMSUM
engineering
IMTAN
engineering
IMTANH
engineering
INDEX
lookup,referensi
INDIRECT
lookup,referensi
INFO
informasi
INT
matematika,trigonometri
INTERCEPT
statistik
INTRATE
keuangan
IPMT
keuangan
IRR
keuangan
ISBETWEEN
operator
ISBLANK
informasi
ISDATE
info
ISEMAIL
info
ISERR
informasi
ISERROR
informasi
ISEVEN
informasi
ISFORMULA
informasi
ISLOGICAL
informasi
ISNA
informasi
ISNONTEXT
informasi
ISNUMBER
informasi
ISO.CEILING
matematika,trigonometri
ISODD
informasi
ISOMITTED
informasi
ISOWEEKNUM
date,waktu
ISPMT
keuangan
ISREF
informasi
ISTEXT
informasi
ISURL
web
J
K
L
LAMBDA
logika
LARGE
statistik
LCM
matematika,trigonometri
LEFT
text
LEFTB
text
LEN
text
LENB
LET
logika
LINEST
statistik
LN
matematika,trigonometri
LOG
matematika,trigonometri
LOG10
matematika,trigonometri
LOGEST
statistik
LOGINV
kompatibilitas
LOGNORM.DIST
statistik
LOGNORM.INV
statistik
LOGNORMDIST
kompatibilitas
LOOKUP
lookup,referensi
LOWER
text
LT
operator
LTE
operator
M
MAKEARRAY
logika
MAP
logika
MARGINOFERROR
statistik
MATCH
lookup,referensi
MAX
statistik
MAXA
statistik
MAXIFS
statistik
MDETERM
matematika,trigonometri
MDURATION
keuangan
MEDIAN
statistik
MID
text
MIDB
MIN
statistik
MINA
statistik
MINIFS
statistik
MINUS
operator
MINUTE
date,waktu
MINVERSE
matematika,trigonometri
MIRR
keuangan
MMULT
matematika,trigonometri
MOD
matematika,trigonometri
MODE
kompatibilitas
MODE.MULT
statistik
MODE.SNGL
statistik
MONTH
date,waktu
MROUND
matematika,trigonometri
MULTINOMIAL
matematika,trigonometri
MULTIPLY
operator
MUNIT
matematika,trigonometri
N
N
informasi
NA
informasi
NE
operator
NEGBINOM.DIST
statistik
NEGBINOMDIST
kompatibilitas
NETWORKDAYS
date,waktu
NETWORKDAYS.INTL
date,waktu
NOMINAL
keuangan
NORM.DIST
statistik
NORM.INV
kompatibilitas
NORM.S.DIST
statistik
NORM.S.INV
statistik
NORMDIST
kompatibilitas
NORMINV
statistik
NORMSDIST
kompatibilitas
NORMSINV
kompatibilitas
NOT
logika
NOW
date,waktu
NPER
keuangan
NPV
keuangan
NUMBERVALUE
text
O
P
PDURATION
keuangan
PEARSON
statistik
PERCENTILE
kompatibilitas
PERCENTILE.EXC
statistik
PERCENTILE.INC
statistik
PERCENTRANK
kompatibilitas
PERCENTRANK.EXC
statistik
PERCENTRANK.INC
statistik
PERMUT
statistik
PERMUTATIONA
statistik
PHI
statistik
PHONETIC
text
PI
matematika,trigonometri
PMT
keuangan
POISSON
kompatibilitas
POISSON.DIST
statistik
POW
operator
POWER
matematika,trigonometri
PPMT
keuangan
PRICE
keuangan
PRICEDISC
keuangan
PRICEMAT
keuangan
PROB
statistik
PRODUCT
matematika,trigonometri
PROPER
text
PV
keuangan
Q
R
RADIANS
matematika,trigonometri
RAND
matematika,trigonometri
RANDARRAY
matematika,trigonometri
RANDBETWEEN
matematika,trigonometri
RANK
kompatibilitas
RANK.AVG
statistik
RANK.EQ
statistik
RATE
keuangan
RECEIVED
keuangan
REDUCE
logika
REGEXEXTRACT
text
REGEXMATCH
text
REGEXREPLACE
text
REGISTER.ID
otomasi,tambahan
REPLACE
text
REPLACEB
text
REPT
text
RIGHT
text
RIGHTB
text
ROMAN
matematika,trigonometri
ROUND
matematika,trigonometri
ROUNDDOWN
matematika,trigonometri
ROUNDUP
matematika,trigonometri
ROW
lookup,referensi
ROWS
lookup,referensi
RRI
keuangan
RSQ
statistik
RTD
lookup,referensi
S
SCAN
logika
SEARCH
text
SEARCHB
text
SEC
matematika,trigonometri
SECH
matematika,trigonometri
SECOND
date,waktu
SEQUENCE
matematika,trigonometri
SERIESSUM
matematika,trigonometri
SHEET
informasi
SHEETS
informasi
SIGN
matematika,trigonometri
SIN
matematika,trigonometri
SINH
matematika,trigonometri
SKEW
statistik
SKEW.P
statistik
SLN
keuangan
SLOPE
statistik
SMALL
statistik
SORT
lookup,referensi
SORTBY
lookup,referensi
SORTN
filter
SPARKLINE
google
SPLIT
text
SQRT
matematika,trigonometri
SQRTPI
matematika,trigonometri
STANDARDIZE
statistik
STDEV
kompatibilitas
STDEV.P
statistik
STDEV.S
statistik
STDEVA
statistik
STDEVP
kompatibilitas
STDEVPA
statistik
STEYX
statistik
STOCKHISTORY
keuangan
SUBSTITUTE
text
SUBTOTAL
matematika,trigonometri
SUM
matematika,trigonometri
SUMIF
matematika,trigonometri
SUMIFS
matematika,trigonometri
SUMPRODUCT
matematika,trigonometri
SUMSQ
matematika,trigonometri
SUMX2MY2
matematika,trigonometri
SUMX2PY2
matematika,trigonometri
SUMXMY2
matematika,trigonometri
SWITCH
logika
SYD
keuangan
T
T
text
T.DIST
statistik
T.DIST.2T
statistik
T.DIST.RT
statistik
T.INV
statistik
T.INV.2T
statistik
T.TEST
statistik
TAKE
lookup,referensi
TAN
matematika,trigonometri
TANH
matematika,trigonometri
TBILLEQ
keuangan
TBILLPRICE
keuangan
TBILLYIELD
keuangan
TDIST
kompatibilitas
TEXT
text
TEXTAFTER
text
TEXTBEFORE
text
TEXTJOIN
text
TEXTSPLIT
text
TIME
date,waktu
TIMEVALUE
date,waktu
TINV
kompatibilitas
TO_DATE
parser
TO_DOLLARS
parser
TO_PERCENT
parser
TO_PURE_NUMBER
parser
TO_TEXT
parser
TOCOL
lookup,referensi
TODAY
date,waktu
TOROW
lookup,referensi
TRANSPOSE
lookup,referensi
TREND
statistik
TRIM
text
TRIMMEAN
statistik
TRUE
logika
TRUNC
matematika,trigonometri
TTEST
kompatibilitas
TYPE
informasi
U
V
W
X
Y
Z
Cari cepat (filter instan)
Ketik nama rumus — hasil filter tanpa reload.