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

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.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=492619

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

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