Percent change between two worksheets on same spreadsheet
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
|