If a part of the formula is in. To calculate the difference as a percentage we subtract this months value from last months and then divide the result by last months value. We want to show the total estimated amount not just the increase.
Excel uses a default order in which calculations occur.
Since we have a number mixed with text Excel will treat the entire cell as text. On the Home tab click the Percentage button. Percent Change B - A A When applying this formula to real data it is important that you correctly determine which value is A and which is B. How Excel percent variance formula works.