Formula reading formula instead of cell content

Column I has this formula: =IF(AND(H173>K173,AH173<0),"Past TAT","")

Column H also has a formula that sums days.
=IF(OR(Y173<>"",W173=""),"",TODAY()-W173)

Column H is working and producing no days as required. However, the formula
in column I seems to be seeing the formula in column H instead of the blank
cell and keeps giving me a "Past TAT." When I delete the cell formula from
column H, the "Past TAT" disappears from column I.

Maybe instead of a blank cell it should have a zero when the conditions are
met.

Help.

I figured it out. The formula in column I should have been as follows:
=IF(AND(H173>K173,Y173=""),"Past TAT","")

"roy.okinawa" wrote:

> Column I has this formula: =IF(AND(H173>K173,AH173<0),"Past TAT","")
>
> Column H also has a formula that sums days.
> =IF(OR(Y173<>"",W173=""),"",TODAY()-W173)
>
> Column H is working and producing no days as required. However, the formula
> in column I seems to be seeing the formula in column H instead of the blank
> cell and keeps giving me a "Past TAT." When I delete the cell formula from
> column H, the "Past TAT" disappears from column I.
>
> Maybe instead of a blank cell it should have a zero when the conditions are
> met.
>
> Help.
>