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

[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.

 

[ryguy7272]

Try to format the cell as such:
_(* #,##0.00_);_(* (#,##0.00);_(* ""??_);_(@_)

 

[T. Valko]

Try this...

=IF(B1="","",B1)