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?
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,691
Try:
Code:
=IF('Copy updated data here'!K173 = "","",'Copy updated data here'!K173)
 

Forum statistics

Threads
1,085,467
Messages
5,383,869
Members
401,859
Latest member
tomahawk61

Some videos you may like

This Week's Hot Topics

Top