Excel: Automatic Cell Content Copy

Solved
LaDiablaRubia -  
 Isabellemars -
Hello, I would need your insight to know if what I'm trying to do is possible.

In an Excel document, I am making sure that the content of certain cells is automatically reported in other cells (command "=cell I want to copy", e.g.: "=B5"). However, when the cell is empty, the number 0 appears in the new cell. Can this be avoided? I would like the target cell to appear empty as well when the original cell is empty, so that the copy is truly identical.

Am I clear in my question? Am I in the right place to ask this question? If not, please let me know; I am a novice when it comes to blogs...

Thank you so much.
Configuration: Windows 2000 Internet Explorer 6.0

3 réponses

pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   2 770
 
Hello,
With the IF function: If the cell is empty then the destination cell is also empty:
=IF(B5="","",B5)

Best regards,
-- Anything worth doing is worth doing well --
12
Isabellemars
 
Thank you
0