Thanx to both chad and duane. I solved the problem. I took part of
chad's advise by replacing the " " in my IF statement with "0s" in the
linked data cells, and whoola, it worked. You guys are my hero
.............


--
salulu
------------------------------------------------------------------------
salulu's Profile: http://www.excelforum.com/member.php...o&userid=27042
View this thread: http://www.excelforum.com/showthread...hreadid=461767