Referencing Blank cells in Excel

[Cordeiro82]

Hello,

When I reference a blank cell in excel the new cell shows 0. Is there a way to leave the new cell blank if the referenced cell is blank?

eg: A1 is blank; Currently if in B1 I enter =A1 it shows a 0; Is there a way to show B1 as blank if A1 is blank?

Thanks,

Cordeiro82

 

[bluedragon2]

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

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...