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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

JoeMo

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

Watch MrExcel Video

Forum statistics

Threads
1,090,169
Messages
5,412,869
Members
403,452
Latest member
mcb123

This Week's Hot Topics

Top