Formula returning result of "True" or "False" instead of "1" or "0"

**AllenMead** · 10-12-2010, 05:53 AM

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.

Please Login or Register  to view this content.

Can anyone see where I am going wrong?

Thanks for your help.

**peterjuhnke** · 10-12-2010, 06:07 AM

Please attach a dummy sheet see we can see what you have in the other cells etc.
Regards
Peter

**teylyn** · 10-12-2010, 06:10 AM

Try to sort out your brackets. I assume you may want

Please Login or Register  to view this content.

**AllenMead** · 10-12-2010, 06:33 AM

Hi Peter, unfortunately, I am not in a position to upload a dummy sheet which I appreciate would help understand the context.

Teylyn, unfortunately, this counts everything in column Q which is 1000, my answer should be 50. I need to spend a little more time on this which I can't do right now but really appreciate your help.

**teylyn** · 10-12-2010, 06:40 AM

Let's take apart your original formula

=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))

The fact that it ends in 2 brackets is enough to tell me that the brackets are not placed correctly. Red is the condition, blue is the TRUE part, Green is the FALSE part. I'm sure that's not what you have in mind.

Your formula delivers TRUE because in some cases the TRUE part is executed. In your formula, the TRUE part is in itself a comparison, which will deliver TRUE or FALSE as the result.

Again, your brackets are not in the correct positions.

I can't quite picture your spreadsheet in my crystal ball, so unless you manage to place your brackets in the correct places yourself, you'll have to post it, and an example of the expected result.