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.

 

[Joe4]

If you simply want to check for the condition if all are TRUE, you do not need to nest IF statements, you would just use:

=IF([COLOR=#0000ff]AND(N2="TRUE",Y2="TRUE,"AC2="TRUE",AI2="TRUE",...)[/COLOR],[COLOR=#008000][I]what to return if all are TRUE[/I][/COLOR],[I][COLOR=#ff0000]what to return otherwise[/COLOR][/I])

 

[offthelip]

if you change the "and" to "then" it will work, by nesting the if statement you get ann implicit "and" function

If Range("n2").Value = "true" Then
If Range("w2").Value = "true" Then

 

[wideboydixon]

If they are proper booleans (TRUE/FALSE) then you could also do:

=IF(N2*W2*Y2*AC2*AI2*AN2*AQ2=1,[True Part],[False Part])

WBD

 

[offthelip]

You don't need to equate values to true in the equation either, a furthere simplification of Joes code

=IF(AND(N2,Y2,AC2,AI2,...),what to return if all are TRUE,what to return otherwise

 

[Joe4]

You don't need to equate values to true in the equation either, a furthere simplification of Joes code

That it true, provided that they are boolean entries and not text.
Cannot be certain from the original post, as they enclosed all TRUE values in double-quotes, which seems to imply text and not boolean, but that could just be a mistake on their part.

 

[Sphinx404]

You guys are all stellar. Your comments are exactly what I needed to see, Thank you all very much! This information will get me on my journey.

In addition to your solutions, I am going to use my foresight and prematurely ask a question that will arise once I get the TRUE values determined...

Another parameter that was a requested addition to the macro...

If AO2 = FALSE then AP2 must be blank
If AO2 = TRUE then AP2 must have value

I can do the simple IF function, but is there a universal symbol or character for checking if cells are blank or have values (any value at all)?

=IF(AND(AO2="FALSE",AP2=""),"TRUE","FALSE")
=IF(AND(AO2="TRUE",AP2=[COLOR=#ff0000]???[/COLOR]),"TRUE","FALSE")

Code above looks... eh, not so great.

 

[Joe4]

To check to see if it is NOT blank, you can use:

AP2 <> ""

or

LEN(AP2) > 0

 

[Sphinx404]

Thank you @Joe4

Always appreciative of your help

 

[Joe4]

You are welcome.
Glad we could help.