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,644
Try:
Code:
=IF('Copy updated data here'!K173 = "","",'Copy updated data here'!K173)
 

Forum statistics

Threads
1,077,784
Messages
5,336,327
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top