How do I set one cell to equal another if its contents are empty?

[Guest]

I have an insert for my work menu and everyday something changes on it. It
is a small square of information but I have duplicated it to print four on
the same page. I have assigned each cell to equal the original one so that
everytime I change the information in that cell it will automatically
duplicate it in the three other cells. My problem is that everytime I want
to clear a cell-the duplicate cells show a 0 and I want it to stay empty. If
I clear that cell the equal to function erases.

 

[MagnoliaSouth]

My problem is that everytime I want
to clear a cell-the duplicate cells show a 0 and I want it to stay empty. If
I clear that cell the equal to function erases.

Is this what you're looking for?
=IF(ISBLANK(A1),"",A1))

 

[MagnoliaSouth]

Is this what you're looking for?

=IF(ISBLANK(A1),"",A1))

To expand on that; this formula should be put in the cells which are
duplicate cells. A1 refers to the original cell where you enter the
information.

Of course again, only if this is what you are looking for.