Need help with nested IF statement..

[Galena1]

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!

 

[Snakehips]

Galena1,

Try......
=IF(B121="CAPA","",IF(AND(G121>=X$2,G121<=Y$2,L121>=X$2,L121<=Y$2),"",IF(AND(L121>X$2,L121<=Y$2),"Closed","")))

Hope that helps.

 

[adam087]

You need another IF statement in front of the AND

/AJ

 

[Galena1]

Galena1,

Try......
=IF(B121="CAPA","",IF(AND(G121>=X$2,G121<=Y$2,L121>=X$2,L121<=Y$2),"",IF(AND(L121>X$2,L121<=Y$2),"Closed","")))

Hope that helps.

Thanks for your help snakehips!

And thanks everyone else for chiming in!