IFERROR

IFERROR helps you handle calculation and analysis in AirSheet / Worksheet by returning a specified result when a formula produces an error. It provides the tools you need to build formulas more reliably, making your work more efficient and helping you accomplish tasks with ease. With IFERROR, you can enter formulas directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use flexible parameters for different calculation scenarios, reference other worksheets, and include nested calculations with real-time recalculation when data changes. Whether you're correcting formula syntax, checking parameter types and counts, resolving issues caused by text-formatted numbers or circular references, or manually triggering recalculation when needed, IFERROR 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