IIf(({vCSMain.Count}=0 And {vCSMain.SoldSet}=0 And {@CurSetAdjMIN}=0),
                        50000,
                        IIf(({vCSMain.Count}=0 And {vCSMain.SoldSetAdjusted}>0 And {@CurSetAdjMIN}=0),
                                {vCSMain.Days}/{vCSMain.SoldSet},
                               IIf(({vCSMain.Count}=0 And {vCSMain.SoldSet}=0 AND 0">{@CurSetAdjMIN}>0),
                                        ({@CurSetAdjMIN}*{vCSMain.Days})* 10,
                                        IIf(({vCSMain.Count}=0 AND 0">{@CurSetAdjMIN}>0 AND {vCSMain.SoldSet}>0),
                                                ({vCSMain.Days}*{@CurSetAdjMIN})/{vCSMain.SoldSet},
                                                IIf(({@CurSetAdjMIN}<=0 And {vCSMain.SoldSet}<=0),
                                                        {vCSMain.Days}/({vCSMain.Count}*{vSalesConfidence.80PercentSales}),etc.

 

When it blows up (DIV by 0 on last line), the debug information window shows:

Count = 0

SoldSet = 16

@CurSetAdjMIN = 14

 

Why doesn't the formula end (on line in bold above) BEFORE it gets to the divide by 0, due to Count being 0?

 

PS please ignore hyperlinks and extraneous chars gratuitously supplied by the editor, ie, 0''>

 

Does anyone see something I don't see?? I've checked for control characters by pasting into Notepad and back. Always get the same error.

Thanks,

Sirlansa