请教Excel高手,我输入的函数有什么问题?为什么在W3单元格出现错误提示是什么原因不能出现正确的2呢?


选择擅长的领域继续答题?
{@each tagList as item}
${item.tagName}
{@/each}
手机回答更方便,互动更有趣,下载APP
提交成功是否继续回答问题?
手机回答更方便,互动更有趣,下载APP
展开全部我觉得有你是不是选中了不连续的单元格,如果选择了不连续的单元格,或者是两个区域,他就会显示无效,比如查找A列,返回G列的值,区域应该选择A:G,然后A列为一,一直数到G列是第几,=VLOOKUP(A1,A1:G500,7,FALSE)',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":"0d6a2ef8962f1a74","eid":"238_11102_7869012_300003","bwsid":0,"osid":0,"pageid":"zhidao_content_page_new","baiduid":"84A802B48475974A471A6E6A26D1827E","ovlid":"57984-1#111452-1#110292-18#116347-dz#110643-1#116703-dz#116352-dz#115722-1#58562-1#116773-1#116776-1#112532-dz#111894-dz#47135-dz#116525-1#117nj-0","wpt":0,"netType":0,"cuid":"","feedCuid":"","query":"%E8%AF%B7%E9%97%AE%E5%93%AA%E4%BD%8D%E9%AB%98%E6%89%8B%E4%BC%9A%E7%94%A8EXCEL%E9%87%8C%E9%9D%A2%E7%9A%84VLOOKUP%E5%87%BD%E6%95%B0?%E4%B8%BA%E4%BB%80%E4%B9%88%E6%88%91%E6%8C%89%E9%A1%BA%E5%BA%8F%E7%94%A8%E7%AC%AC%E4%BA%8C%E6%A0%8F%E6%80%BB%E6%98%AF%E6%98%BE%E7%A4%BA%E6%97%A0%E6%95%88","imTimeSign":45,"asynMode":0,"asynUrl":"","isWiseDropDown":false,"asynsid":"","aspTime":1701268015636,"sourceAdNum":{"ads_220":3,"ads_2246":1,"ads_1841":3},"asynQuery":"","jFieldLinkMap":{"DY_iHF8xnhA94wEYL_SNK-deQbfHgI3ynDgg6msw5I7AMHdey5Z_otIv8EWj3q-Xek8dqTUAMHz4rMG34nheuztIdMugbzTEZF83e5ZGzIUv59YlI5ogt5SdS9JJxuoO3ZlMexSEOBlk_IIU7Na9WWstxU9zxgjbS8aB17I4RAgg_8w9zxyPrMjbSVaSPQnYPyZWqubltXQjkSyMHz4rMG34nheuztIdMugbzTEZF83e5ZGzmTMHvGYTjGo_5Z4xw6H9zUE5_s4PLoEs4PLVlNBmxvkr379h9mlpth1mC0":"http://redirect.simba.taobao.com/rd?c=un&w=unionsem&k=74175f13c74157df&p=mm_26632258_3504122_32538762&b=CmmmB1CJTghi0fXGWRV&s=&f=https%3A%2F%2Fuland.taobao.com%2Fsem%2Ftbsearch%3Frefpid%3Dmm_26632258_3504122_32538762%26keyword%3Dvue%25E4%25B9%25A6","DD_NR2Ar5Od669ITOP45Y8IaBaAB1ZZKvNq55EG94IQnLpOnkIoLlOA7hS1u_uElyUCUPMAzE_dq-X45m1kvIIn5QjR17DhBkxTlZZjblkGY_ur8a9G4mLmFCR_g_3_AxZjdsRP5QGHTOKGmWHGzIT7jHzs_lTUQqRHDQoM488a9G4mgwRDkRArzEGl32AM-CFhY_f88xhyF9OUDe6yAp7WFklXzkf":"https://coding.imooc.com/class/416.html?mc_marking=df9f7cab088ab6adc083014f415e4a38&mc_channel=bdocpc2&sem=2&utm_source=baidu-pc&utm_medium=sem2&utm_campaign=coding&utm_content=416&utm_term=coding","DY_NR2Ar5Od66ukEd8lDfIt7jHzk8sHfGmEukmr8a9G4I2UM3PQDpI5gKfYt_QrMAzONDkbLNe_MW8lpS8a9G4mgwRDkRA5ZuggvNS5Wker8a9G4pauVQakn5emMTas1f_U_h1uyC0":"https://apifox.com/?utm_source=baidu&utm_medium=sem&utm_campaign={planid}&utm_content={unitid}&utm_term={kw_enc_utf8}","Db_NR2Ar5Od669ITOP45Y8IaBjEakqAKry5oG94IQnLpOnkk9E8ozNl3IvHFEoHEvnsLLLLN4POZklIOHvIIn5QjR17DhBkxTlZZjblkGY_ur8a9G4mLmFCR_g_3_AxZjdsRP5QGHTOKGmWHGzIT7jHzs_lTUQqRHDQoM488a9G4mgwRDkRAcgg51IT7jHzYD1py5SQ0MzzkoDsOVBIsQjPakg_vu2d0":"https://coding.imooc.com/?c=vuejs&mc_marking=3cbd121fc52291e98acbbbd129376964&mc_channel=bdocpc2&sem=2&utm_source=baidu-pc&utm_medium=sem2&utm_campaign=coding&utm_content=coding&utm_term=Vue.js","DY_NR2Ar5Od663rj6tVyaBOnzqDZXPBqM764x-OVf88HddwxCpnpynBkn5emMTas1f_IrHG_z20":"https://www.gulingai.com/?s=baidu_DJcode&gnType=2","Db_iHF8xnhA94wEYL_SNK-deQbfHgI3ynDgg6msw5I7AMHdey5Z_otIv8EWj3q-Xek8dqTUAMHz4rMG34nheuztIdMugbzTEZF83e5ZGzIUvnhyUtxqIXMqOd9HSgGO3E1OxtEO0IdWmllv2J7jZZ93SLjbS8ZFqT77h2ezCn8EuTWjbS_pIrZFqp7tpyuCp_5Zl1Fd3tyZWtVrM-zI5HkzuPv1-3eorzEFb4XrHIkvX5Hbs4rMVHC3ZHgmX5zs4PLM33ThedSyZF8Ld3The1tTrHIlS8ZF8LOj9zUE5Gs4PvOI9zUVSOjbLXxW9zUEU_s4Pv1ds4PLM33ThedSyZF8LdoDsOVBIsQjPakktUrzVf0":"http://redirect.simba.taobao.com/rd?c=un&w=unionsem&k=74175f13c74157df&p=mm_26632258_3504122_32538762&b=2jrSR1mHBceN6VQINXo&s=&f=https%3A%2F%2Fuland.taobao.com%2Fsem%2Ftbsearch%3Frefpid%3Dmm_26632258_3504122_32538762%26keyword%3D%25E7%25BD%2591%25E7%25BB%259C%25E6%2595%2599%25E7%25A8%258B%25E7%25BD%2591","7D_iHF8xnhA94wEYL_SNK-deQbfHgI3ynDgg6msw5I7AMHdey5Z_otIv8EWj3q-Xek8dqTUAMHz4rMG34nheuztIdMugbzTEZF83e5ZGzIUvrZVOQxODtxLOkOvTMwPOwlXLW631Imvr8VBJ9fkk3X5Vs45o9zxgKwuB8tJjQovgcs45oAMH9zxy9xA-hpAojkS_zIX5793OQHG4TMHYtThHI_4Xrl1_ozurgWbLTIMWY4nrHGeRlrKYdvZWtECsFs4Pvi1jbLXXejbLUPhZF8qXMjbLXxu9zUEg4mThextQr5A_HjSvFL0_nYQZuvUle70":"http://redirect.simba.taobao.com/rd?c=un&w=unionsem&k=74175f13c74157df&p=mm_26632258_3504122_32538762&b=zkNbM7HSU2xrO6k3u3r&s=&f=https%3A%2F%2Fuland.taobao.com%2Fsem%2Ftbsearch%3Frefpid%3Dmm_26632258_3504122_32538762%26keyword%3Dvue%2520%25E5%2588%25B6%25E4%25BD%259Capp"},"upAdNum":0,"middleAdNum":0,"downAdNum":0,"flags":{"fixPlusSign":true,"addCmatchBackUs":true,"zhidaoLineNumUpdate":true},"variable":{},"rsContent":[],"ecomData204":"","ecomData213":"","ecomData217":"","ad204Num":0,"ad213Num":0,"ad217Num":0,"isHasImlp":false,"adsInfo":{"0d6a2ef8962f1a74_238_0":{"ideaId":55090986703,"docId":"0","mts":[]},"0d6a2ef8962f1a74_238_1":{"ideaId":67592712462,"docId":"0","mts":[]},"0d6a2ef8962f1a74_238_2":{"ideaId":68644335449,"docId":"0","mts":[]},"0d6a2ef8962f1a74_1566_0":{"ideaId":68896485578,"docId":"0","mts":[2051,2062]},"0d6a2ef8962f1a74_1188_0":{"ideaId":78338866164,"docId":"0","mts":[]},"0d6a2ef8962f1a74_1188_1":{"ideaId":78844840934,"docId":"0","mts":[]},"0d6a2ef8962f1a74_1188_2":{"ideaId":78844879192,"docId":"0","mts":[]}},"bdCid":62,"bdPid":19,"queryWordEnc":"%C7%EB%CE%CA%C4%C4%CE%BB%B8%DF%CA%D6%BB%E1%D3%C3EXCEL%C0%EF%C3%E6%B5%C4VLOOKUP%BA%AF%CA%FD%3F%CE%AA%CA%B2%C3%B4%CE%D2%B0%B4%CB%B3%D0%F2%D3%C3%B5%DA%B6%FE%C0%B8%D7%DC%CA%C7%CF%D4%CA%BE%CE%DE%D0%A7","wiseSt":"","requestIpV4":3493949876,"fnizebrab":"","nsVerticalKdomainList":[],"is_rm_asyn":true,"mod":"","app_verison":"","os_version":"","bd_version":"","ios_version":0,"passportId":0,"hasYunyingCard":false,"wiseFrom":"","resultClass":"fc-0d6a2ef8962f1a74-2246"});
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
为你推荐:
下载百度知道APP,抢鲜体验使用百度知道APP,立即抢鲜体验。你的手机镜头里或许有别人想知道的答案。扫描二维码下载
×个人、企业类侵权投诉
违法有害信息,请在下方选择后提交
类别色情低俗
涉嫌违法犯罪
时政信息不实
垃圾广告
低质灌水
我们会通过消息、邮箱等方式尽快将举报结果通知您。说明
做任务开宝箱累计完成0
个任务
10任务
50任务
100任务
200任务
任务列表加载中...

