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)


"singlgl1" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[singlgl1]

Thanks for pointing me in the right direction