How to Use Excel VARPA Function in Office 365? – [with Examples]
Tags: excelfunctions, excelvarpafunctionin
Published: 2020-09-11 08:49:10

---
title: How to Use Excel VARPA Function in Office 365? – [with Examples]
published: true
date: 2020-09-08 12:02:58 UTC
tags: ExcelFunctions,ExcelVARPAFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-varpa-function-in-office-365-with-examples/
---

## Excel VARPA Function:

![VARPA Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/VARPA-Function.png)<figcaption id="caption-attachment-13637">VARPA Function</figcaption>

This function describes the usage of **Excel VARPA Function in Office 365** with its syntax, description, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **VARPA Function – Description:**

- This function is used to **calculate variance based on the entire population**.
- It can be manually calculated by using the below-given formula.

![Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Formula.png)<figcaption id="caption-attachment-13560">Formula</figcaption>

## **Syntax:**

**=VARPA(number1, [number2],..)**

### Parameters Description:

**Number1 ** – It is the first input number or cell reference.

**Number2 ** – It is an optional one. It can be a number or cell reference.

### Note:

- The arguments can be **Numbers** , **Names** , **Arrays** , or **References**.
- If the argument contains **TRUE** , it will evaluate as **1**.
- If the argument contains **Text** or **FALSE** , this function evaluates it as **0**.

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

| Function Name | Data Set | Text and logical Value |
| --- | --- | --- |
| [VAR](https://geekexcel.com/how-to-use-excel-var-function-in-office-365-with-examples/) | Sample | It will be Ignored |
| [VARP](https://geekexcel.com/how-to-use-excel-varp-function-in-office-365-with-examples/) | Population | It will be Ignored |
| [VAR.S](https://geekexcel.com/how-to-use-excel-var-s-function-in-office-365-with-examples/) | Sample | It will be Ignored |
| [VAR.P](https://geekexcel.com/how-to-use-excel-var-p-function-in-office-365-with-examples/) | Population | It will be Ignored |
| [VARA](https://geekexcel.com/how-to-use-excel-vara-function-in-office-365-with-examples/) | Sample | It will Evaluate |
| [VARPA](https://geekexcel.com/how-to-use-excel-varpa-function-in-office-365-with-examples/) | Population | It will Evaluate |

## **Examples:**

Refer to the below examples.

### Example 1:

- In the below screenshot, you can see the input range from **cell B2 to B10** , and its output value is printed in the **cell E2 ** by using **VARPA Function**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-35.png)<figcaption id="caption-attachment-13633">Example 1</figcaption>

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

![Working Calculation of VARPA Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Working-Calculation-of-VARPA-Function.png)<figcaption id="caption-attachment-13635">Working Calculation of VARPA Function</figcaption>

### Example 2:

- If the argument contains **TRUE** , it will evaluate as **1**.
- If the argument contains **Text** or **FALSE** , this function evaluates it as **0**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-31.png)<figcaption id="caption-attachment-13634">Example 2</figcaption>

From the above image that you can clearly able to see that the VARPA function evaluates the text and logical values and generates the result.

## **Bottom-Line:**

In this article, you can learn the usage of **Excel VARPA Function in Office 365** with its syntax, description, and examples. Share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**VAR Function**](https://geekexcel.com/how-to-use-excel-var-function-in-office-365-with-examples/)
- [**VAR.S Function**](https://geekexcel.com/how-to-use-excel-var-s-function-in-office-365-with-examples/)
- [**VARP Function**](https://geekexcel.com/how-to-use-excel-varp-function-in-office-365-with-examples/)
- [**VARA Function**](https://geekexcel.com/how-to-use-excel-vara-function-in-office-365-with-examples/)
- [**VAR.P Function**](https://geekexcel.com/how-to-use-excel-var-p-function-in-office-365-with-examples/)