Bantuan Formula dan Fungsi
- Selamat Datang
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- ABS
- CEILING
- COMBIN
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PI
- POLYNOMIAL
- POWER
- PRODUCT
- QUOTIENT
- RAND
- RANDARRAY
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEQUENCE
- SERIESSUM
- SIGN
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TRUNC
-
- ADDRESS
- AREAS
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- COLUMN
- COLUMNS
- DROP
- EXPAND
- FILTER
- FORMULATEXT
- GETPIVOTDATA
- HLOOKUP
- HSTACK
- HYPERLINK
- INDEX
- INDIRECT
- INTERSECT.RANGES
- LOOKUP
- MATCH
- OFFSET
- REFERENCE.NAME
- ROW
- ROWS
- SORT
- SORTBY
- TAKE
- TOCOL
- TOROW
- TRANSPOSE
- UNION.RANGES
- UNIQUE
- VLOOKUP
- VSTACK
- WRAPCOLS
- WRAPROWS
- XLOOKUP
- XMATCH
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Hak Cipta
SEQUENCE
Fungsi SEQUENCE menghasilkan larik nilai numerik berurutan berdasarkan spesifikasi Anda. Anda menentukan jumlah baris, jumlah kolom, angka pertama yang dihasilkan, dan kenaikan yang akan bertambah di antara setiap nilai.
SEQUENCE(number-of-rows, number-of-columns, start, step)
number-of-rows: Jumlah baris yang akan dihasilkan.
number-of-columns: Jumlah kolom yang akan dihasilkan.
start: Angka pertama yang dihasilkan.
step: Kenaikan yang bertambah di antara setiap nilai.
Catatan
Hilangkan start dan step untuk menghasilkan larik yang dimulai dengan 1 dan bertambah sebesar 1.
Contoh |
|---|
=SEQUENCE(2;3;5;5) menghasilkan larik di bawah ini: |
A | B | C | |
|---|---|---|---|
1 | 5 | 10 | 15 |
2 | 20 | 25 | 30 |
=SEQUENCE(3;4) menghasilkan larik di bawah ini: |
A | B | C | D | |
|---|---|---|---|---|
1 | 1 | 2 | 3 | 4 |
2 | 5 | 6 | 7 | 8 |
3 | 9 | 10 | 11 | 12 |
=SEQUENCE(4;7;DATE(2025;4;1);1) menghasilkan larik di bawah ini: |
A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | 01/04/2025 | 02/04/2025 | 03/04/2025 | 04/04/2025 | 05/04/2025 | 06/04/2025 | 07/04/2025 |
2 | 08/04/2025 | 09/04/2025 | 10/04/2025 | 11/04/2025 | 12/04/2025 | 13/04/2025 | 14/04/2025 |
3 | 15/04/2025 | 16/04/2025 | 17/04/2025 | 18/04/2025 | 19/04/2025 | 20/04/2025 | 21/04/2025 |
4 | 22/04/2025 | 23/04/2025 | 24/04/2025 | 25/04/2025 | 26/04/2025 | 27/04/2025 | 28/04/2025 |