FIND

FIND helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter and evaluate formulas efficiently, making your work more efficient and helping you accomplish tasks with ease. With FIND, you can start a formula with =, enter FIND( to view syntax prompts with parameter requirements and examples, supply the correct parameters, and return results directly in a cell. It also supports flexible parameters, cross-worksheet references, nested calculations, and automatic recalculation when source data changes. Whether you're correcting formula errors, checking parameter types and counts, reviewing syntax guidance, or troubleshooting incorrect results caused by text-formatted numbers or circular references, FIND 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