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 more appropriate approximation fudge would be:
=IF(A20,A3/A2,1E300)
Bill
|