Hi Bill
Why do you say that putting 1e300 would be a 'better approximation fudge'? I
don't understand what that contributes towards the result!
Cheers.
--
Andy.
PS I can't believe I spelt evaluation with a double 'l'!!

"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
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