选择擅长的领域继续答题？
{@each tagList as item}
${item.tagName}
{@/each}
手机回答更方便，互动更有趣，下载APP
提交成功是否继续回答问题？
手机回答更方便，互动更有趣，下载APP
展开全部#DIV/0! \x0d\x0a \x0d\x0a错误原因：在公式中有除数为零，或者有除数为空白的单元格(Excel把空白单元格也当作0)。 \x0d\x0a \x0d\x0a解决办法：把除数改为非零的数值，或者用IF函数进行控制。\x0d\x0a\x0d\x0a#N/A \x0d\x0a \x0d\x0a错误原因：在公式使用查找功能的函数(VLOOKUP、HLOOKUP、LOOKUP等)时，找不到匹配的值。 \x0d\x0a \x0d\x0a解决办法：检查被查找的值，使之的确存在于查找的数据表中的第一列。 \x0d\x0a\x0d\x0a#NAME?\x0d\x0a \x0d\x0a错误原因：在公式中使用了Excel无法识别的文本，例如函数的名称拼写错误，使用了没有被定义的区域或单元格名称，引用文本时没有加引号等。 \x0d\x0a \x0d\x0a解决办法：根据具体的公式，逐步分析出现该错误的可能，并加以改正。 \x0d\x0a\x0d\x0a#NUM!\x0d\x0a \x0d\x0a错误原因：当公式需要数字型参数时，我们却给了它一个非数字型参数；给了公式一个无效的参数；公式返回的值太大或者太小。 \x0d\x0a \x0d\x0a解决办法：根据公式的具体情况，逐一分析可能的原因并修正。\x0d\x0a\x0d\x0a#VALUE\x0d\x0a \x0d\x0a错误原因：文本类型的数据参与了数值运算，函数参数的数值类型不正确；\x0d\x0a\x0d\x0a解决办法：函数的参数本应该是单一值，却提供了一个区域作为参数；\x0d\x0a\x0d\x0a
输入一个数组公式时，忘记按Ctrl＋Shift＋Enter键。 \x0d\x0a \x0d\x0a
更正相关的数据类型或参数类型；\x0d\x0a\x0d\x0a
提供正确的参数；\x0d\x0a\x0d\x0a
输入数组公式时，记得使用Ctrl＋Shift＋Enter键确定。 \x0d\x0a\x0d\x0a#REF!\x0d\x0a \x0d\x0a错误原因：公式中使用了无效的单元格引用。通常如下这些操作会导致公式引用无效的单元格：删除了被公式引用的单元格；把公式复制到含有引用自身的单元格中。 \x0d\x0a \x0d\x0a解决办法：避免导致引用无效的操作，如果已经出现错误，先撤销，然后用正确的方法操作。 \x0d\x0a\x0d\x0a#NULL!\x0d\x0a \x0d\x0a错误原因：使用了不正确的区域运算符或引用的单元格区域的交集为空。 \x0d\x0a \x0d\x0a
改正区域运算符使之正确；更改引用使之相交。',getTip:function(t,e){return t.renderTip(e.getAttribute(t.triangularSign),e.getAttribute("jubao"))},getILeft:function(t,e){return t.left+e.offsetWidth/2-e.tip.offsetWidth/2},getSHtml:function(t,e,i){return t.tpl.replace(/\{\{#href\}\}/g,e).replace(/\{\{#jubao\}\}/g,i)}},baobiao:{triangularSign:"data-baobiao",tpl:'{{#baobiao_text}}',getTip:function(t,e){return t.renderTip(e.getAttribute(t.triangularSign))},getILeft:function(t,e){return t.left-21},getSHtml:function(t,e,i){return t.tpl.replace(/\{\{#baobiao_text\}\}/g,e)}}};function s(t){return this.type=t.type
"defaultTip",this.objTip=a[this.type],this.containerId="c-tips-container",this.advertContainerClass=t.adSelector,this.triangularSign=this.objTip.triangularSign,this.delaySeconds=200,this.adventContainer="",this.triangulars=[],this.motherContainer=r.createDom("div"),this.oTipContainer=r.getDom(this.containerId),this.tip="",this.tpl=this.objTip.tpl,this.init()}s.prototype={constructor:s,arrInit:function(){for(var t=0;t0}});return}var t=window.document,e=[];o.prototype.THROTTLE_TIMEOUT=100,o.prototype.POLL_INTERVAL=null,o.prototype.USE_MUTATION_OBSERVER=!0,o.prototype.observe=function(t){if(!this._observationTargets.some(function(e){return e.element==t})){if(!(t&&1==t.nodeType))throw Error("target must be an Element");this._registerInstance(),this._observationTargets.push({element:t,entry:null}),this._monitorIntersections(),this._checkForIntersections();}},o.prototype.unobserve=function(t){this._observationTargets=this._observationTargets.filter(function(e){return e.element!=t}),this._observationTargets.length
(this._unmonitorIntersections(),this._unregisterInstance());},o.prototype.disconnect=function(){this._observationTargets=[],this._unmonitorIntersections(),this._unregisterInstance();},o.prototype.takeRecords=function(){var t=this._queuedEntries.slice();return this._queuedEntries=[],t},o.prototype._initThresholds=function(t){var e=t
[0];return Array.isArray(e)
(e=[e]),e.sort().filter(function(t,e,n){if("number"!=typeof t
isNaN(t)
t1)throw Error("threshold must be a number between 0 and 1 inclusively");return t!==n[e-1]})},o.prototype._parseRootMargin=function(t){var e=(t
"0px").split(/\s+/).map(function(t){var e=/^(-?\d*\.?\d+)(px|%)$/.exec(t);if(!e)throw Error("rootMargin must be specified in pixels or percent");return {value:parseFloat(e[1]),unit:e[2]}});return e[1]=e[1]
e[0],e[2]=e[2]
e[0],e[3]=e[3]
e[1],e},o.prototype._monitorIntersections=function(){!this._monitoringIntersections&&(this._monitoringIntersections=!0,this.POLL_INTERVAL?this._monitoringInterval=setInterval(this._checkForIntersections,this.POLL_INTERVAL):(i(window,"resize",this._checkForIntersections,!0),i(t,"scroll",this._checkForIntersections,!0),this.USE_MUTATION_OBSERVER&&"MutationObserver"in window&&(this._domObserver=new MutationObserver(this._checkForIntersections),this._domObserver.observe(t,{attributes:!0,childList:!0,characterData:!0,subtree:!0}))));},o.prototype._unmonitorIntersections=function(){this._monitoringIntersections&&(this._monitoringIntersections=!1,clearInterval(this._monitoringInterval),this._monitoringInterval=null,r(window,"resize",this._checkForIntersections,!0),r(t,"scroll",this._checkForIntersections,!0),this._domObserver&&(this._domObserver.disconnect(),this._domObserver=null));},o.prototype._checkForIntersections=function(){var t=this._rootIsInDom(),e=t?this._getRootRect():h();this._observationTargets.forEach(function(o){var i=o.element,r=s(i),h=this._rootContainsTarget(i),c=o.entry,a=t&&h&&this._computeTargetAndRootIntersection(i,e),u=o.entry=new n({time:window.performance&&performance.now&&performance.now(),target:i,boundingClientRect:r,rootBounds:e,intersectionRect:a});c?t&&h?this._hasCrossedThreshold(c,u)&&this._queuedEntries.push(u):c&&c.isIntersecting&&this._queuedEntries.push(u):this._queuedEntries.push(u);},this),this._queuedEntries.length&&this._callback(this.takeRecords(),this);},o.prototype._computeTargetAndRootIntersection=function(e,n){if("none"!=window.getComputedStyle(e).display){for(var o=s(e),i=a(e),r=!1;!r;){var h=null,c=1==i.nodeType?window.getComputedStyle(i):{};if("none"==c.display)return;if(i==this.root
i==t?(r=!0,h=n):i!=t.body&&i!=t.documentElement&&"visible"!=c.overflow&&(h=s(i)),h&&!(o=function(t,e){var n=Math.max(t.top,e.top),o=Math.min(t.bottom,e.bottom),i=Math.max(t.left,e.left),r=Math.min(t.right,e.right),s=r-i,h=o-n;return s>=0&&h>=0&&{top:n,bottom:o,left:i,right:r,width:s,height:h}}(h,o)))break;i=a(i);}return o}},o.prototype._getRootRect=function(){var e;if(this.root)e=s(this.root);else {var n=t.documentElement,o=t.body;e={top:0,left:0,right:n.clientWidth
o.clientWidth,width:n.clientWidth
o.clientWidth,bottom:n.clientHeight
o.clientHeight,height:n.clientHeight
o.clientHeight};}return this._expandRectByRootMargin(e)},o.prototype._expandRectByRootMargin=function(t){var e=this._rootMarginValues.map(function(e,n){return "px"==e.unit?e.value:e.value*(n%2?t.width:t.height)/100}),n={top:t.top-e[0],right:t.right+e[1],bottom:t.bottom+e[2],left:t.left-e[3]};return n.width=n.right-n.left,n.height=n.bottom-n.top,n},o.prototype._hasCrossedThreshold=function(t,e){var n=t&&t.isIntersecting?t.intersectionRatio
0:-1,o=e.isIntersecting?e.intersectionRatio
0:-1;if(n!==o)for(var i=0;ie.indexOf(this)&&e.push(this);},o.prototype._unregisterInstance=function(){var t=e.indexOf(this);-1!=t&&e.splice(t,1);},window.IntersectionObserver=o,window.IntersectionObserverEntry=n;}function n(t){this.time=t.time,this.target=t.target,this.rootBounds=t.rootBounds,this.boundingClientRect=t.boundingClientRect,this.intersectionRect=t.intersectionRect
h(),this.isIntersecting=!!t.intersectionRect;var e=this.boundingClientRect,n=e.width*e.height,o=this.intersectionRect,i=o.width*o.height;n?this.intersectionRatio=Number((i/n).toFixed(4)):this.intersectionRatio=this.isIntersecting?1:0;}function o(t,e){var n,o,i,r=e
{};if("function"!=typeof t)throw Error("callback must be a function");if(r.root&&1!=r.root.nodeType)throw Error("root must be an Element");this._checkForIntersections=(n=this._checkForIntersections.bind(this),o=this.THROTTLE_TIMEOUT,i=null,function(){i
(i=setTimeout(function(){n(),i=null;},o));}),this._callback=t,this._observationTargets=[],this._queuedEntries=[],this._rootMarginValues=this._parseRootMargin(r.rootMargin),this.thresholds=this._initThresholds(r.threshold),this.root=r.root
null,this.rootMargin=this._rootMarginValues.map(function(t){return t.value+t.unit}).join(" ");}function i(t,e,n,o){"function"==typeof t.addEventListener?t.addEventListener(e,n,o
!1):"function"==typeof t.attachEvent&&t.attachEvent("on"+e,n);}function r(t,e,n,o){"function"==typeof t.removeEventListener?t.removeEventListener(e,n,o
!1):"function"==typeof t.detatchEvent&&t.detatchEvent("on"+e,n);}function s(t){var e;try{e=t.getBoundingClientRect();}catch(t){}return e?(e.width&&e.height
(e={top:e.top,right:e.right,bottom:e.bottom,left:e.left,width:e.right-e.left,height:e.bottom-e.top}),e):h()}function h(){return {top:0,bottom:0,left:0,right:0,width:0,height:0}}function c(t,e){for(var n=e;n;){if(n==t)return !0;n=a(n);}return !1}function a(t){var e=t.parentNode;return e&&11==e.nodeType&&e.host?e.host:e&&e.assignedSlot?e.assignedSlot.parentNode:e}}();
var r="observer";function t(){}function n(r){var t=r.container,n=r.url,o=r.params;this.opts={container:t,url:n,params:void 0===o?{}:o},this.init();}n.prototype={constructor:n,init:function(){var r=this,t=r.opts.container;r.observer=new IntersectionObserver(r.observeCB.bind(r)),t&&Array.prototype.slice.call(document.querySelectorAll(t)).forEach(function(t){r.observer.observe(t);});},observeCB:function(t){var n=this;t.forEach(function(t){if(t.isIntersecting){var o=t.target;if(!o.getAttribute(r)){var e=n.combineData(o);n.log(e),n.observer.unobserve(o),o.setAttribute(r,1);}}});},combineData:function(r){var t=this.opts.params,n={data:{}};for(var o in t)if(t.hasOwnProperty(o)){var e=r.getAttribute(t[o]);""!==e&&(n.data[o]=e);}return n},log:function(r){this.nclick(r);},nclick:function(r){var t=this.opts.url;r.rand=this.addRand();var n="".concat(t,"?").concat(this.encodeSearchParams(r));this.imgRequest(n,r);},imgRequest:function(r,n){try{var o=n.rand,e=new Image;window["--IMAGE"+o]=e,e.onload=e.onerror=e.onabort=function(){e.onload=e.onerror=e.onabort=null,e=null,window["--IMAGE"+o]=t;},e.src=r;}catch(r){}},addRand:function(){return Math.random().toString(16).slice(2,8)+Math.random()},encodeSearchParams:function(r){var t=[];for(var n in r)if(r.hasOwnProperty(n)){var o=r[n];"object"==typeof o&&(o=JSON.stringify(o)),t.push([n,encodeURIComponent(o)].join("="));}return t.join("&")}};
var m = {init:function(){new n({container:"[data-nvk]",url:"https://ada.baidu.com/udpl/exp",params:{exp:"data-nvk"}});}};
exports.PARAMS={};var f=function(o){exports.PARAMS=o;var f="."+exports.PARAMS.resultClass;n$1(function(){i$1.init(f,exports.PARAMS.imTimeSign),m.init();},!0),n$1(function(){r$1.init(),e(window,document),window.domReady(function(){new window.TipOffComponent({adSelector:f});});}),exports.PARAMS.sourceAdNum&&exports.PARAMS.sourceAdNum.ads_2246>0&&t$3(exports.PARAMS.resultClass,!0);};
exports.init = f;
exports.request = e$5;
return exports;
})({});
(function (variable) {
window.ecomNsPcTipGlobal.init(variable);
})({"searchid":"0bc6d5f8b4de87f8","eid":"238_11114_7869012_300003","bwsid":0,"osid":0,"pageid":"zhidao_content_page_new","baiduid":"8613BC8757742A957C679404E03DF4B5","ovlid":"114623-1#116701-1#57984-1#110643-1#115722-1#116703-10#92017-1#115673-1#90736-dz#47123-1#116523-dz#116525-1#18nj-0","wpt":0,"netType":0,"cuid":"","feedCuid":"","query":"","imTimeSign":86,"asynMode":0,"asynUrl":"","isWiseDropDown":false,"asynsid":"","aspTime":1701242156194,"sourceAdNum":{"ads_220":3,"ads_2246":1,"ads_1841":3},"asynQuery":"","jFieldLinkMap":{"7R_NR2Ar5Od66xAS6MzEukmDfwECF63nEjJd1NSzaZFjo9vyU_SV-Phx_8oL4q-MHgMu_8Lget-xWko9eLLTEYmhF_8EWSUq8zrUQoohOxYqbyyzetLeSh5NgjgP3YrLNgtC3EA9OvPNXM9OPSO7g7SLjS8QqSZqxggBmhzlS54Evec4_888UqOHvwuUQE1xElmqNTPTLWfeX_PHZudE84USBr6k4EuOtZ3sqZO0O3VLex4XLGtq--MzSNhHSwNOsQ5-wOByyyyyyyyyXEjvtJXL9hSB9OwlUQQQQQQQQQQAUr54EvO-goEB3OhoOdOoOPgo3IxeqqL4ESk7qZ4JeOSk7-35AQQSU4TZex01SUNqOqJl16CuR_OkQQQQQ54ZLxsppDd---bzmxLlZUuuuuuSOu-3vnOMO5epO5SwaMOuoOZ4xe54OUg4OzcROePx3OMOvIgeX1SWOs5uSngeUoQQQrvzeX1oyF9OUDe6yAp7WWYe_MmC":"https://isite.baidu.com/site/wjzgfr1q/c2cfc805-fae0-4d19-8061-a0d5b921731c","7R_KPj5AegfG6yF9OUDe6yAp7B8z1xmC":"http://www.et-soft.com.cn/","Db_NR2Ar5Od663rj6t_Vv9DAWVztVqTZIhA6OlDOal4Q7-MWgYS5HElsdnkwFCOal4QZSdSLeU2er5gKfYt_U_DY2yQvTyjo6CpXgih4SjikSU3T5M_sSEu9q8Hj4e_r1v3xUg9tS1jlOj9LSLj4en5Vtt5Vol32AM-9uY3vglChn5MEseQnrOv3x5kseS1jeIMgKfYtVKnv-Wj4en5ovmxUbsSXej_q8Zvd3x5u9qx-9qEdsSxu9qxgjlq5gKfYt_QCJamJjAZ1L3I-hZxeT5M33IOu9q8kmhZq_H8KmuCyrrOGe2d0":"https://www.jdy.com/ykj_b1/?activeCode=00716769&channelCode=JWA0103&utm_source=baidu&utm_medium=PC%E8%B4%A2%E5%8A%A1%E4%BC%9A%E8%AE%A1&utm_campaign=%E9%80%9A%E7%94%A8&utm_term=%E8%B4%A2%E5%8A%A1%E8%BD%AF%E4%BB%B6&utm_content=%E9%80%9A%E7%94%A8","7b_NR2Ar5Od663rj6t8dSp42RfwGYslc8Sa9G4mLmFCR_g_3_ZgKfYt8-P1tA-WtLs4t5M_sSEu9q8Hj4e_r1v3xUgMIt54E9l32AM-9I7fH7fmsSXOj__seOU9tOZjEen5Vvmx5u9qEdse5-MsSX1jlqhZv4n5M8se5U9qVXZ1vmxg4mxUqT5MvmxgdsSEHMsSxH9qVhZdvmx5I9qxo9vTX8a9G4pauVQAZ1vmxg_sSLF9tqvZueT5VosSX1jlOQjexo9tS1jlS8ZdlNBmxvkr379h9m3eVh1kR":"https://www.kingdee.com/semcyn?utm_source=baidu&utm_medium=PC-%E8%B4%A2%E5%8A%A1-oCPC&utm_content=%E9%80%9A%E7%94%A8%E8%AF%8D-%E8%B4%A2%E5%8A%A1%E8%BD%AF%E4%BB%B6-%E6%A0%B8%E5%BF%83&utm_term=%E8%B4%A2%E5%8A%A1%E8%BD%AF%E4%BB%B6","7Y_NR2Ar5Od66xAS6MzEukmDfwECF63nEjJd1NSzaZFjo9vyU_SV-Phx_8oL4q-MHgMu_8Lget-xWko9eLLTEYmhF_8EWSUq8zrUQoohOxYqbyyzetLeSh5Ngt8vUQElcEzYrvQQO3rWtLWfSWtvggvOhzOQWP-931yIIXFBUQo3OhOU_Whzll4ELq5u7-_8OPSOGWdNOQVhzeSBQgd9JmerVqLQxYwYA5Pe5O6OAZCO3ZO78OUOQvqrzOOsyxQ4yu547gO0_Obxk5OKGBzvyyyyyXEjvtJXL9hSB9OwlUQQQQQQQQQQAUr54EvO-goEB3OhoOdOoOPgo3IxeqqL4ESk7qZ4JeOSk7-35AQQSU4TZex01SUNqOqJlktrNQ5tizzzzzkMQGtlDd---h1GeyuoqI---MeqhgWmzetOVotO47MAQqEOBtqLZqO-4xqhp9S9-lXAUl2ZqZdSBeBM1Og4qZeTPArzz1QjjkB9yF9OUDe6yAp7WWYqMHv2":"https://isite.baidu.com/site/wjzgfr1q/c2cfc805-fae0-4d19-8061-a0d5b921731c","Db_NR2Ar5Od66xAS6MzEukmDfwECF63nEjJd1NSzaZFjo9vyU_SV-Phx_8oL4q-MHgMu_8Lget-xWko9eLLTEYmhF_8EWSUq8zrUQoohOxYqbyyzetLeSh5Ngt8vUQElc_qjVBzOSjCOP3YQE1uUcO1xEq5lO1umxSkSUgdd3hF_8EWSUq8zrUQoohOxYqbyyzetLeSh5Ngt8vUQElc8MojRkvIUe8yOCWCnXUvxOKSn5wOs5SQISLSgVlI-OO6_9SNhHSwNOsQ5-6335UW_dvyyyXEjvtJXL9hSB9OwlUQQQQQQQQQQAUr54EvO-goEB3OhoOdOoOPgo3IxeqqL4ESk7qZ4JeOSk7-35AQQSU4TZex01SUNqOqJl1qOtx-PMW_dvyyxQOgSPMdBB____u_OQPvgtUQQQ5LenEA1QSUCSW-4xqhp9O_lE-s1xwfOCSJIg_ISxvdSxV8emEvOSQ1LTxS2lWSvOOBOvx3MlDTLlqLO7S9q7x4OEO_YmtxS1epZ_zgxq9voIS52eOuOejVZuSEtOqZHuuuuzeVMZHm_HjSvFL0_nYQAHugubR0":"https://isite.baidu.com/site/wjzgfr1q/c2cfc805-fae0-4d19-8061-a0d5b921731c","7b_igg1pE26qhQ2Oih4e2ccYlmcpMYUoeCPxZ_3tStX8uv-WFuYqx-S9SQ7xgVHCSOzmlIqMuYqxY5oS6kbyF9OUDe6yAp7WF3eQr-f":"http://dbrg.tianjimedia.com/sem/childbd/f343.html?sfrom=206&DTS=1&keyID=69046&TFT=2"},"upAdNum":0,"middleAdNum":0,"downAdNum":0,"flags":{"fixPlusSign":true,"addCmatchBackUs":true,"useNsWiseJs":true,"nsJsLog":true,"buildFeedLink":true,"smartappExtraUpdate":true,"zhidaoLineNumUpdate":true},"variable":{},"rsContent":[],"ecomData204":"","ecomData213":"","ecomData217":"","ad204Num":0,"ad213Num":0,"ad217Num":0,"isHasImlp":false,"adsInfo":{"0bc6d5f8b4de87f8_238_0":{"ideaId":62533227127,"docId":"0","mts":[]},"0bc6d5f8b4de87f8_238_1":{"ideaId":62642655281,"docId":"0","mts":[]},"0bc6d5f8b4de87f8_238_2":{"ideaId":84961780420,"docId":"0","mts":[]},"0bc6d5f8b4de87f8_1566_0":{"ideaId":84874311120,"docId":"0","mts":[2051,2062]},"0bc6d5f8b4de87f8_1188_0":{"ideaId":64414188288,"docId":"0","mts":[]},"0bc6d5f8b4de87f8_1188_1":{"ideaId":54005874245,"docId":"0","mts":[]},"0bc6d5f8b4de87f8_1188_2":{"ideaId":75044457279,"docId":"0","mts":[]}},"bdCid":62,"bdPid":19,"queryWordEnc":"","wiseSt":"","requestIpV4":2310304436,"fnizebrab":"","nsVerticalKdomainList":[],"is_rm_asyn":true,"mod":"","app_verison":"","os_version":"","bd_version":"","ios_version":0,"passportId":0,"hasYunyingCard":false,"wiseFrom":"","resultClass":"fc-0bc6d5f8b4de87f8-2246"});
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
为你推荐：
下载百度知道APP，抢鲜体验使用百度知道APP，立即抢鲜体验。你的手机镜头里或许有别人想知道的答案。扫描二维码下载
×个人、企业类侵权投诉
违法有害信息,请在下方选择后提交
类别色情低俗
涉嫌违法犯罪
时政信息不实
垃圾广告
低质灌水
我们会通过消息、邮箱等方式尽快将举报结果通知您。说明
做任务开宝箱累计完成0
个任务
10任务
50任务
100任务
200任务
任务列表加载中...