IF

IF helps you perform conditional calculations and analysis in AirSheet worksheets. It provides the tools you need to evaluate conditions, return different results based on those conditions, and keep calculations current as data changes, making your work more efficient and helping you accomplish tasks with ease. With IF, you can enter formulas directly in a cell or formula bar, use syntax prompts with parameter requirements and examples, build formulas with flexible parameters, reference other worksheets, and create nested calculations. Results update automatically after source data changes, and manual recalculation is also supported when needed. Whether you're checking formula syntax, correcting parameter or reference issues, or handling common calculation errors such as 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