Disbaling Error in formula notification

[Sandeep Singh]

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

 

[Nayab]

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.

 

[Bob Phillips]

You really should correct the error, but you can do

=IF(ISERROR(formula),"",formula)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Torres]

You can use ISERROR() function together with maybe the IF() function.

 

[Gord Dibben]

What type of error gives you ##### in a cell?

Only one I can think of is a negative date or time

Maybe =IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

 

[Spiky]

What type of error gives you ##### in a cell?

Only one I can think of is a negative date or time

Maybe =IF(Sheet1!A1="","",Sheet1!A1)

Gord Dibben MS Excel MVP

Along with Gord's comment....
The most common error that fills a cell with ###### is that the number
doesn't fit in your current view. Are you sure this is the error you
have? Because the IF/ISERROR suggestions won't fix this since it is
not a formula error.

To fix this you need to adjust your zoom or column width.