Excel Formulas to Calculate a Percent Variance ~ Useful Tricks!!
Tags: excelformula, excelformulas
Published: 2021-07-06 09:32:15

---
title: Excel Formulas to Calculate a Percent Variance ~ Useful Tricks!!
published: true
date: 2021-07-01 14:51:10 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-a-percent-variance/
---

Percent variance shows the **increase or decrease in an amount** over time as a percentage of the total amount value_. _The percent variance between the two values is simply calculated by taking the difference between two values and dividing it with the old value. In this tutorial, we will show the formulas to **calculate a percent variance in Excel**. Let’s see them below!! Let’s jump 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)

[![Calculate percent variance](https://geekexcel.com/wp-content/uploads/2021/07/Calculate-percent-variance.png)](https://geekexcel.com/excel-formulas-to-calculate-a-percent-variance/calculate-percent-variance/#main)<figcaption id="caption-attachment-48261">Calculate percent variance</figcaption>

## Generic Formula:

- You can use the below formula to calculate the percent variance in Excel.

**=(new-baseline)/baseline**

## Syntax Explanations:

- **New ** – It represents the new value.
- **Baseline** – This value represents the baseline value.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Division (/)** – It is used for dividing values or numbers.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B** and **Column C**.
- Now we need to find out the percent variant.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-4.png)<figcaption id="caption-attachment-48259">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/07/Enter-the-formula-2.png)<figcaption id="caption-attachment-48258">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/07/Result-3.png)<figcaption id="caption-attachment-48260">Result</figcaption>

## Wrap-Up:

So yeah guys this is **how you can find out the percent variance in Excel**. Leave a **comment** or **reply** below to let me know what you think!

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Get the Last Name from Full Name ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-last-name-from-name/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Volume of a Rectangular Prism!!](https://geekexcel.com/excel-formulas-to-calculate-the-volume-of-a-rectangular-prism/)**
- **[Excel Formulas to Get Domain from Email Address ~ Quickly!!](https://geekexcel.com/excel-formulas-to-get-domain-from-email-address/)**