AND function not working when coupled with and OR and IF cell?

[amandabstewart]

I have an AND function not working

Cell F14 contains a working OR statement and returns "TRUE" when conditions are met
Cell G14 contains a working IF statement and returns "TRUE" when conditions are met

I want cell H14 to return "TRUE" when F14 and G14 both contain true.

The following in H14:

=AND(F14="TRUE",G14="TRUE")

is only returning FALSE even when both F14 and G14 contain true. Other AND statements I've written work fine...so I'm confused here and hope it's something stupid and minor!

any suggestions as to what is wrong?

 

[XOR LX]

Hi.

Remove the quotation marks around TRUE and FALSE. Boolean TRUE/FALSE values are not identical to text "TRUE"/"FALSE" entries.

Regards

 

[amandabstewart]

THANK YOU! I thought I had tried that already, but, apparently no. I'm blonde--so using that excuse for now.

Thanks again!

 

[XOR LX]

Haha!

You're welcome!