On Jun 17, 9:13*am, Sandeep Singh
wrote:
Hi,

How can I disable the display of "####" in a cell whenever a formula has
errors?
I am using formula's to populate the sheet2 depending on the values entered
by user in sheet1, Initially there is no data in sheet1 but as formula's are
present in sheet2, so I am getting this notification for error in formula in
sheet2.
I simply want to disbale this notification and want the cell's in sheet2
appear normal without any notification and also without getting filled with
"####"

Kindly help,

Thanks ,
Sandeep

you can embed ur formula in a if clause and use iserror on the
formula. If the formula returns an error, you can do accordingly else
u can display the value of the formula.