when setting a cell to equal a blank cell it displays 0

  • Thread starter Thread starter BWildeRed
  • Start date Start date
B

BWildeRed

If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it
possible to have a blank result in A1? I am trying to create a template where
I have some cells equate to others and I would like the cells to show blank
if there is no data in the target cells.
 
Back
Top