Formula with both cell references and literal values: =a1/100
Errors in Formulas
Common Errors
The following are some errors that may appear in a spreadsheet (there are others too).
#######
Cell is too narrow to display the results of the formula. To fix this simply make the column wider and the “real” value will be displayed instead of the ###### signs. Note that even when the ###### signs are being displayed, Excel still uses the “real” value to calculate formulas that reference this cell.
#NAME?
You used a cell reference in the formula that is not formed correctly (e.g. =BB+10 instead of =B3+10)
#VALUE!
Usually the result of trying to do math with a textual value. Example: =A1*3 where A1 contains the word “hello”
#DIV/0!
Trying to divide by zero. Example: =3/A1 where A1 contains 0 (zero)
Circular Reference
Using a formula that contains a reference to the cell that the formula “lives in”. Example: putting the formula =A1+1 in cell A1 or putting the formula =SUM(A1:B2) in any of the cells A1, B1, A2, B2