The best way to calculate qtr over qtr performance is the following.
X = Previous Qtr Revenue
Y = New Quarters Revenue
The formula is:
=(Y-X)\X
So in your example for Q1 to Q2 revenue would be:
=(75-50)/50 = 50%
So the increase Qtr over Qtr was 50% You always devide (the difference
from the new quarter to the old quarter) from the old quarter becuase
that is the % you are looking for the delta from.
HTH,
PZan
--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile:
http://www.excelforum.com/member.php...o&userid=23480
View this thread:
http://www.excelforum.com/showthread...hreadid=393937