Negative number returned as zero

[singlgl1]

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

 

[Bob Phillips]

Do you mean

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



--

HTH

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

 

[L. Howard Kittle]

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]

Thanks for pointing me in the right direction