"#DIV/0!"

[Guest]

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.

 

[Peo Sjoblom]

=IF(B102=0,0,(K133/B102)*100)

 

[Guest]

Try something like this:

=IF(N(B102)<>0,K133/B102*100,0)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Don Guillett]

Try this idea
=if(TRIM(b102)="",0,k133/b102)

 

[Guest]

type 0.0001 and the error sign should disappear.