On Sun, 11 Dec 2005 20:43:06 -0600, famdamly
wrote:


Weird, when I put text in the queried field it returns true, and vise
versa for ISTEXT, I must not understand the logic of that.

=IF(ISNONTEXT(C2),A5=A5+1,A5=1)

Makes perfect sense if A5 contains a 1.

Your formula says to execute either:
A5=A5+1
or
A5=1

depending on the result of your logical test.

A5=A5+1 must always be FALSE.

A5=1 will be True if there is a '1' in A5.


--ron