Follow these steps to determine percentage variances in Excel:

- Click—do not double-click—the desired percentage variance cell.
- On the
**Home** tab, go to the** Number** group and click **%** (the percent sign). For location purposes, the field above the percent sign reads **Percentage**. - Return to the desired percentage variance cell and double-click it.
- You are now ready to create your formula.
- Type the equals sign (
**=** ) followed by** (** [an opening parenthesis, also known as an opening bracket]. Do not use adjacent spaces. - Click the cell containing the FIRST of the two quantities to be compared.
- The cell coordinates will appear in the formula cell immediately after the opening parenthesis.
- In the formula cell, type
**/** (the division sign) immediately after the first set of coordinates. Do not use adjacent spaces. - Click the cell containing the SECOND of the two quantities to be compared.
- The cell coordinates will appear in the formula cell immediately after the division sign. Do not use adjacent spaces.
- In the formula cell, type
**)** [a closing parenthesis]. - Type
**-1** immediately after the closing parenthesis. - Click any cell that does not contain a numerical value.
- The percentage variance cell will populate automatically based on your formula.
- Go to
**File** > **Save** or **File** > **Save As** and save your work. - Check your work visually.
- In the
**Formulas** tab, go to the **Formula Auditing** group. - Select
**Error Checking**. - Correct all errors and recalculate.
- Congratulations—you’re done!

Want more step-by-step guidance? Get in touch.

**HOME | BIOGRAPHY | PORTFOLIO |** **PRICING**

**TESTIMONIALS | CONTACT**

### Like this:

Like Loading...