Returns a reference that is a given number of rows and columns away from the specified cell/range.
Syntax
reference: The starting cell/range from which the given offset row/column is calculated. E.g. A1
col_offset: Number of columns to move. Can contain negative values. E.g. 1
Remarks
The new_height and new_width values, when omitted, take the same value as the given reference range.
Examples
Formula |
Result |
=OFFSET( A1 ;8;1;1;1) |
2467 |
=OFFSET( A5 ;-1;2;1;1) |
$123 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com