=[cell] returns 0 if blank - help!

  • Thread starter Thread starter BigMrC
  • Start date Start date
B

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
 
You can't return nothing - all functions return something. But you
can return a null string:

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