Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
On Sheet #1 I have a list of amounts that I have added together for week one in 2006. On Sheet #2 I have a list of amounts for week 1 2007. I want to a find the difference in percet from week 1 in 2006 to week 1 in 2007. When I do the operation it keeps giving me an answer of zero. ??? Im confucsed it seems like a simple operation. This is the formula that is giving me the answer of zero: (2006 is the name of sheet #1, this formula is on sheet #2 called 2007) ='2006'!C50/'2007'!D50 thank you Heath Taubitz Lockheed Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Increasing a whole Spreadsheet by a percent | Excel Discussion (Misc queries) | |||
Percent change | Excel Discussion (Misc queries) | |||
Percent Change | Excel Discussion (Misc queries) | |||
Percent Change | Excel Discussion (Misc queries) | |||
percent change | Excel Worksheet Functions |