Negative number returned as zero
 

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

Negative number returned as zero
 

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

Negative number returned as zero
 

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

Negative number returned as zero
 

Thanks for pointing me in the right direction


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