Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
DVARP Function / Formula in Microsoft Excel 2007 | Video Tutorial

DVARP Function

The DVARP function is used to find the variance of a list of items from a table/database range based on the numbers in the column in the database, based on the given condition.

Formula:


=DVARP(Database Range, Field Name, Criteria Range)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field whose variance has to be found and CriteriaRange is the name of the FieldName.

Video Tutorial:


Let us find the variance of a list of items from the table/ database, using DVARP function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question