Dashes in my result

C

Chuck Neal

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!
 
D

Difficult1

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

Sloth

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)
 
C

Chuck Neal

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