Formula isn't working when one of the cells has a zero value

[langham]

Hi All,

I have an excel forumla as follows:

=(B24/((B30*12)/100000))+(B26/((B32*12)/100000))

Sometimes the entires in either B24&B30 or B26&B32 will be zero and when that happens the forumla returns a result of #DIV/0!.

How can I make it so when either part is 0 it ignores that part and just works out the other part?

Many thanks