Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can You Do This....
=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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can You Do This....
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can You Do This....
Tool, Options, View tab and uncheck the "Zero values" box. Should work. :))
Matt "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|