| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show cell empty when 0
I have the following formulas:
Down column B: =SUMPRODUCT(--(MONTH(MAIN!$A$10:$A$4999)=MONTH($G$1)),--(DAY(MAIN!$A$10:$A$4999)=DAY($A1)),MAIN!$D$10:$D$4 999) Down column C: C1 =B1 then C2 onwards =SUM(C1+B2) How do I get both columns to show an empty cell if the figure is zero? -- WH99 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup to Show Empty Cell | Excel Worksheet Functions | |||
| using a vlookup, can i use isblank to show an empty cell | Excel Worksheet Functions | |||
| show 0.00 if referenced cell is empty | Excel Worksheet Functions | |||
| Using if function to show blank when cell in other sheet is empty | Excel Worksheet Functions | |||
| Need cells to show as zero or empty | Excel Worksheet Functions | |||
Threaded Mode
