As you can see, the change in percentage between two years was found to be 23%. Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.

Finding percentage change in Excel requires calculating the difference between two numbers, dividing that difference by the successive number and changing the decimal value to a percentage. In ...