Morrigan Wrote:
Just do a simple COUNTIF() or put COUNTIF() inside an IF() statement:

=IF(COUNTIF()0,"X","no apple")


Hope it helps.

Yes...this is exactly what I want, I thought of it but wasn't sure how
the syntax put togeter. Thanks Morrigan.


--
canix
------------------------------------------------------------------------
canix's Profile: http://www.excelforum.com/member.php...o&userid=25962
View this thread: http://www.excelforum.com/showthread...hreadid=393304