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

Mar 4th, 2002, 07:00 AM

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 · Mar 4th, 2002, 07:03 AM

Put in cell B12-

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

Mar 4th, 2002, 07:05 AM

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

hope this helps

Mar 4th, 2002, 07:06 AM

heh heh 2 secs too late

Mudface · Mar 4th, 2002, 07:17 AM

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.

Mar 4th, 2002, 07:31 AM

Great!

GREAT!

GREAT!

Thnks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 07:00 AM	#1
Guest Posts: n/a	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?

Mar 4th, 2002, 07:03 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Put in cell B12- =IF(A12="","",A12)

Mar 4th, 2002, 07:05 AM	#3
Guest Posts: n/a	change your =a12 to =IF(A12>0,A12,"") hope this helps

Mar 4th, 2002, 07:06 AM	#4
Guest Posts: n/a	heh heh 2 secs too late

Mar 4th, 2002, 07:17 AM	#5
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.

Mar 4th, 2002, 07:31 AM	#6
Guest Posts: n/a	Great! GREAT! GREAT! Thnks!