#DIV/0!

K

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.
 
G

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.
 
K

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.
 
Top