SCAN

SCAN helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatically updated results when source data changes. With SCAN, you can type a formula beginning with =, enter SCAN(, review the automatic syntax prompt with parameter requirements and examples, and confirm the formula to display results in a cell. It also supports cross-worksheet references and nested calculations, giving you flexibility in how formulas are built. Whether you're correcting syntax errors, checking parameter types and counts, reviewing examples, or troubleshooting incorrect results caused by text-formatted numbers or circular references, SCAN helps you complete calculations efficiently. Choose the documentation below that best matches your needs to learn more.

1:53