Disbaling Error in formula notification
 

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

Disbaling Error in formula notification
 

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.

Disbaling Error in formula notification
 

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)



"Sandeep Singh" wrote in message
...
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 use ISERROR() function together with maybe the IF() function.

Disbaling Error in formula notification
 

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

On Mon, 16 Jun 2008 21:13:00 -0700, 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

Disbaling Error in formula notification
 

On Jun 17, 9:31 am, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Mon, 16 Jun 2008 21:13:00 -0700, 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

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.