Remove zeros

danielpeam

New Member
Joined
Feb 25, 2018
Messages
8
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?
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,951
Office Version
2010
Platform
Windows
Try:
Code:
=IF('Copy updated data here'!K173 = "","",'Copy updated data here'!K173)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,508
Messages
5,487,298
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top