PPMT

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

1:53