IFNA

IFNA helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter IFNA formulas quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatically updated results when source data changes. With IFNA, you can write formulas by starting with an equals sign, view syntax prompts with parameter requirements and examples, use cross-sheet references, and build nested calculations. You can also troubleshoot common issues by checking formula syntax, parameter types and counts, unmatched parentheses, missing separators, text-formatted numbers, or circular references, and manually trigger recalculation when needed. Whether you're entering a new formula or correcting an incorrect result, IFNA helps you complete calculations efficiently. Choose the documentation below that best matches your needs to learn more.

1:53