Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-09-2015, 06:19 PM
Chuck_Ds Chuck_Ds is offline How to make Excel stop treating blank cells as zero Windows 7 32bit How to make Excel stop treating blank cells as zero Office 2007
Novice
How to make Excel stop treating blank cells as zero
 
Join Date: Jan 2015
Posts: 6
Chuck_Ds is on a distinguished road
Default How to make Excel stop treating blank cells as zero

How do I make Excel stop treating blank cells as zero? Check out the following grid and my explanation, please.

Beginning Cost.........FinalCost ...........Savings
194............................................... ............ 194
286 .................................................. .........286
367 ................................315 ...................52


........................................Total Savings: 532


Column A is the initial cost, while Column B is the lower cost that i've negotiated. As negotiations are done, I'm updating column B with the "final cost." Column C, "Savings," simply computes the difference between column A and column B. At the bottom of Column C, I have a cell to compute the total savings using a basic "Sum" function. The problem is I want to keep a running tally of how much we'ved saved thus far and the fact that Excel is treating the blank cells as zero means that it's giving me inaccurate data. It appears that we've saved $532, when we've really only saved $52 thus far. I update Column B (Ending Cost) as that data becomes available. I know this should be a basic thing to do, but I've looked everywhere and haven't found the answer. Thanks in advance for your help!

Last edited by Chuck_Ds; 01-09-2015 at 06:29 PM. Reason: Excel Grid didn't post
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Excel stop treating blank cells as zero Excel VBA - Mandatory cells cannot stay blank? hussnainh8 Excel 9 12-28-2014 09:40 AM
Help with Subtotal(103, ) formula and blank cells zhl203 Excel 1 07-30-2014 03:40 PM
How to make Excel stop treating blank cells as zero want to make letterhead template with second page blank William Whitney Word 4 06-20-2014 05:59 AM
Join cells together separated by ; when some are blank leemoreau Excel 3 11-03-2013 11:22 AM
How to make Excel stop treating blank cells as zero How to stop correcting zeroes in cells ? kevin_ms Excel 4 09-14-2008 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft