Formula Excel OFFSET
lookup, referensi
The OFFSET function in Excel returns a reference offset from a starting cell or range of cells.
It is commonly used in dynamic formulas and creating dynamic ranges.
Formula dasar OFFSET
=OFFSET(reference, rows, cols, [height], [width])
Hasil/Output penggunaan rumus OFFSET
Hasilnya berupa reference yakni: Reference to the offset range
Penjelasan dari contoh rumus OFFSET
- The OFFSET function takes a reference cell, the number of rows and columns to offset from that reference, and optional height and width parameters.
- It returns a reference to the specified offset range.
Kesimpulan
The OFFSET function is frequently used for creating dynamic ranges in Excel formulas.