Developer

Murray Brown

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have an Excel sheet with simple formulas that point to another sheet eg cell A2 simply has the formula =Entry!B2<br />
My problem, as per the following image, is that zeros are showing up for blanks on the source sheet. How do I adjust<br />
my formula to show blanks? Thanks<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/10_w41/1433914/Image1.jpg" target="_blank" title="1 (7 KB)"><img alt="1" class="file-block lazyload" style="max-width: 176px;" data-src="https://filedb.experts-exchange.com/incoming/2019/10_w41/1433914/Image1.jpg" /></a>
</div>
</div>


Image1.jpg

Hi

I have an Excel sheet with simple formulas that point to another sheet eg cell A2 simply has the formula =Entry!B2
My problem, as per the following image, is that zeros are showing up for blanks on the source sheet. How do I adjust
my formula to show blanks? Thanks



Excel Show blanks instead of Zeros as result of formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.