"Pete_UK" wrote in message
ups.com...
Change your formula in F39 to this:

=IF(ISERROR(your_formula),0,your_formula)

Hope this helps.

Pete


Pete, I modified your formula slightly
=IF(ISERROR(F39*G40),"",(F39*G40))
and got the effect that I wanted. Thanks for your help.