how to find the rate between numbers
 

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?

how to find the rate between numbers
 

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?

how to find the rate between numbers
 

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


On Sat, 3 Mar 2007 09:13:00 -0800, 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?