LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increasing a whole Spreadsheet by a percent Nicole Excel Discussion (Misc queries) 1 October 10th 06 08:58 PM
Percent change cardfan057 Excel Discussion (Misc queries) 4 May 10th 06 04:29 PM
Percent Change Ralph D via OfficeKB.com Excel Discussion (Misc queries) 1 December 8th 05 08:18 PM
Percent Change Tom B via OfficeKB.com Excel Discussion (Misc queries) 4 July 29th 05 04:42 PM
percent change stephenm Excel Worksheet Functions 5 July 19th 05 01:33 AM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"