Basic IF function help needed

This should be a pretty easy fix for most of you but I guess I'm just missing something.

I'm comparing data from two columns like this:

FALSE
FALSE
FALSE TRUE
FALSE FALSE
FALSE
FALSE

and my goal is to have a TRUE or FALSE in the third column for the following criteria:

TRUE if left column equals TRUE or if left column equals FALSE and right column equals TRUE

False if else

My function: =IF(OR(L3=TRUE,AND(L3=FALSE, M3=TRUE)),TRUE,FALSE)
where L is the left column and M is the right column.

Here is the data set with the expected results:

FALSE FALSE
FALSE FALSE
FALSE TRUE TRUE
FALSE FALSE FALSE
FALSE FALSE
FALSE

Thanks.

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:

Please Login or Register  to view this content.

I'm using Excel 2003, in case that makes a difference, but it works fine here:

Please Login or Register  to view this content.

Try the attached workbook and see what you get?

Can you elaborate on what the problem / solution was in the end?