{"id":81831,"date":"2019-03-04T00:00:50","date_gmt":"2019-04-11T06:53:58","guid":{"rendered":"http:\/\/www.05921.net\/index.php\/81831\/"},"modified":"2019-04-11T14:53:58","modified_gmt":"2019-04-11T06:53:58","slug":"1605896f2b","status":"publish","type":"post","link":"https:\/\/www.05921.net\/index.php\/81831\/","title":{"rendered":"\u5206\u4eab\u4e00\u4e2aExcel\u56db\u820d\u516d\u5165\u4e94\u6210\u53cc\u7684\u516c\u5f0f\uff01"},"content":{"rendered":"<div class=\"bpp-post-content\">\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;color: rgb(136, 136, 136);font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">=if((A2*B2-0.5\uff09\/int(A2*B2)=1,int(A2*B2)+mod(int(A2*B2),2),if(A2*B2-int(A2*B2)&gt;0.5,int(A2*B2)+1,int(A2*B2)))\/B2<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;color: rgb(136, 136, 136);font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">A2\u4e3a\u539f\u59cb\u6570\u636e\uff1bB2\u4e3a\u5c0f\u6570\u70b9\u4fdd\u7559\u4f4d\u6570\uff0c\u4f8b\u5982\uff1a1\u4f4d\u5c0f\u6570\u4e3a10\uff0c2\u4f4d\u5c0f\u6570\u4e3a100\u4ee5\u6b64\u7c7b\u63a8\uff1b\u516c\u5f0f\u590d\u5236\u5728C2\u680f\u5185\u3002<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><br style=\"max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\"  \/><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">\u521a\u770b\u5230\u4e00\u4e2a\u84b2\u53cb\u53d1\u5e03\u7684\u516c\u5f0f\uff0c\u5f88\u68d2\u3002\u7a81\u7136\u60f3\u5230\u81ea\u5df1\u624b\u4e2d\u4e5f\u6709\u4e00\u4e2a\u4e0d\u9519\u7684\u516c\u5f0f\uff0c\u5728\u6b64\u5206\u4eab\u7ed9\u5927\u5bb6\u3002<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><br style=\"max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\"  \/><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;color: rgb(255, 76, 0);font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">=IF(MOD(ABS(A1*POWER(10,B1)),2)=0.5,ROUNDDOWN(A1,B1),ROUND(A1,B1))<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><br style=\"max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\"  \/><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">A1\u4e3a\u539f\u59cb\u6570\u636e\uff0c<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">B1\u4e3a\u5c0f\u6570\u70b9\u4fdd\u7559\u4f4d\u6570\u3002<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">\u516c\u5f0f\u590d\u5236\u5728C1\u680f\u3002<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">\u53ef\u4ee5\u5c06B1\u66ff\u6362\u6210\u81ea\u5df1\u9700\u8981\u7684\u4fdd\u7559\u4f4d\u6570\u7684\u6570\u5b57\uff0c\u8ba9\u516c\u5f0f\u66f4\u7b80\u5355\u4e14\u4e0d\u9700\u8981\u8bbe\u7f6eB\u5217\u3002<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><br style=\"max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\"  \/><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">\u516c\u5f0f\u542b\u4e49\uff1aPOWER\uff08X,Y\uff09\uff1aX\u7684Y\u6b21\u5e42\uff1bABS\uff08X\uff09\uff1aX\u7684\u7edd\u5bf9\u503c\uff1bMOD\uff08Y\uff0c2\uff09\uff1aY\u9664\u4ee52\u7684\u4f59\u6570\uff1bROUNDDOWN\uff08X,2\uff09:\u820d\u53bbX\u5c0f\u6570\u70b92\u4f4d\u4ee5\u540e\u7684\u6570\u5b57\uff1bROUND\uff08Y,2\uff09\uff1a\u5bf9Y\u8fdb\u884c\u56db\u820d\u4e94\u5165\uff0c\u4fdd\u75592\u4f4d\u5c0f\u6570\u3002<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><br style=\"max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\"  \/><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\"><span style=\"max-width: 100%;font-size: 15px;box-sizing: border-box !important;word-wrap: break-word !important;\">\u5c0f\u7f16\u6309\u7167\u84b2\u53cb\u7684\u516c\u5f0f\u505a\u4e86\u6d4b\u8bd5\uff0c\u7684\u786e\u5f88\u65b9\u4fbf\uff0c\u5c0f\u4f19\u4f34\u4eec\u4e5f\u53ef\u4ee5\u8bd5\u8bd5\u5427\u3002\u5982\u679c\u7528\u4e8e\u751f\u4ea7\u6216\u68c0\u9a8c\uff0c\u5404\u4f4d\u522b\u5fd8\u4e86\uff0c\u8981\u505a\u4e00\u4e0b\u9a8c\u8bc1\u54e6\uff01<\/span><\/p>\n<p style=\"max-width: 100%;min-height: 1em;font-variant-numeric: normal;font-variant-east-asian: normal;letter-spacing: 0.544px;line-height: 27.2px;white-space: normal;widows: 1;text-align: center;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\">\n<section><mpcps frameborder=\"0\" class=\"js_editor_cps\"  style=\"width:100% !important;border:0;\"           ><\/mpcps><\/section>\n<p><br  \/><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>=if((A2*B2-0.5\uff09\/int(A2*B2)=1,int(A2*B2)+mod(int(A2*B2), [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":81832,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/posts\/81831"}],"collection":[{"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/comments?post=81831"}],"version-history":[{"count":1,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/posts\/81831\/revisions"}],"predecessor-version":[{"id":81833,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/posts\/81831\/revisions\/81833"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/media\/81832"}],"wp:attachment":[{"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/media?parent=81831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/categories?post=81831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.05921.net\/index.php\/wp-json\/wp\/v2\/tags?post=81831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}