IF(AND with IF(OR

[jlove]

Trying to nail the syntax for:

IF(OR(A1="TRUE", B1="TRUE", C1="TRUE" Return "TRUE"
elseIF(AND(A1="FALSE", B1="FALSE", C1="FALSE" Return "FALSE"
else "Unknown"

 

[alansidman]

=if(or(A1="True",B1="True",C1="True"),"True",if(and(A1="False",B1="False",C1="False"),"False","Unknown")))

 

[Eric W]

How about:

=IF(AND(A1:C1),TRUE,IF(OR(A1:C1),"Unknown",FALSE))

 

[tico_ocit]

=IF(OR(A10="True",B10="True",C10="True"),"TRUE",IF(AND(A10="False",B10="False",C10="False"),"FALSE","Unknown"))

Is that?

 

[jlove]

No, however if I remove the last parenthesis it will always return "Unknown"

 

[tico_ocit]

No, however if I remove the last parenthesis it will always return "Unknown"

I've tryed mine, and works perfectly. One True gives "TRUE", 3 Falses gives "FALSE".

 

[jlove]

Always returns "Unknown"

 

[Eric W]

In words, what are you trying to accomplish? alansidman and tico_ocit seem to have created a formula matching your request. But if your goal is to return TRUE if A1:C1 are all true, or FALSE if A1:C1 are all false, and Unknown otherwise, check my formula in post 3.

 

[jlove]

Could it be that the values in my cells are coming from Lookups?

 

[DanteAmor]

It would help, if you put what you have in the cells and what you expect from the result.


Check if in the cell you have the text "True" or you have the Boolean value True.

It is definitely necessary that you put the examples, we are blind with what you try.