So I have this nested IF statement that compares dates in various fields:
=IF(AND(G67>=X$2,G67<=Y$2,L67>=X$2,L67<=Y$2),"",IF(AND(L67>X$2,L67<=Y$2),"Closed",""))
It works fine. Now, I want to add a condition where if it sees the word 'CAPA' in column B, to stop and return "" (blank) and not perform the date evaluation.
I added B121="CAPA","" to the front of the formula, but it's not working:
=IF(B121="CAPA","",AND(G121>=X$2,G121<=Y$2,L121>=X$2,L121<=Y$2),"",IF(AND(L121>X$2,L121<=Y$2),"Closed",""))
Anyone know how to add this condition so it works?
Thanks in advance for any help!
=IF(AND(G67>=X$2,G67<=Y$2,L67>=X$2,L67<=Y$2),"",IF(AND(L67>X$2,L67<=Y$2),"Closed",""))
It works fine. Now, I want to add a condition where if it sees the word 'CAPA' in column B, to stop and return "" (blank) and not perform the date evaluation.
I added B121="CAPA","" to the front of the formula, but it's not working:
=IF(B121="CAPA","",AND(G121>=X$2,G121<=Y$2,L121>=X$2,L121<=Y$2),"",IF(AND(L121>X$2,L121<=Y$2),"Closed",""))
Anyone know how to add this condition so it works?
Thanks in advance for any help!