VARP

VARP helps you calculate and analyze data in AirSheet worksheets. It provides the tools you need to perform variance calculations with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With VARP, you can enter the formula by starting with =, use automatic syntax prompts that show parameter requirements and examples, apply cross-worksheet references, and build nested calculations, while results update automatically when source data changes. If errors occur, you can check 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 formulas directly in a cell or editing longer formulas in the formula bar, VARP helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53