S shibulal Member Mar 13, 2012 #1 When I extract the result with DSUM 4mula, the cell turns 0 where there is not match. How can I suppress those ZEROs ?....
When I extract the result with DSUM 4mula, the cell turns 0 where there is not match. How can I suppress those ZEROs ?....
Luke M Excel Ninja Staff member Mar 13, 2012 #2 How about: =IF(DSUM(...)=0,"",DSUM(...)) Or, you can also go to Tools - Options - View, and hide all the zeros in your worksheet.
How about: =IF(DSUM(...)=0,"",DSUM(...)) Or, you can also go to Tools - Options - View, and hide all the zeros in your worksheet.