document updated 17 years ago, on Feb 15, 2008

One method for using =if(,,) to generate blank cells when false is to:

=if(a1>0,a1,"")

However, the "" tends to screw up =count() and =isblank(). Here are the specific details:

	isblank()	len()	<>""	=""
truly empty cell	TRUE	0	FALSE	TRUE (??)
zero spaces ("")	FALSE	0	FALSE	TRUE
one space (" ")	FALSE	1	TRUE	FALSE

So, instead of count(a1:a5) or countblank(a1:a5), use one of these alternatives: (all of which count "" the same as a truly empty cell)