Dashes in my result
 

I have the following formula in cell D1.

=IF(A1=C1,B1," ")

It is possible that cells A1 and C1 could be blank. When that happens, the
formula returns a "-" in D1. Normally I would use the Autofilter and delete
these, however, I am using a macro and using the Autofilter slows it down to
a crawl. Is there a way (formula or otherwise), to eliminate the - in my
cell?
Thanks!

Dashes in my result
 

If those cells are blank, the "-" is a "0"... check to see if you have it set
to show zero values....

"Chuck Neal" wrote:

I have the following formula in cell D1.

=IF(A1=C1,B1," ")

It is possible that cells A1 and C1 could be blank. When that happens, the
formula returns a "-" in D1. Normally I would use the Autofilter and delete
these, however, I am using a macro and using the Autofilter slows it down to
a crawl. Is there a way (formula or otherwise), to eliminate the - in my
cell?
Thanks!

Dashes in my result
 

It sounds like B1 is blank, and you have the format set to show 0 as -. You
can either change the format or change the formula to check for the blank B1
(so it doesn't try and output 0).

General;-General;
or
=IF((C1<A1)+ISBLANK(B1)," ",B1)

"Chuck Neal" wrote:

I have the following formula in cell D1.

=IF(A1=C1,B1," ")

It is possible that cells A1 and C1 could be blank. When that happens, the
formula returns a "-" in D1. Normally I would use the Autofilter and delete
these, however, I am using a macro and using the Autofilter slows it down to
a crawl. Is there a way (formula or otherwise), to eliminate the - in my
cell?
Thanks!

Dashes in my result
 

Thanks Sloth. The Formula worked. I've been working on this for two
days...so I REALLY appreciate the help.
Chuck

"Sloth" wrote:

It sounds like B1 is blank, and you have the format set to show 0 as -. You
can either change the format or change the formula to check for the blank B1
(so it doesn't try and output 0).

General;-General;
or
=IF((C1<A1)+ISBLANK(B1)," ",B1)

"Chuck Neal" wrote:

I have the following formula in cell D1.

=IF(A1=C1,B1," ")

It is possible that cells A1 and C1 could be blank. When that happens, the
formula returns a "-" in D1. Normally I would use the Autofilter and delete
these, however, I am using a macro and using the Autofilter slows it down to
a crawl. Is there a way (formula or otherwise), to eliminate the - in my
cell?
Thanks!