Don't display zero if result is null.
Solved/Closed
Related:
- Don't display zero if result is null.
- Huawei display check code - Guide
- Computer turns on but no display - Guide
- Ms excel result sheet - Guide
- To display a text file in reverse order what command should be used - Guide
- Cpu fan spinning slow no display - CPU & Desktop 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