{"id":28228,"date":"2018-01-16T18:07:40","date_gmt":"2018-01-16T18:07:40","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=28228"},"modified":"2018-01-16T18:07:40","modified_gmt":"2018-01-16T18:07:40","slug":"excel-2016-formula-not-calculating","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/excel-2016-formula-not-calculating\/","title":{"rendered":"Excel 2016: formula not calculating"},"content":{"rendered":"<h1>Home computer use can mean self-tutoring. The tutor shares an idea about cell formatting in Excel.<\/h1>\n<p>Yesterday, using Excel 2016, I began a new spreadsheet and discovered a formula wouldn&#8217;t calculate. When I entered, for instance, =6+7, it wouldn&#8217;t evaluate to 13; the cell would simply continue to say =6+7. I&#8217;ve never encountered that behaviour.<\/p>\n<p>I looked around the internet for a solution. The cell, many suggested, might be formatted as Text, in which case it would remain what was literally entered.<\/p>\n<p>Checking its format, however, it said General.<\/p>\n<p>Perhaps I accidentally changed the format to Text. (I can&#8217;t easily imagine that happening.) Anyway, what I seem to have learned is that just changing the format, once it&#8217;s been Text, won&#8217;t cause the formula to calculate. First you need to delete the cell&#8217;s contents, then change its format to General (for instance), then re-enter the formula. Then, the formula will calculate.<\/p>\n<p>Source:<\/p>\n<p><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/msoffice_excel-mso_other-mso_2007\/excel-formula-wont-calculate\/c86857c6-0f82-4724-9d7a-dc754b4cb34a\">answers.microsoft.com<\/a><\/p>\n<p>Jack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Home computer use can mean self-tutoring. The tutor shares an idea about cell formatting in Excel. Yesterday, using Excel 2016, I began a new spreadsheet and discovered a formula wouldn&#8217;t calculate. When I entered, for instance, =6+7, it wouldn&#8217;t evaluate &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/excel-2016-formula-not-calculating\/\"> <span class=\"screen-reader-text\">Excel 2016: formula not calculating<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1583,1009],"tags":[2677],"class_list":["post-28228","post","type-post","status-publish","format-standard","hentry","category-excel","category-home-computer-use","tag-excel-formula-not-calculating-in-a-cell"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/28228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=28228"}],"version-history":[{"count":45,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/28228\/revisions"}],"predecessor-version":[{"id":28273,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/28228\/revisions\/28273"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=28228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=28228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=28228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}