Negative number returned as zero

  • Thread starter Thread starter singlgl1
  • Start date Start date
S

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
 
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)
 
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
 
Back
Top