Excel Function : DVARP
Calculates variance based on the entire population of selected database entries
Microsoft Excel Reference Page
Syntax and Description of the DVARP Excel Function
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.
and I always get the error: #NAME?
What is the correct syntax for this function?
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.