Forum Discussion
Display result as a zero instead of a blank cell
packie Both formulas return 0 for me if there's noting to count or sum. I suspect that you have a custom format (like General;General;) that suppresses zeros. Set the cell format to General and you should get zeros back.
I will want to keep the format General;General; though, is there a work around I could use?
The format General;General; explicitly suppresses 0 values because the 3rd section (after the 2nd semicolon) is empty.
I'd use General, as suggested by Riny_van_Eekelen but if you really want to, you could use General;General;General or General;General;0
packie Not really. If you do not want to show zeros as blanks, you can't not use that custom format.
Of course, you could construct a formula like:
=IF(countif_formula=0, "0", countif_formula)
That will return a text "0" which will not be affected by the custom format. But why?