输入函数的时候,()都是要一起打的,比如if(),然后光标再回到()中间再输入参数。但是EXCEL光标移回()中间的时候,总是弹出提示框"此公式有问题",非常影响效率。请...
输入函数的时候,()都是要一起打的,比如if(),然后光标再回到()中间再输入参数。但是EXCEL光标移回()中间的时候,总是弹出提示框"此公式有问题", 非常影响效率。请问有什么办法可以不再让这个提示框出现吗?
展开
选择擅长的领域继续答题?
{@each tagList as item}
${item.tagName}
{@/each}
手机回答更方便,互动更有趣,下载APP
提交成功是否继续回答问题?
手机回答更方便,互动更有趣,下载APP
展开全部数据有效性的公式可以先在工作表中测试,正确后,再在设置数据有效性性时使用。解决方法如下:1、求和: 在该单元格中输入“=SUM()”,选择要求和的部分,点击enter。2、平均数: 单元格中输入“=AVERAGE()”,选择要求平均数的部分,点击enter。3、排名: 单元格中输入“ =RANK()”,先选需要排名的对象,再选择全部,点击enter。4、等级: =IF(K2>=85,"优",IF(K2>=74,"良",IF(K2>=60,"及格","不及格")))。5、最高分: 单元格中输入“ max()”,选择全部需要比较的对象,点击enter。6、最低分: 单元格中输入“ min()”,选择全部需要比较的对象,点击enter。7、分数段人数统计: 单元格中输入“=COUNTIF() ”,选择全部需要的对象,在输入限制的分数,点击enter。已赞过已踩过你对这个回答的评价是?评论
收起
展开全部那是因为你没有输入完参数就按回车键例如你输入if函数,可以采用如下方式避免输入=if后按tab键,excel会自动补充左括号并提示参数,输入参数后再回车,excel会自动补充右括号如果你是手动输入=if(),则可以用键盘上的左方向键向左移动,或者鼠标直接单击编辑栏中一对括号中间位置,输入参数
本回答被网友采纳展开全部不要在单元格编辑公式,方向键被占用,要在编辑栏编辑公式。编辑公式要有个好习惯,先把公式框架一层层写出来,这样不至于出错。例如=SEARCH(,,)=SEARCH("北京",$E2,1)=ISNUMBER(SEARCH("北京",$E2,1))=IF(ISNUMBER(SEARCH("北京",$E2,1)),"排除")=IF(ISNUMBER(SEARCH("北京",$E2,1)),"排除",INDEX(,,2))=IF(ISNUMBER(SEARCH("北京",$E2,1)),"排除",INDEX(Sheet1!$A$1:$B$150,,2))=IF(ISNUMBER(SEARCH("北京",$E2,1)),"排除",INDEX(Sheet1!$A$1:$B$150,MATCH(,,),2))=IF(ISNUMBER(SEARCH("北京",$E2,1)),"排除",INDEX(Sheet1!$A$1:$B$150,MATCH($K2,Sheet1!$A$1:$A$150,0),2))=IFERROR(IF(ISNUMBER(SEARCH("北京",$E2,1)),"排除",INDEX(Sheet1!$A$1:$B$150,MATCH($K2,Sheet1!$A$1:$A$150,0),2)),"")
展开全部遇到相同问题,按Esc即可退出此种情况展开全部是英文半角的括号吗?=IF(A1=10,"K","")你复制试下
收起
更多回答(4)
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
为你推荐:
下载百度知道APP,抢鲜体验使用百度知道APP,立即抢鲜体验。你的手机镜头里或许有别人想知道的答案。扫描二维码下载
×个人、企业类侵权投诉
违法有害信息,请在下方选择后提交
类别色情低俗
涉嫌违法犯罪
时政信息不实
垃圾广告
低质灌水
我们会通过消息、邮箱等方式尽快将举报结果通知您。说明
做任务开宝箱累计完成0
个任务
10任务
50任务
100任务
200任务
任务列表加载中...

我要回帖

更多关于 单元格出现错误提示是什么原因 的文章

 

随机推荐