EXPAND

EXPAND helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter and use the function with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With EXPAND, you can write formulas by starting with =, view automatic syntax prompts with parameter requirements and examples, use cross-sheet references, build nested calculations, and get results that update automatically when source data changes. Whether you're entering a new formula, checking syntax, correcting parameter or bracket errors, reviewing separator usage, or troubleshooting incorrect results caused by text-formatted numbers or circular references, 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