OFFSET function
Returns a reference offset from a given reference
Syntax
OFFSET(reference, rows, columns, [height], [width])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| reference | Yes | The reference from which you want to base the offset.A1 |
| rows | Yes | The number of rows, up or down, that you want the upper-left cell to refer to.1 |
| columns | Yes | The number of columns, to the left or right, that you want the upper-left cell of the result to refer to.1 |
| height | No | The height, in number of rows, that you want the returned reference to be. Height must be a positive number.1 |
| width | No | The width, in number of columns, that you want the returned reference to be. Width must be a positive number.1 |
Try OFFSET
Move down one row from A2
=OFFSET(A2,1,0)Move one row down and zero columns across to A3, which contains 25.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
OFFSET · top-level call
=OFFSET(A2,1,0)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.