Andy B wrote:
Hi
You need to wrap your division with an IF() so it will evalluate the result
before it puts anything in the cell. Try something like:
=IF(A20,A3/A2,0)



Or perhaps a better approximation fudge would be:

=IF(A20,A3/A2,If(A30,1e300,-1e300))

Bill