I have a formula, such as the one below that will return a negative
number until another worksheet is updated.I'd like for this to return a
zero until it becomes a positive number.Can someone help?

='H:\Morning Reports 2005\Nov\[11-14-05.xls]Production'!$N$52


--
singlgl1
------------------------------------------------------------------------
singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389
View this thread: http://www.excelforum.com/showthread...hreadid=484716