Controlling which Error Messages Appear
We all make mistakes, but some of those mistakes are easier to recover from than others. If you create a formula that tries to have Excel divide a value by zero or use a value from a cell that’s currently blank, Excel will display an error flag indicating that it thinks you’ve made a mistake. If the error is that no value is in a cell you refer to in a formula, you can fix the problem by putting a value in that cell.
At times, though, Excel will identify a formula as an error when, in fact, it’s exactly what you intended. For example, if you create a worksheet that contains five columns of data, and you find the sum of each of those columns, Excel identifies the pattern inherent in those formulas. If you ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
