Excel - Don't display zero if result is null

Latest update on by aakai1056 .

Issue

I can't figure out how to get Excel to put what's in a cell to another cell if the cell has a blank in it. For example, there are cells of data that I want to copy to other sheets in the workbook. Sometimes the cells are left blank. In this case I don't want Excel to put a "0" in the cells of the other sheets. If the cell is blank, I want a blank on the other sheets as well. Not a zero because there is no zero in the master cell.

Solution

You can use the if formula.

  • <code>=IF(A1="","", Sheet2!A1)
  • Paste this formula in Sheet2 A1 or where you need it. This will give the result of A1 if there are something in it.
  • The "","" stands for (something)</code>

Thanks to Stormdronk for this tip.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Don't display zero if result is null », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).