IPMT

IPMT helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatically updated results when source data changes. With IPMT, you can write formulas directly in a cell or formula bar, view syntax prompts with parameter requirements and examples as you type, use cross-worksheet references, and include nested calculations. If a result is incorrect, you can check syntax, parameter count and types, text-formatted numbers, or circular references, and manually trigger recalculation when needed. Whether you're building formulas for routine calculations or troubleshooting function errors, IPMT helps you complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53