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 mengembalikan tatasusunan nilai angka berjujukan berdasarkan penentuan anda. Anda menentukan bilangan baris, bilangan lajur, nombor pertama untuk dikembalikan dan tokokan untuk ditingkatkan antara setiap nilai.
SEQUENCE(number-of-rows, number-of-columns, start, step)
number-of-rows: Bilangan baris untuk dikembalikan.
number-of-columns: Bilangan lajur untuk dikembalikan.
start: Nombor pertama untuk dikembalikan.
step: Tokokan untuk ditingkatkan antara setiap nilai.
Nota
Kecualikan start dan step untuk menjana tatasusunan bermula dengan 1 dan menaik dengan 1.
Contoh |
|---|
=SEQUENCE(2,3,5,5) mengembalikan tatasusunan di bawah: |
A | B | C | |
|---|---|---|---|
1 | 5 | 10 | 15 |
2 | 20 | 25 | 30 |
=SEQUENCE(3,4) mengembalikan tatasusunan di bawah: |
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) mengembalikan tatasusunan di bawah: |
A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | 1/04/2025 | 2/04/2025 | 3/04/2025 | 4/04/2025 | 5/04/2025 | 6/04/2025 | 7/04/2025 |
2 | 8/04/2025 | 9/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 |