Conditional formula miscalculating blank cells
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
|