The information you gave suggests that, for example, if A1 is not being
answered and you do not want B1 to be filled, then in B1 you write:
=IF(A1=0,"","")
Does that work?
GeorgeF
--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile:
http://www.excelforum.com/member.php...o&userid=24124
View this thread:
http://www.excelforum.com/showthread...hreadid=473321