Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find unknown interest rate using TVM functions | Excel Worksheet Functions | |||
Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions |