Cell appearance

  • Thread starter Thread starter P. Zicari
  • Start date Start date
P

P. Zicari

I want the contents of cell A3 to show up in cell b51. What I have done is
in cell B51 I put the formula =A3. The problem is until I enter info into A3
Cell B51 shows a 0. I would like thsi to be an empty cell unitl the info is
entered. Any suggestions?

Thanks in advance.
 
An IF formula will work for you:
=IF(a3="","",a3)

"If cell a3 is blank, return a blank; if a3 is anything but blank,
return the value in a3."

Dave O
Eschew obfuscation
 
select the cell which is showing zero & then go to tools | options |
view tab | under the window option | uncheck the zero values option |
ok
 
Back
Top