Being a bit stupid here, but cannot get any formula to work.

Simply I have one worksheet looking at a cell in another and a direct copy over i.e. "=sheet1!B7"

But I want the formula to show nothing if cell "=sheet1!B7" is empy. At the moment it show's the number "0".

Cheers