Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

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?
ee.PNG
0
PeterBaileyUk
Asked:
PeterBaileyUk
  • 2
1 Solution
 
Arno KosterCommented:
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.
0
 
Arno KosterCommented:
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

0
 
PeterBaileyUkAuthor Commented:
I feel silly seeing how simple that was! thank you for your quick reply!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now