Formula never evaluates false
<p>I have a formula
=IF(AND(AG6="yes",AL6="yes"),"Both",IF(AND(AG6="no",AL6="no"),"Neither",IF(AG6="Yes",1,2)))</p>

<p>It just looks for values and then substitutes a value depending on what it finds.</p>

<p>The problem is that it always finds an answer even if all of the cells it is looking at are blank.  What I want is for it to display some type of error - FALSE for instance - if the formula is not satisfied.</p>

<p>I'm sure it's simple...  And it seems like I've hit this before.</p>

<p>Thanks in advance.
Phil</p>