Thread: "#DIV/0!"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ian_s_mcd ian_s_mcd is offline
external usenet poster
 
Posts: 1
Default "#DIV/0!"

I looked at the #DIV/0! theme but there were too many technical words for me
to understand. I hope someone can help me with this one.

I am trying to breakdown the percentage of four types of house (A, B, C AND
D) built on two different plots (X and Y).

There is no 'B type' house on plots X and Y. The result should be "0" but
instead it says "#DIV/0!".

This is my formula:-
=SUM(K133/B102*100)

What should I type instead? I need it to say "0".

Thanks.