[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Unidentified subject!



PureBytes Links

Trading Reference Links

RANGE/(IF(VOLUME<>0, VOLUME, 0.001))

try this
there is nothing wrong with using if statements to make a formula work.
Harley

On Mon, 30 Jun 1997 20:42:49 -0400,
Carey Barnett wrote...
>On the Web site there are many formulae.  One of these is the Market =
>Facilitation Index, MFI.  The formula given is RANGE/VOLUME.
>
>Plugging this in causes many division by zero errors, as commodity =
>contracts can have a zero volume when they begin to trade.  I've been =
>trying to get around this...
>
>RANGE/(IF(VOLUME<>0, VOLUME, 0))
>
>                  ...this is entirely unsatisfactory.  Does anyone have =
>a better idea?  Don't you think the choice to IGNORE DIVISION-BY-ZERO =
>errors would be nice?
>
>
>Carey Barnett
>
>"Burned bridges can't even be used for firewood."  cb'94
>Yeah... I know about charcoal.  Gimme a break!
>
>mailto:cbarnett@xxxxxxxxxxx
>http://webhome.idirect.com/~cbarnett
>Carey Barnett
>
>Remember "Burned bridges can't even be used for firewood."  cb '94
>Yeah, I know about charcoal.  Gimme a break!
>
>mailto:cbarnett@xxxxxxxxxxx
>http://webhome.idirect.com/~cbarnett/
>
>

Harley Meyer
meyer093@xxxxxxxxxx