A few words of thanks would be greatly appreciated.

Excel - Don't display zero if result is null

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

Excel - Don't display zero if result is null
Don't display zero if result is null. ✓ - Forum - Office Software
Excel - Hide rows with zero value in Multiple sheets - How-To - Excel
Excel - How to display formulas in spreadsheet? - How-To - Excel
Excel 2010/VB- Loop until no result is found - How-To - Download software
Excel Formula to show Zero ✓ - Forum - Excel

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).

Excel - Entering fractions

French/English Translations For Excel Functions

Issue

Solution

Subscribe To Our Newsletter!