IF AND - multiple statements - VBA EASIER WAY??

[Sphinx404]

I have about 12 statements that I need to verify are "TRUE". However, something that seems like it should be simple is causing me headaches.

I am working to incorporate this into a macro and thus far, I've just gone ahead and used the:
=IF(AND
formula to try and help me sort out the problem, but even this is causing problems.

Can someone read into the code below and tell me what I am doing wrong?

=IF(AND(N2="TRUE",IF(W2="TRUE",IF(Y2="TRUE",IF(AC2="TRUE",IF(AI2="TRUE",IF(AN2="TRUE",IF(AQ2"MATCH")))))))),"TRUE"))

I honestly would like to do basic if function for all of these such as:

if range("n2").value ="true" and
if range("w2").value = "true" and
'etc. etc. etc.

but I have no idea how to do that above and get it to work correctly. It doesn't like my "and" statements.

Any help and guidance would be greatly appreciated.

 

[offthelip]

You don't need the If statements in:

=IF(AND(AO2="FALSE",AP2=""),"TRUE","FALSE")
=IF(AND(AO2="TRUE",AP2=???),"TRUE","FALSE"

Provided the cells are not specifically formatted to included the Text "TRUE" rather than just typing TRUE into it the following will work fine:

=AND(AO2="FALSE",AP2="")
=AND(AO2="TRUE",AP2<>"")