I am using Excel 2007. This seems silly to me, but I don't see an
easy work around. I have a cell that has data validation set be whole
numbers between 0 and 999 and with "ignore blanks" checked. This
works fine UNLESS I use a formula in the cell that returns a blank, at
which point I get a data validation error.

Note that if I manually enter a blank then I do not get an error.

An example of the formula is

=if(A1="","",A1)

I want to distinguish the value of 0 from the value of blank. Is there
a different way to enter a blank in a formula that will be interpreted
as a blank by the data validation?

Thanks,
Rick