"Why isn't B1 empty if A1 is?" is the same as "Why does the sun rise in the
east?" That's just the way it is.

Modify your formula to:
=if(a1="","",a1)

Regards,
Fred

"TommyD" wrote in message
...
Hi,

I have a cell reference in cell B1 (=A1).

If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is?

Both cells have format General.


/Tommy