Removing the #div/0! from my sheet

[zepan]

Hi Guys and Girls,

I have big sheet with some simple formulas working out the cost price for each unit =SUM(H5)/F5. In some cases the answer is 0 and understand you can't divide 0 by 0 and this is why the remark #DIV/0! comes in the cell. How can I clear this to give me a 0 and not the #div/0! Error.

Thanks in advance,

Matt

 

[GDCelect]

WOW, thanks. I really appreciate your help.

 

[NdNoviceHlp]

You are Welcome. Thank you for posting your outcome. Dave

 

[RJBatt]

Hi Guys,

How do I remove the #div/0! from this =ABS(H$3-H4)/H$3.
I am trying to calculate MAPE and this error is preventing me from getting a result.

Thanks

 

[zizou05]

Hi, can anyone help me eliminate #div/0. i want "0" to appear instead. this is the formula:

=IF(E11/D11>100%,100%,E11/D11)

 

[konew1]

=if(d11=0,0,IF(E11/D11>100%,100%,E11/D11) )

 

[RJBatt]

I have this formula =IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review")

I need to remove the #div/0! from it, how my friends? Iserror is not working.

 

[NdNoviceHlp]

HTH. Dave

=IF(AG97=0,0,IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review"))

or...

=IF(ISERROR(IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review")),0,IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review"))

 

[RJBatt]

This worked great, thank you Sir!

HTH. Dave

=IF(AG97=0,0,IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review"))

or...

=IF(ISERROR(IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review")),0,IF((AI97-AG97)/AG97<100%,(AI97-AG97)/AG97,"Manual Review"))

 

[Dass Edwin]

anyone can help me solve this .... E6 and E7 support to be -100% but its show 0 becourse from IF(ISERROR) formula.thank.

 

[Dass Edwin]

Help anyone to solve my problem, thank in advance.