Jerry,

Here's the statement I used:
IIF(Denominator = 0, Alternamtive, Numerator/Denominator)

I'm confused - doesn't the above statement check for a zero denominator before the division, and not allow it to take place if the denominator is zero?


>Cindy used the Immediate IF function. Another way is to check BEFORE the
>division using an IF statement.