Hi Jerry,

Using Excel 2003.

This is really weird. If I copy the formula to C3 and C4, I have your
identical formula in four cells.

With 1 in G1 and I1, 100 in I5, and all other cells blank (except
c1:c4, of course)...

If G2 is blank or 0, I get:
C1: 0
C2: 100
C3: 100
C4: 100

If G2 is 1, I get:
C1: 100
C2: 100
C3: 0
C4: 0

If G2 is 2 or text, I get:
C1: 0
C2: 100
C3: 0
C4: 0

Ugh!!!

Regards,
Jay Petrulis