| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to hide unused cells when running accumulated totals
I am running 2 columns to do accumulated totals. I have a formula such as
this: Cell b2 = a2+b1, Cell c2 = b2+c1 ect. I want to hide the accumulated totals until the cell in column one gets a value. How can I accomplish this? Thanks grano2 |
|
#2
|
|||
|
|||
|
Hi
Instead of =A2+B1, use =IF(A2="","",A2+B1) B2+C1 will change to =IF(B2="","",B2+C1) -- ve_2nd_at. Randburg, Gauteng, South Africa "grano2" wrote: I am running 2 columns to do accumulated totals. I have a formula such as this: Cell b2 = a2+b1, Cell c2 = b2+c1 ect. I want to hide the accumulated totals until the cell in column one gets a value. How can I accomplish this? Thanks grano2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide values in a running balance untill new data is entere. | Excel Discussion (Misc queries) | |||
| How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) | |||
| Macro to hide rows with empty cells | Excel Worksheet Functions | |||
| Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions | |||
| Can I hide locked cells? | Excel Worksheet Functions | |||
Linear Mode
