We help IT Professionals succeed at work.

increase or decrease between cells in excel

PeterBaileyUk
on
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?
ee.PNG
Comment
Watch Question

in cell T20 you could enter the formula:

=K20-B20

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:

=(K20-B20)/B20

Open in new window

Author

Commented:
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.