=IF(OR(A1<0,A1=""),0,1)


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 16:57:00 -0800, Rob in Sydney <Rob in
wrote:

I am trying to create a conditional formula that will tag cells with data
points =0 as "1", if not =0, then a tag of "0". Excel is identifying blank
cells as though they contained a zero and therefore tags these blank cells as
a "1" when I need them to be reflected as a "0".

Can anyone help / advise how to correct this.

Thanks + happy new year