A divide-by-zero error will occur whenever there is a denominator in the formula that could end up having a value of zero (even if there is no chance it will ever happen), such as this sample
formula: Close/(High-Low)
In this formula, if High-Low equates to zero (because the High and Low are equal), then a divide-by-zero error occurs.
To avoid divide-by-zero errors, the division that is giving the problem has to be identified and then rewritten to trap the zero, for instance, using the same sample formula above, we could do this:
Z:=If(H-L=0,.00001,H-L);
Close/(z);
Thus, when the zero would normally occur we substitute a value very near zero, .00001, to avoid the error. This does introduce a minimal, probably non-significant, error into the calculation, but it is often worth it.
My Site