Excel puts error values in a cell to tell you that something is wrong. In Project 3 you saw ###### and #REF! There are several others that you will run into from time to time.
Error Value |
Cause |
Solution |
##### |
Column is too narrow to show the whole number |
Widen the column. |
#REF! |
Cell reference in formula is not valid because you deleted the cell or pasted something else over it. |
Rewrite the formula. |
#VALUE! |
A formula expects a number but the cell you name has only text in it. For example the formula =B3+B4 would give this error if B4 contains text. |
Rewrite your formula to refer to the correct cells or use a function that will ignore text, like = SUM(B3:B4). |
#N/A |
A value you used in a formula or as an argument for a function is "Not Available" now. You can enter this expression in a cell yourself to show that you haven't entered data yet. |
To do the calculation you will have to get the values. |
#DIV/0! |
Your formula tried to divide with a cell which is blank or has value of 0. |
Change the cell reference or enter a non-zero value in the cell to divide with. If the cell contains #N/A (for Not Available), then the formula will give #N/A as the answer, too. |
#NAME? |
You used a name for a range or a function that Excel does not understand. Perhaps you misspelled it or left out the colon in a range reference. |
Correct spelling. Include the colon in all ranges. Make sure the name or function exists. |
#NUM! |
There is a problem with a number in a formula or function. It may be too large or small for Excel to handle. It might be the wrong type for a function, like text instead of a number. |
Check for wrong type of arguments. Revise the formula or change your whole strategy if the answers will not fit in Excel. |
#NULL! |
You referred to the intersection of two data regions which do not really intersect. |
Correct your formula. Possibly use the union of two regions that do not intersect instead. |
Teachers: Request permission to use this site with your class Copyright © 1997-2012 Jan Smith <jegs1@jegsworks.com>All Rights Reserved |
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~