how to get % increase between 1 cell and another in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Example: Average number of orders over a 9 month period for a sales rep is 8
(the 8 is in cell b). Now I am doing the average number of orders for the
same sales rep over a period of 10 days which is now 24 (the 24 is in cell
g). How do I find the percentage increase between cell b and cell g?
 
Hi,

The percentage increase can be expressed as:
=(g1/b1)-1
with the cell formatted as %.
In this case gives 200%.

Hope that helps ?
Anthony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs and date comparison 3
Another "I can't quite get there" Sumproduct Forumla 1
Is that a macro or what? 1
how to countif when using indirect cell 1
How to determine the occurrence between periods? 1
average if with time and date 0
Calculate the value of Z 12
Lookup to create a table of data in terms of selection 1

Back
Top