So from the first year to last year revenue has been decreased by 2098. Select cell C3 click on the lower right corner of cell C3 and drag it down to cell C13. For example if the original value is 160 and the new value is 120.
How Excel percent variance formula works.
The percentage change formula can track the prices of individual securities and large market indexes. Apply the above formula to all the remaining cells to see the percentage change between the first year and last year. Calculate the change subtract old value from the new value Step 2. Select a blank cell for locating the calculated percentage change then enter formula A3-A2A2 into the Formula Bar and then press the Enter key.