=[cell] returns 0 if blank - help!

[BigMrC]

When you do =[cell] and the cell being referred to has nothing in it th
=[cell] returns a 0.
I need this to return exactly what's in the cell being referred to - i
nothing if there's nothing in it.
I've tried formatting the referred cell and the =[cell] cell to genera
and text but it still returns a 0.
Anyone help

 

[J.E. McGimpsey]

You can't return nothing - all functions return something. But you
can return a null string:

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

 

[Alan]

Try
IF(A1<>0,A1,"")

 

[BigMrC]

perfect, thanks