View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thank you, Heath Thank you, Heath is offline
external usenet poster
 
Posts: 10
Default 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