Coping cells from one sheet to another returns "0", need it to return nothing

[Booms]

Hi, I'm copying some cells from one sheet 1 to sheet 2 in the same workbook, using

Please Login or Register  to view this content.

The only thing is when the cell is empty on sheet 1, on sheet 2 it gives a 0, i would like to be an empty cell, or have something wriiten there.

Any help is much appreciated

Thanks in advance

[zbor]

Try:

=IF(Sheet1!B21="", "", Sheet1!B21)

[Booms]

Hey Zbor,
That seemed to work great.

Thank You