IF Statement Question?

[Wigman86]

Hello Everyone

I am pulling a blank and need help.

I want my if statement to do the following - If cell A11 = TRUE Return "BLACK"
If cell B11 = TRUE Return "WHITE"
IF cells A11 and B11 = TRUE Return "BLACK AND WHITE"

The code I have is below but i cannot get it to work. Thanks in advance for any help:

=IF(A11="TRUE","BLACK",IF(B11="TRUE","WHITE",IF(AND(A11="TRUE",B11="TRUE"),"BLACK AND WHITE","")))

 

[dreid1011]

Try this:

=IF(AND(A11="TRUE",B11="TRUE"),"BLACK AND WHITE",IF(AND(A11="TRUE", B11<>"TRUE"),"BLACK",IF(AND(A11<>"TRUE",B11="TRUE"),"WHITE","")))

Or try this if the TRUE results are from a formula.

=IF(AND(A11=TRUE,B11=TRUE),"BLACK AND WHITE",IF(AND(A11=TRUE, B11<>TRUE),"BLACK",IF(AND(A11<>TRUE,B11=TRUE),"WHITE","")))

 

[Wigman86]

Try this:

=IF(AND(A11="TRUE",B11="TRUE"),"BLACK AND WHITE",IF(AND(A11="TRUE", B11<>"TRUE"),"BLACK",IF(AND(A11<>"TRUE",B11="TRUE"),"WHITE","")))

Or try this if the TRUE results are from a formula.

=IF(AND(A11=TRUE,B11=TRUE),"BLACK AND WHITE",IF(AND(A11=TRUE, B11<>TRUE),"BLACK",IF(AND(A11<>TRUE,B11=TRUE),"WHITE","")))

Thank you so much. This works great!!!!!

 

[dreid1011]

You're welcome.