Formula to meet multiple conditions

[Dan27]

Hello

I'm hoping someone can help. I'm trying to write a formula with multiple conditions but I'm not sure a nested statement would work.

I want to say IF (H2=J2) AND (G2=AJ2) AND (AI2="CLOSED"),1,0

Hope my logic above kind of explains what I'm looking to do!

Thanks in advance
Dan

[63falcondude]

Try this:

=IF(AND(H2=J2,G2=AJ2,AI2="CLOSED"),1,0)

or a little bit shorter:

=--AND(H2=J2,G2=AJ2,AI2="CLOSED")