I would guess that it depends on whether or not you want a 0 displayed, if
the source cell is empty.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Biff" wrote in message
...
Hi!

If you enter data in cell A1 and you want that data to
also appear in cell D10. In cell D10 enter this formula:

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

Biff

-----Original Message-----
In Excel -
How do you get information typed in one cell to appear in
another
pre-choosen cell location.
.