Can You Do This....

[Mike]

=IF(C13>0,D12-C13,0)
This is My formula,
I was woundering if you can hide the zero's in the cells if value is zero
I have made a speedsheet to track Lotto Sales & Inventory
Any help would be Great

Thank you

 

[Gord Dibben]

Will this do?

=IF(C13>0,D12-C13,"")

If not, use Conditional Formatting to color the font white if cell reads zero.

Format>CF>Cell Value is: equal to 0

Format font to white.


Gord Dibben MS Excel MVP

 

[Matt]

Tool, Options, View tab and uncheck the "Zero values" box. Should work. )

Matt