IF

IF helps you perform conditional calculations and analysis in AirSheet. It provides the tools you need to write formulas with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With IF, you can enter formulas in a cell or formula bar, start with =, use automatic syntax prompts with parameter requirements and examples, reference data across worksheets, build nested calculations, and get results that update automatically when source data changes. Whether you're checking formula syntax, correcting parameter count or type errors, reviewing unmatched parentheses or missing separators, or troubleshooting incorrect results caused by text-formatted numbers or circular references, IF 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