Excel Formulas Tutorials and Expert Advice

QUESTION

Can I calculate percent increase of revenue from year to year?

ANSWER

Well... Let's assume that revenue for year 1 is in cell A1 and revenue for year 2 is in cell A2.

The formula will be:

=(A2-A1)/A1*100

Note that if your cell is formatted as percent, you should drop the *100 at the end of the formula.

 

Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us