| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to either hide data in a cell or reduce the data to zero
I am setting up a balance sheet and I have data in columns "E" and "F" that
show income and outgoings then in column "G" I have a balance. To get this balance I use the formula: =SUM(G6+F7-E7) and then drag the fomula down column "G". However this leaves the total for that entry in cell "G5" to copy down column "G" as well. I tried using this fomula: =IF(OR((E7="0"),(F7="0")),"",E7-F7) Which hides the cell data which is fine but i want to incorporate the previous balance (in the cell above (E6)) when i do that in the formula below: =IF(OR((E7="0"),(F7="0")),"",G6+E7-F7) It Just displays the total down column "G" as before Is there a way to stop this happening or a way to trick excel in to changing the unwanted data to "0" so I can hide it? I hope you understand this Question I am really confused (and so might you be) any help at all is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to either hide data in a cell or reduce the data to zero
Hi,
If I understood your problem ... 1. In cell G1 : =F1-E1 2. In cell G2 : =G1+F2-E2 and then from G2 downwards just copy formula ... HTH |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to either hide data in a cell or reduce the data to zero
Remove the quotes from around the 0's in your formula.
The quotes make them text values and your formula won't find them. Gord Dibben MS Excel MVP On Fri, 8 Feb 2008 22:31:00 -0800, Dobbin0_4 wrote: I am setting up a balance sheet and I have data in columns "E" and "F" that show income and outgoings then in column "G" I have a balance. To get this balance I use the formula: =SUM(G6+F7-E7) and then drag the fomula down column "G". However this leaves the total for that entry in cell "G5" to copy down column "G" as well. I tried using this fomula: =IF(OR((E7="0"),(F7="0")),"",E7-F7) Which hides the cell data which is fine but i want to incorporate the previous balance (in the cell above (E6)) when i do that in the formula below: =IF(OR((E7="0"),(F7="0")),"",G6+E7-F7) It Just displays the total down column "G" as before Is there a way to stop this happening or a way to trick excel in to changing the unwanted data to "0" so I can hide it? I hope you understand this Question I am really confused (and so might you be) any help at all is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you hide the value of a cell until data is keyed into anoth | Excel Discussion (Misc queries) | |||
| I want to hide values if no data in target cell | Excel Worksheet Functions | |||
| How do I reduce the number of data points I have?? | Charts and Charting in Excel | |||
| Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
| HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) | |||
![Dobbin0_4[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
