Do you mean

=IF('H:\Morning Reports
2005\Nov\[11-14-05.xls]Production'!$N$520,'H:\Morning Reports
2005\Nov\[11-14-05.xls]Production'!$N$52,0)



--

HTH

RP
(remove nothere from the email address if mailing direct)


"singlgl1" wrote in
message ...

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