Copy of empty cell gives a value of 0: I want an empty cell!

[Guest]

Hi,

I`m building a macro which scans certain cell wheter they have info in it or not. These cells are replica`s of other cells in cell B12 I have "=A12"
However if the base cell is empty (a12), the copied cell (b12) gives a value of 0. The macro consequently scans it and determines is is "notempty"

I cannot seem to set the 0 to empty. (cell formats etc)Can anybody help me?

 

[Mudface]

Put in cell B12-

=IF(A12="","",A12)

 

[Guest]

change your =a12 to =IF(A12>0,A12,"")

hope this helps

 

[Guest]

heh heh 2 secs too late

 

[Mudface]

Hehe. .

Beware using the IF(A12>0,...) one though,if you have negative values in a cell (admittedly, this won't be often) they won't then show up.

 

[Guest]

Great!

GREAT!

GREAT!



Thnks!