This post will show the most common types of Excel error\u00a0messages<\/strong> and how to fix them.<\/span><\/p>\n

The next post will show how to reduce or eliminate Excel user input errors<\/strong>…\u00a0Next Post<\/a><\/span><\/p>\n

Here are the most common types of Excel formula error messages and how to fix them.<\/span>
\n
\nThis happens if you try to divide by zero.<\/span>
\n Solution: Don\u2019t divide by zero (an empty cell is also treated as zero).<\/span><\/p>\n

 <\/p>\n

\nThis happens if you miss-spell an excel function or try to specify a function that does not exist.<\/span>
\n Solution: Use existing functions and spell them correctly.<\/span><\/p>\n

 <\/p>\n

\nThis happens if you try to add numbers to text.<\/span>
\n Solution: If you want to have numbers and text in the same cell use the & symbol like this;<\/span><\/p>\n

<\/p>\n

 <\/p>\n

\nThis happens if the number does not fit in the cell.<\/span>
\n Solution(s):<\/em> Either increase the column width or change the number formatting.<\/span>
\n E.G. by changing the number formatting of the cell to scientific notation the number fits in the cell like this;<\/span>
\n<\/p>\n

 <\/p>\n

\nThis happens if you refer to a cell that has been deleted.<\/span>
\n Deleting a cell means right mouse click and pressing delete,\u00a0or deleting the cell by deleting the whole, row, column or sheet.<\/span>
\n Just clearing or deleting the cell content will not produce this error.<\/span>
\n Solution: Check before deleting cells that are being used in a formula or referenced by other cells.<\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"The most common types of Excel errors are shown.\r\nThese errors are easy to fix by following some simple Excel rules.","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[54,51,52,55,53,45,50],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts\/4618"}],"collection":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/comments?post=4618"}],"version-history":[{"count":5,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts\/4618\/revisions"}],"predecessor-version":[{"id":4798,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts\/4618\/revisions\/4798"}],"wp:attachment":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/media?parent=4618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/categories?post=4618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/tags?post=4618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}