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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

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,089,886
Messages
5,410,990
Members
403,336
Latest member
amreeves87

This Week's Hot Topics

Top