2005 revenue divided by 2004 revenue minus 1
So if rev04 is in A1 and rev05 in B1, C1 = B1/A1-1

Then I would suggest formatting cell C1 (hit ctrl+1) and under the Number
tab select custom and type +0.0%;-0.0%
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"ghost" wrote:

Hi,
I have a datasheet for calculating a a revenue and expenses. What I want to
do is Calculating the rate (%) by which the Food and Home Delivery Revenues
have increased between 2004 to 2005.
The food revenue in 2004 is 100000 and in 2005 101000
The home delivery in 2004 is10000 and in 2005 is 11000
Can any one know the answer?