View original (French)

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 answers

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 772
     
    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
    1. Isabellemars
       
      Thank you
      0