LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Stevie
 
Posts: n/a
Default Help with simple data table?

I'm stuck. Using Excel 2002, Win XP Pro

Here's a two-column data table and one column is where I enter a daily
number. The next column shows the difference between the present day and
the day before as a positive number.

Here's the file:
http://home.alltel.net/sayres5762/differencechart.xls

I'm using =IF(C80,C7-C8,"") to calculate the difference and display a
blank if there's no data.

The problem is when I must skip a day or two. I want to be able to leave
empty cells in Column C and have it not affect the Difference column or the
Total Difference. And if the Data entry is blank, I want the Difference to
display a blank, as well.

On the table enter a number.. say "80" on January 8 and you'll see what I
mean.

I've learned a few simple formulas but still have a way to go. Any help
would be appreciated.

Steve


 
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
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM


All times are GMT +1. The time now is 11:28 AM.

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"