how to find the rate between numbers

G

ghost

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?
 
K

KC Rippstein hotmail com>

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%
 
G

Gord Dibben

With 2004(100000) number in A1 and 2005(101000) number in B1

In C1 enter =(B1-A1)/A1 returns 1% increase

10000 and 11000 returns 10% increase


Gord Dibben MS Excel MVP
 
Top