one way
=if(iserror(yourformula),"",yourformula)

"Sasikiran" wrote:

Hi,

I have a formula in a particular cell which calculates the quality % based
on the numbers entered in another cells. I had included the formula in the
required cell and it is appearing as "#DIV/0!" as error as I have not entered
the data in the reference cells pertaining to the formula.

Is there any way to hide the error symbol in that cell without deleting the
formula?

Thanks in advance.