hide

[imported_unknown]

Hi! I have a spreadsheet set up with each month on it. Each month has a column with $0.00 in it for our services each month. My question is, can I hide the information in the other columns and only display the current months charges. I do not want to hide the other columns, just the information in them. Below is an example:

Jan Feb Mar Apr
5.00 0.00 0.00 0.00
3.00 0.00 0.00 0.00
1.00 0.00 0.00 0.00
8.00 0.00 0.00 0.00

I only want to display the information where charges appear. I would like to hide the 0.00 for the other months until that month is current. I have formulas figuring those amounts (0.00). Maybe even set it up where only an amount shows up if there is a charge and if not, it remains blank. I hope this helps. Thanks a million!

Scott

 

[Fryer Tuck]

I usually use the
=If(formula evaluates to 0,"",formula)
F.T.

 

[imported_unknown]

Okay, but I forget to mention that I have this page linked to another page and the formuala reads:

='Y:[blank-bs.xls]January'!$G$11

This is the formuala that gives me a 0.00. How do I incorporate what you told me into this formula? Thanks for your help!

Scott

 

[Fryer Tuck]

if('Y:[blank-bs.xls]January'!$G$11
=0,"",'Y:[blank-bs.xls]January'!$G$11
)

 

[imported_unknown]

Thanks!