Re: Message pops up say can't divide by zero

[David Cicia <David.D.Cicia@xxxxxxxxxx>]

  I've run into this message a number of times. It seems that any use of
x/y leaves the possibility that y may be zero. What I have done is this:
x/IFF(y<>0,y,1). Not very pretty but gets the job done.
David Cicia

At 07:06 PM 8/27/98 -0500, Robert W Cummings wrote:
>Input: Price(C),Length(18),SDev(2),upper(100),Lower(-100);
>Plot1(((100*(Price-$Lowerband(Price,Length,SDev))/($Upperband(Price,Length,S
>Dev)-$Lowerband(Price,Length,SDev)))-50)*2,"Place");
>
>Can't figure what its needs without messing up what the original author was
>attempting to do here.
>Anybody see the problem it will verify.
>
>Thanks in Advance
>
>Robert
>
>