Excel Function : DVARP

Download now!

Excel Function : DVARP

Category

Database

Description

Calculates variance based on the entire population of selected database entries

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DVARP-function-eb0ba387-9cb7-45c8-81e9-0394912502fc

Syntax and Description of the DVARP Excel Function

syntax error In excel, I'm trying to use the DVARP function to find the variance of a column. I have a date in column A and the data I'm looking to get the variance of is in column B. I've tried =DVARP(A:A,B:B) =DVARP(A:B) =DVARP(A1:A25,B1:B25) and I always get the error: #NAME? What is the correct syntax for this function? A: You are missing the B at the end of your syntax.

About DVARP Excel Function

The DVARP function returns the variance of a population based on the entire population, including duplicates.