How do I define a true null in a cell in Excel 2002

[TK]

Instead of testing for an empty string, try something like:

=IF(cell & " " <> " ", 1,"")

By concatenating a space (or any character) to the 'blank'
cell it won't matter if the cell is truly blank, or if it
is an empty string.

HTH,

TK