Microsoft Office Tutorials and References
In Depth Information
And you won’t be able to proceed without remedying the problem. Or if you want to divide the averages
of cells C11:C13 by the value in D23 and write
You’ll spark this advisory (Figure C–2):
Figure C–2. Just trying to help
Note that Excel’s recommendation isn’t what you had in mind, but you’ll need to rewrite the expression
in any case .
Formula-acceptable errors : What I’m referring to here is a collection of
formula-writing errors which Excel will allow you to enter in the cell, but will
then record as an error in that cell. There are several classic such errors:
#DIV/0!- Try to enter say, =A12/0 in a cell and you’ll be allowed to do just that,
but this error will be posted in the cell. You can’t divide a number or a
cellreferenced value by zero.
#N/A- Appears, for example, if you’re working with a lookup table and write
something like this:
And the value in R34 simply doesn’t appear in the first lookup column – and by
adding FALSE you’d specified an exact match.. That value is Not Available.
NAME ?-Appears when you mistype a function name, e.g., #
or don’t surround textual formula entries with quotes, e.g.
REF !-This flashes in a cell when you cite a non-existent cell reference, which #
requires a bit of explaining. If you enter
and then delete row 17, you trigger the #REF! message, and the cell itself will