I have the following forumla which should tell Excel to return the value of 1 if true or 0 if false. However, I am getting the words and not the numbers.

=IF(OR(Properties!$AX3="Y",Properties!$AT3="N",Properties!$Q3={"Y","O","AO"}),AND(OR(Properties!$AX3="",Properties!$AT3="N",Properties!$Q3={"O","AO"}),1,0))
Can anyone see where I am going wrong?

Thanks for your help.