Filling one Cell from another Cell

[GaryB]

Hi All,
I am trying to fill a cell from another cell using a basic, =D1, as a simple example. But when I do it automatically leaves a 0 in the receiving cell until I put something in the cell I am copying. The problem is I don't want the receiving cell to show anything until it it is filled. is there any code or ? I can use to do this? example: k21 is blank on the left hand invoice and the receiving cell would be V21 is on the right hand invoice on what I have attached.

Thank You for anything you can give me on this.

Gary

[大灰狼1976]

Hi GaryB!
Do you mean this?
=IF(K21="","",K21)

[GaryB]

You nailed it! Wow that is so cool. Thank you so much for taking the time to look at this problem. I can't thank you enough.
Gary

[大灰狼1976]

You're welcome