# How to Use Excel VARP Function?

Excel VARP Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. If you want to find out the variance of the entire population of data, then you can use this VARP function.

In this post, we are going to explore how to use the Excel VARP Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of VARP Function

• It is one of the built-in functions in Microsoft Excel.
• This function is used to calculate the variance of the entire population.
• VARP Function ignores the text and logical values.

## Syntax

• Here, you will see the syntax of the VARP function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=VARP(number1, [number2], …)

Parameters Description:

• Number 1 – It is the first input number or cell reference.
• Number 2 – It is an optional one. It can be a number or cell reference.

Note:
1) The arguments can be Numbers, Names, Arrays, or References.
2) This function ignores Empty cells, Boolean values, and Text, any Non-numerical values.

The following table explains that the list of functions will consider the text and logical value, but will not consider the text and logical values.

## Examples

Let’s see some examples to understand how VARP Function will work.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have given a range of input values in B2:B10 and we will get the variance of the entire population of data using the VARP function.
• Then, we have to apply the above-mentioned formula to get the result, as shown in the following screenshot.
• Finally, we need to click on the button to get the result.

The following mathematical calculation explains the working of VARP Function in Excel.

• This function ignores Empty cells, Boolean values, and Text, any Non-numerical values.