 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Hide blank data
I have a simple spreadsheet that lists credits/debits and balance in 3 columns I want to have a running total in the balance column. How can I keep the formula for each cell but not show it as say £0.00, until it is actually populated with valid data Currently the formula is =SUM(F7,-D8,E8) D column is debits, E column is credits, F column is balance Any suggestions would be much appreciated. Thanks Mat hi try this... =IF(SUM(F7,-D8,E8)=0,"",SUM(F7,-D8,E8)) regards FST1 > I have a simple spreadsheet that lists credits/debits and balance in 3 columns > I want to have a running total in the balance column. [quoted text clipped - 6 lines] > Thanks > Mat But presumably there may be valid data which would give a sum of zero? If the OP doesn't want an answer until data is entered in all 3 input cells, then perhaps: =IF(COUNT(F7,-D8,E8)=3,SUM(F7,-D8,E8),"") -- David Biddulph > hi > try this... [quoted text clipped - 15 lines] >> Thanks >> Mat Hi Thanks for these, but the main thing I need is to show the cell blank if nothing is entered - the user will enter either a debit or a credit alongwith the business details and the running total on the right will update - but it will be a blank cell otherwise (I do not want a whole column of '£0.00' shown.) Does this explain it better ? Thanks Mat > But presumably there may be valid data which would give a sum of zero? > [quoted text clipped - 23 lines] > >> Thanks > >> Mat So in which situation do you want the result blank? I've already given you the formula which will give a blank result if any of the 3 input cells is blank. If you want a blank result only if *all 3* input cells are blank, change my formula from =IF(COUNT(F7,-D8,E8)=3,SUM(F7,-D8,E8),"") to =IF(COUNT(F7,-D8,E8)<>0,SUM(F7,-D8,E8),"")  SignatureDavid Biddulph > Hi > Thanks for these, but the main thing I need is to show the cell blank if [quoted text clipped - 36 lines] >> >> Thanks >> >> Mat |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.