Microsoft Excel - Error HashDIV/0! - Asked By Colette on 26-Feb-15 11:56 AM

I have a formula that in places is correctly returning the above error as the values mean it is being asked to divide by 0.  I just want to make it display '0' in this situation.

How do I do that please?

By the way, I use this site on a regular basis and want to say a big thanks to all the experts who answer  on here - you've never failed to sort my problem out. 

It depends on your formula a bit but you could try something like

= IF(divisor <> 0, formula, 0)

If that doesn't work then we would need to know more detail of what is causing the problem.