ACOT

ACOT helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatic recalculation when source data changes. With ACOT, you can write formulas directly in a cell or the formula bar, view syntax prompts with parameter requirements and examples as you type, use cross-worksheet references, and build nested calculations. You can also troubleshoot common issues by checking syntax, parameter type and count, bracket matching, separators, text-formatted numbers, and circular references, or manually trigger recalculation when needed. Whether you're entering a new formula or correcting an incorrect result, ACOT 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