Will this do?

=IF(C130,D12-C13,"")

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

FormatCFCell Value is: equal to 0

Format font to white.


Gord Dibben MS Excel MVP

On Wed, 6 Sep 2006 19:14:02 -0700, Mike wrote:

=IF(C130,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