I have this formula in cell I: =IF(H228>K228,"Past TAT","")
I Have this formula in cell H: =IF(OR(Y228<>"",W228=""),"",TODAY()-W228)
Here is the problem: Even though cell H is blank because no date has yet
been added to cell W, cell I keeps showing "Past TAT." It seems that the
cell I sees something in cell H, but it is blank other than the formula that
is not seen.
When I hit the delete key while in cell H, the Past TAT in cell I
disappears, however, then I hit the space bar and the Past TAT reappears.
But now there is no number or formula in cell H. So I am not sure what is
going on.
Bookmarks