{"id":23987,"date":"2021-06-04T16:42:38","date_gmt":"2021-06-04T14:42:38","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23987"},"modified":"2024-04-24T13:29:22","modified_gmt":"2024-04-24T11:29:22","slug":"num-error-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/num-error-in-excel\/","title":{"rendered":"How to fix the #NUM error in Excel?"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24248\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/18.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/18.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/18-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/18-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>#NUM error in Excel occurs when <strong>values in <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> are invalid<\/strong>.<\/p>\n<p>It is mostly shown in cases where there is a <strong>problem with numbers<\/strong> i.e. the <strong>data type entered is not supported <\/strong>in the argument of the formula<strong>.<\/strong><\/p>\n<p>Once you <strong>adjust the number input<\/strong>, the <strong>calculation can be performed<\/strong> and the error disappears!<\/p>\n<p>In the article, you will be shown the different reasons for #NUM error in Excel and how to fix it:<\/p>\n<ul>\n<li><a href=\"#what-is-num-error-in-excel\"><strong>What does #NUM mean in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-fix-num-error-in-excel\"><strong>How to fix #NUM error in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"what-is-num-error-in-excel\"><\/a><span style=\"color: #339966\">What does #NUM mean in Excel?<\/span><\/strong><\/h3>\n<p>It basically means that the <strong>calculation cannot be performed due to limitations<\/strong> or errors.<\/p>\n<p>This can be due to the fact that the <strong>number is too big or small<\/strong>. It also includes <strong>impossible calculations<\/strong> like calculating the square root of a negative number, or if the<strong> input for a function is invalid<\/strong>, or if an <strong>iterating <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> like IRR cannot find the result<\/strong>.<\/p>\n<p>Follow this<strong> detailed tutorial<\/strong> on #NUM Excel and <strong>download this Excel workbook<\/strong> to practice along and understand better:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Num-error.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Top-20-Common-Excel-Errors.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Num-error.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<h3><strong><a id=\"how-to-fix-num-error-in-excel\"><\/a><span style=\"color: #339966\">How to fix #NUM error in Excel?<\/span><\/strong><\/h3>\n<p>Let&#8217;s look into more detail and <strong>understand the causes and solutions<\/strong> to the #NUM! Excel.<\/p>\n<p><span style=\"color: #339966\"><strong>Example 1 &#8211; Number size<\/strong><\/span><\/p>\n<p>Excel has a <strong>limitation to the size of the number<\/strong> that it can display. If you enter a <strong>number is too large or too small<\/strong>,you will get<strong> Excel #NUM Error<\/strong>.<\/p>\n<p>As you can see, in <strong>cell C7<\/strong> we are trying to <strong>multiply 5 by itself 500 times<\/strong>. The result will be a <strong>really large number<\/strong> that Excel is unable to display. Hence. it <strong>returns NUM<\/strong> Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.18-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-23999\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.18-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"444\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.18-AM.png 444w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.18-AM-300x221.png 300w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/a><\/p>\n<p>In cell C10, we are trying to <strong>divide 1 by 10^750<\/strong>. Since this will be a <strong>very small number<\/strong> Excel cannot perform calculations and hence returns #NUM error.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.24-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24000\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.24-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"492\" height=\"334\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.24-AM.png 492w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.31.24-AM-300x204.png 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/a><\/p>\n<p>Excel is <strong>not able to show these values<\/strong> because of its inherent limitations. As shown, other smaller values are calculated and shown in C8 and C9.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.33.42-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone wp-image-24001 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.33.42-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"451\" height=\"265\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.33.42-AM.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.33.42-AM-300x176.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #339966\">Example 2 &#8211; Impossible calculations<\/span><\/strong><\/p>\n<p>Excel returns the <strong>#NUM! Error<\/strong> when it is faced with a<strong> calculation that is impossible<\/strong> to do.<\/p>\n<p>As you can see, the<strong> square root or log of the positive numbers has results<\/strong> but the <strong>square root or log of the negative numbers is impossible to calculate<\/strong>.<\/p>\n<p>In this example, we are trying to find the <strong>square root of -3<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.36.58-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24002\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.36.58-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"330\" height=\"311\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.36.58-AM.png 330w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.36.58-AM-300x283.png 300w\" sizes=\"(max-width: 330px) 100vw, 330px\" \/><\/a><\/p>\n<p>Since we are trying to calculate the square root of a negative number, we will get #NUM error in Excel. In this particular case, you can <strong>rectify this issue by taking the absolute value<\/strong> of the number.<\/p>\n<p>ABS function <strong>returns the absolute value of a number<\/strong>. It converts negative numbers to positive numbers and keeps the positive numbers unaffected.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.01-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24003\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.01-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"417\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.01-AM.png 417w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.01-AM-300x222.png 300w\" sizes=\"(max-width: 417px) 100vw, 417px\" \/><\/a><\/p>\n<p>Including the <strong>ABS function<\/strong> into the formula <strong>uses the absolute value of the number<\/strong> in column A, so now <strong>Excel can calculate the number<\/strong> and return a valid answer.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.43-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24004\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.43-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"418\" height=\"309\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.43-AM.png 418w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-05-at-2.48.43-AM-300x222.png 300w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>Example 3 &#8211; IRR function not working<\/strong><\/span><\/p>\n<p>Excel might show the #NUM! error when using IRR function because of either one of the two reasons:<\/p>\n<ul>\n<li>Cash flow <strong>does not contain at least one negative and one positive value<\/strong>.<\/li>\n<li>Formula <strong>can&#8217;t find a result<\/strong>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>In this example, <strong>Excel results a #NUM error instead of proving a value<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.32.08-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24168\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.32.08-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"425\" height=\"433\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.32.08-AM.png 425w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.32.08-AM-294x300.png 294w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/a><\/p>\n<p>This is because the <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cash-flow-to-stockholders-formula\/\" target=\"_blank\" rel=\"noopener\">cash flows<\/a> provided in the range (B7:B15) are positive<\/strong> and <strong>IRR requires at least one negative value<\/strong> as the initial cost of business.<\/p>\n<p>Initial payments are provided as <strong>negative value indicating outflow of cash<\/strong> and income payments are represented by positive values. Once you have incorporated this, the function will provide the correct result!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.34.36-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24169\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.34.36-AM.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"436\" height=\"430\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.34.36-AM.png 436w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-12-at-1.34.36-AM-300x296.png 300w\" sizes=\"(max-width: 436px) 100vw, 436px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>IRR function can also display #NUM! error when the<strong> function iterates<\/strong> and<strong> can\u2019t find a result after several tries<\/strong>.<\/p>\n<p>To overcome this, you can <strong>increase the maximum number of iterations<\/strong> that Excel performs to get a result.<\/p>\n<p>To increase the number of iterations:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong> <\/span>Go to <strong>File &gt; Options &gt; Formulas<\/strong> to arrive at the window below<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24007\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"1036\" height=\"849\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1.png 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1024x839.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-768x629.png 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong> <\/span>Under the <strong>Calculation options<\/strong> group, check the <strong>Enable iterative<\/strong> calculation box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24008\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-2.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"1036\" height=\"849\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-2.png 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-2-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-2-1024x839.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-2-768x629.png 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong> <\/span>In the <strong>Maximum Iterations box<\/strong>, <strong>type the number of times you want Excel to recalculate<\/strong>.<\/p>\n<p><em>The higher the number of iterations, the more time Excel needs to calculate a worksheet. Increasing this can help give a result to your calculation.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24010\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"1036\" height=\"849\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1.png 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1-1024x839.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-1-768x629.png 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong> <\/span>In the <strong>Maximum Change<\/strong> box,<strong> enter the amount of deviation that you are willing to accept<\/strong> between the calculation results.<\/p>\n<p><em>The smaller the number, the more accurate the result. Increasing this can help give an approximate answer to your calculations.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NUM error in Excel?\" class=\"alignnone size-full wp-image-24009\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy.png\" alt=\"How to fix the #NUM error in Excel?\" width=\"1036\" height=\"849\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy.png 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-1024x839.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image1-copy-768x629.png 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/a><\/p>\n<h3><\/h3>\n<h3><strong><a id=\"conclusion\"><\/a><span style=\"color: #339966\">Conclusion<\/span><\/strong><\/h3>\n<p>After this exercise, we hope that you now<strong> understand why you were experiencing the #NUM error<\/strong> in Excel and that you can now easily rectify and overcome this error and continue with smooth functioning in Excel!<\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>#NUM error in Excel occurs when values in formulas are invalid. It is mostly shown in cases where there is a problem with numbers i.e. the data type entered is not supported in the argument of the formula. Once you adjust the number input, the calculation can be performed and the error disappears! In the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24248,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to fix the #NUM error in Excel?","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,499],"tags":[731,732,730],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23987"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23987"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23987\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24248"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}