![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |
![]() |
kevin_ms | Excel | 4 | 09-14-2008 10:08 PM |