If you see one or more pound signs in a cell or column, the cell or column is too narrow. Solution – widen the column.
#DIV/O! You are dividing by an empty cell or zero. Solution - fix the formula’s denominator.
#REF! Your formula refers to a cell that no longer exists, due to a change in the worksheet.
#NAME? Your formula contains text that Excel doesn’t recognize. Could have many causes, usually a typo or missing punctuation in a formula.
Solution to #REF and #NAME – click the cell that displays the error, click the button that appears, and then click Trace Error if it appears.
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-12-15 02:07:38. Republished by Blog Post Promoter