Percent of Increase...Is there such a formula?

  • Thread starter Thread starter Shayra
  • Start date Start date
S

Shayra

Is there such a formula that would allow me to determine the percent of
increase from say cells B3 to C3 given these cells have numerical figures in
them?
 
=(C3-B3)/B3
Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there such a formula that would allow me to determine the percent of
| increase from say cells B3 to C3 given these cells have numerical figures in
| them?
 
With 10 in B3 and 12 in C3

In D3 enter =(C3-B3)/B3 to return 20% increase


Gord Dibben MS Excel MVP
 

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

Monthly Percent Increase 1
How to Populate Data from a table to another 0
Percentage formula 1
Help with a formula 2
Forumla for %, i.e. 4 over 0 should equal 400% but get #DIV/0! 6
summarizing data from various workbooks 3
Excel Help to copy information from one row at a time to another sheet 1
Help with a range formula 4

Back
Top