- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
OFFSET
This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells.
Syntax
OFFSET(reference, rows, cols, height, width)
Remarks
This function has these arguments:
Argument | Description |
|---|---|
reference | The location from which to base the offset |
rows | Number of rows to which the upper-left cell refers |
cols | Number of columns to which the upper-left cell refers |
height | [Optional] Number of returned rows; if omitted, same as reference |
width | [Optional] Number of returned columns; if omitted, same as reference |
The cols can be positive (right of the reference) or negative (left). If height or width is omitted, it is the same as the reference.
Remarks
This is a volatile function.
Data Types
Accepts a cell range for reference. Accepts numbers for rows, cols, height, and width. Returns a cell range.
Examples
OFFSET(D3,2,3,1,1)
OFFSET(D3:E5,2,3,1,1)