Microsoft Office Tutorials and References
In Depth Information
Error Messages
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
=AVERAGE(C11:C13)D23
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 .
3.
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:
a.
#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.
b.
#N/A- Appears, for example, if you’re working with a lookup table and write
something like this:
=VLOOKUP(R34,W12:X20,2,FALSE)
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.
c.
NAME ?-Appears when you mistype a function name, e.g., #
=SUMX(A4:V45)
or don’t surround textual formula entries with quotes, e.g.
=IF(C24>65,pass,”fail”)
d.
REF !-This flashes in a cell when you cite a non-existent cell reference, which #
requires a bit of explaining. If you enter
=A17+D32
and then delete row 17, you trigger the #REF! message, and the cell itself will
record
=REF!+D32
 
Search JabSto ::




Custom Search