Combining IF AND formulas

Hi,
I have 6 separate IF AND statements and I want to consolidate them into one single formula but I don't know how to do this. The formulas are:


=IF(AND(F2="NACK Received",H2=H1,C2<C1),"YES", "NO")
=IF(AND(F2="ACK Received",H2=H3,C2>C3),"YES", "NO")
=IF(AND(E2="EXPIRY",H2=H1,C2<C1),"YES", "NO")
=IF(AND(E2="TERMINATION",H2=H1,C2<C1),"YES", "NO")
=IF(AND(E2="TRADE_CANCEL",H2=H1,C2<C1),"YES", "NO")
=IF(AND(E2="UNVERIFIED",H2=H1,C2<C1),"YES", "NO")

IS there any way to do this?

Any help would be greatly appreciated.

Thanks,
Tom

Thanks a Million guys this works perfectly! Didn't realise it was a simple as combining all of them!

That has worked great but when i try and incorporate this formula into a macro i get a run time error 1004...

ANy ideas on how i can bring it into a macro?

try(not macro solution)

=IF(AND(OR(E2="TERMINATION",E2="TRADE_CANCEL",E2="UNVERIFIED",E2="EXPIRY",F2="NACK Received"),H2=H1,C2<C1),"YES",IF(AND(F2="ACK Received",H2=H3,C2>C3),"YES","NO"))

Post macro.

Please Login or Register  to view this content.

That's the formula I've been using and it works fine apart from when I try and record it as part of a macro.


It appears like this in the macro code and when i try and run it, it gives me a runtime error 1004.

Please Login or Register  to view this content.