| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide blank rows after data whilst leaving some blanks. | New Users to Excel | |||
| hide (blank) in pivot table | Excel Discussion (Misc queries) | |||
| Hide Blank Rows | Excel Worksheet Functions | |||
| how do you hide the #DIV/0! in a blank spreadsheet? | Excel Discussion (Misc queries) | |||
| remove or hide blank rows | Excel Discussion (Misc queries) | |||
Threaded Mode
