OFFSET

OFFSET helps you perform data calculation and analysis in AirSheet. It provides the tools you need to build flexible reference-based formulas, making your work more efficient and helping you accomplish tasks with ease. With OFFSET, you can enter the function directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use flexible parameters for different calculation scenarios, reference ranges across worksheets, and combine it with nested calculations. Results update in real time and recalculate automatically when source data changes, with manual recalculation available if needed. Whether you're correcting formula errors, checking parameter count and syntax, or troubleshooting incorrect results caused by text-formatted numbers or circular references, OFFSET helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53