Formula reading formula instead of cell content

G

Guest

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top