EXPAND

EXPAND helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter formulas efficiently and work with flexible parameters, making calculations easier to build and maintain. With EXPAND, you can input the function directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use cross-worksheet references, and include nested calculations. Results update in real time when source data changes, and you can also trigger recalculation manually if needed. Whether you're checking formula syntax, correcting parameter or reference issues, or building calculations that depend on changing worksheet data, EXPAND 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