"Chip Pearson" wrote in
:

I don't know why you can still see the formula. If you protect
the sheet, cells with "hidden" formulas will not display the
formula. It works fine for me.

There is no way through formatting to hide error values. Instead,
you should write your formula in such as way that the error will
not occur in the first place. E.g.,

=IF(C4=0,"",C13/C4)


The method I use when SUMming two cells when one or both might not have a
value entered into it yet is:

=IF(C13="","",C13/C4) or
=IF(C4="","",C13/C4)

only because a zero in a cell might be the basis for a logical test in
another formula I have somewhere in the sheet