SERCH

SERCH helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter formulas efficiently and handle different calculation needs, making your work more efficient and helping you accomplish tasks with ease. With SERCH, you can start a formula with =, enter SERCH(, view automatic syntax guidance with parameter requirements and examples, supply the correct arguments, and return results in a cell. It also supports flexible parameters, cross-worksheet references, nested calculations, and automatic recalculation when source data changes, with manual recalculation available if needed. Whether you're correcting formula syntax, checking parameter types and counts, avoiding circular references, or working with longer formulas in the formula bar, SERCH helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53