Question: how to calculate variance between two percentages in excel?
Answer: You can use Excel to calculate the percentage of change between two values quickly. ... 
Start by selecting the first cell in the “Percentage of Change” column.
Type the following formula and then press Enter: =(F3-E3)/E3.
The result will appear in the cell.