We help IT Professionals succeed at work.

increase or decrease between cells in excel

I have two groups of data and i want to work out the percentage increase or decrease against the cell values.

cell B20 58%
cell k20 70%

what is the formula to determine its rate of increase or decrease?
Watch Question

in cell T20 you could enter the formula:


Open in new window

this would give you the value of 12%.

decreases would lead to negative values.
if you would rather want the value of 21% (to state that 70 is a 21 percent increase to the previous value of 58), use:


Open in new window


I feel silly seeing how simple that was! thank you for your quick reply!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.