XL: How to Create a Formula to Correctly Evaluate Blank Cells (214244)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q214244 SUMMARY
In Microsoft Excel, when you use a formula that tests for a zero value, you may see unexpected results if the cell is blank. Microsoft Excel
interprets a blank cell as zero, and not as empty or blank. Therefore, any cells that are blank are evaluated as zero in the function.
Modification Type: | Minor | Last Reviewed: | 8/18/2005 |
---|
Keywords: | kbhowto KB214244 |
---|
|