ODD

ODD helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the ODD function quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatic recalculation when data changes. With ODD, you can write formulas directly in a cell or the formula bar, view syntax prompts with parameter requirements and examples, use cross-sheet references, and build nested calculations. You can also troubleshoot 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, ODD helps you complete calculations efficiently. Choose the documentation below that best matches your needs to learn more.