I want to insert a formula/function that inserts data from another
spreadsheet, but that if the cells in the other spreadsheet are blank they
are left blank.

I have tried setting up a formula, but if the cell in the other spreadsheet
is blank, then the spreadsheet which has the formula shows a 0 in the cell.

Can anyone help