need to hide formula ...

[Koji]

I have a problem with a Formula that gives me a
#VALUE!
but would like this to be hidden. Earlier I had posted for
help on #DIV/0! and I the response was great it worked and
the problem was fixed.

But I realized that later this cause a problem in my cell
next to it. So 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

Previously I received a solution for colom D cell-A and it
went like:
=IF(SUM($B$5:$B$103)*B5=0,"",$A$5/SUM($B$5:$B$103)*B5)
Worked wonderfully. But colom C cell-A ended up giving me
a #VALUE! in the cell. I tried to implement the the same
formula as colom D cell-A but no luck. Please help. Thank
you.

 

[Jason Morin]

If you simply want to "hide" the error returns, change the
cells font to white, then under Format / Cells / Number /
Custom, use:

[Black]General

HTH
Jason
Atlanta, GA

 

[Charlie]

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

Charlie O'Neill