"#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.

"#DIV/0!"
 

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

--
Regards,

Peo Sjoblom


"ian_s_mcd" wrote in message
...
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.

"#DIV/0!"
 

Try something like this:

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

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

XL2002, WinXP


"ian_s_mcd" wrote:

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.

"#DIV/0!"
 

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

--
Don Guillett
SalesAid Software

"ian_s_mcd" wrote in message
...
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.

"#DIV/0!"
 

type 0.0001 and the error sign should disappear.

"ian_s_mcd" wrote:

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.