Hide #VALUE!

[sufianmalik]

Hello, i would like to hide these error messages when they appear. EG user types in text in a cell which results in the numerical formula returning the #VALUE!

Could you please tell me what I can add to my formula to hide this?

 

[Rick Rothstein]

Right now you have this...

=YourFormula

change it to this...

=IFERROR(YourFormula,"")

 

[Muhammad_Usman]

Just Add =IfError,(your Formulla),"")

 

[sufianmalik]

Thanks!