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