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","")))
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","")))