Don't display zero if result is null.
Solved/Closed
Related:
- Don't display zero if result is null.
- Which of the following may be the cause if you are getting the problem of no display ✓ - Hardware Forum
- Monitor power light blinking but no display reasons ✓ - Hardware Forum
- Huawei display check code - Guide
- Pc fan running fast but no display ✓ - Motherboard Forum
- You disagreed with the decision check back here for the result. - Facebook Forum
Aug 2, 2011 at 06:46 AM
This works perfectly!! Thanks so much for providing valuable insight!!
I had tried to use the formula =Sheet1!A1 (on sheet 2) in a master document. It starts out with a blanks on the subsequent sheets until data is entered into the cell on the first sheet. It would display the desired information but if the data is deleted from the first sheet, there would be zeros in all subsequent sheets. I couldn't figure out how it started with blanks in the first place because I couldn't duplicate that function in any of my attempts. I think it might be a bug in MS Excel 2007 because I think my master document came from an earlier version.
Aug 2, 2011 at 12:36 PM