Excel formula question - why can't i think of this?

[Transition]

Maybe because it's friday..

anyways.. all i need to do is calculate the percentage increase between two cells.. Say a cell with sales from 2001, and sales in another cell for 2000 - all i need to do is be able to calculate the percentage increase/decrease.. Anyone wanna help me with this simple formula?

Thanks

 

[NakaNaka]

[ (2001-2000) / 2000 ] * 100

That seem right??

 

[kranky]

(2001sales-2000sales)/2000sales

 

[HomeBrewerDude]

drink more coffee

 

[Transition]

Thanks guys!

 

[dullard]

<< [ (2001-2000) / 2000 ] * 100

That seem right?? >>


I may be picky but this is my pet peeve. You can multiply any result by 1 and get the same answer. You cannot multiply by 100 and get the same answer. The value 100 does not equal 100%. Instead 100% = 1. Your formula will give 100 times the percentage desired. The correct formula would be one of these:

[ (2001-2000) / 2000 ] * 100%

or even easier,

[ (2001-2000) / 2000 ]