Quote Originally Posted by Phil_V View Post
You function "does what it says on the tin", (ie. it behaves as expected).
Where is your input data coming from? It is possible that the cell actually contains the TEXT, "TRUE", or "FALSE" rather than the value TRUE, or FALSE.

What do you get if you change your function as per below:
[code]=IF(OR(L3="TRUE",AND(L3="FALSE", M3="TRUE")),TRUE,FALSE)[code]
Well my input data is from the two columns in the first part of my original post and the cells are the boolean TRUE and FALSE not the text. But I forgot to mention the error outright. The problem is that the function misrecognizes the AND parameter; if L3 is FALSE and M3 is TRUE the function still returns FALSE.