VAR.P

VAR.P helps you calculate and analyze data by returning variance values in AirSheet worksheets. It provides the tools you need to enter the function quickly, follow the required syntax, and keep results accurate as source data changes and recalculates automatically. With VAR.P, you can input the formula in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use flexible parameters for different calculation scenarios, reference data across worksheets, and include nested calculations. Whether you're troubleshooting formula errors, checking parameter types and counts, correcting bracket or separator issues, or verifying results affected by text-formatted numbers or circular references, VAR.P helps you complete calculations efficiently. Choose the documentation below that best matches your needs to learn more.

1:53