Excel - Don't display zero if result is null

January 2017

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.

Related


Published by aakai1056. Latest update on August 2, 2011 at 09:30 AM by aakai1056.
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).