#DIV/0!

[Koji]

I have this error that shows up and it isn't something I
want visible when I work with my file, and I want to know
if there is a way to make it invisible?

original formula:
=$A$5/SUM($B$5:$B$103)*B5

I have already made the cell hidden/locked of course and
even hid the zero's under TOOL/OPTION and nothing.

Before I had some help on another file with similar
problems and got help so I took the formula and tried to
implement it to this one and this is how it went with no
luck.

=IF(ISERROR(ROUND($A$5/SUM($B$5:$B$103)*B5)),"",ROUND
($A$5/SUM($B$5:$B$103)*B5))

Please help,
thank you very much.

 

[Frank Kabel]

Hi
one way:
=IF(SUM($B$5:$B$103)*B5=0,"",$A$5/SUM($B$5:$B$103)*B5)

 

[mzehr]

Hi,

Try
=IF(SUM($B$5:$B$103)=0,"",$A$5/SUM($B$5:$B$103)*B5)

HTH

 

[Guest]

Thanks Frank. Sorry but I have another question ... and
its actually related to this one.

this is how the whole thing is actually,

on colom C cell-A I have this formula:
=ROUND(D5*20,0)/20

on colom D cell-A I have this formula:
=$A$5/SUM($B$5:$B$103)*B5

After you gave me your solution it made the entire formula
completly invisible but then made colom C CELL-A turn to
#VALUE!. I assume I have to do something similar to hid
this as well but failed attempting. If you could please
help I would apprecitate it very much. Thank you.

 

[Frank Kabel]

Hi
change
=ROUND(D5*20,0)/20

to
=IF(ISNUMBER(D5),ROUND(D5*20,0)/20,"")

 

[Koji]

Once again I can't thank you enough. Your solution worked.
I will try more to better learn Excel, so i can solve
these simple problems in the future better on my own.
Thank you again.