I read it as the current formula will return less than 0 until an update, so
until then return a 0.
=if('H:\Morning Reports
2005\Nov\[11-14-05.xls]Production'!$N$52)<0,0.'H:\Morning Reports
2005\Nov\[11-14-05.xls]Production'!$N$52
HTH
Regards,
Howard
"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