Remove zeros

[danielpeam]

Hey guys,

I have a spreadsheet with a very simple formula - ='Copy updated data here'!K173

Essentially copying over the figures from another spreadsheet.

However, when the cell is blank it copies over a zero. Any idea how I can remove these automatically within the formula?

 

[JoeMo]

Try:

=IF('Copy updated data here'!K173 = "","",'Copy updated data here'!K173)