{"id":884,"date":"2020-12-10T15:12:00","date_gmt":"2020-12-10T07:12:00","guid":{"rendered":"http:\/\/www.langmanezhuang.com\/index.php\/2020\/12\/10\/excel%e5%ae%a2%e6%88%b7%e7%ad%89%e7%ba%a7%e6%98%9f%e7%ba%a7%e8%a1%a8%e8%be%be\/"},"modified":"2020-12-10T15:12:00","modified_gmt":"2020-12-10T07:12:00","slug":"excel%e5%ae%a2%e6%88%b7%e7%ad%89%e7%ba%a7%e6%98%9f%e7%ba%a7%e8%a1%a8%e8%be%be","status":"publish","type":"post","link":"http:\/\/blog.langmanezhuang.com\/index.php\/2020\/12\/10\/excel%e5%ae%a2%e6%88%b7%e7%ad%89%e7%ba%a7%e6%98%9f%e7%ba%a7%e8%a1%a8%e8%be%be\/","title":{"rendered":"Excel\u5ba2\u6237\u7b49\u7ea7\u661f\u7ea7\u8868\u8fbe"},"content":{"rendered":"

\u7528\u5de5\u5177:REPT\u51fd\u6570+IF\u51fd\u6570<\/p>\n

 <\/p>\n

\u4e3a\u4e86\u76f4\u89c2\u5730\u8868\u793a\u4e00\u5b9a\u7684\u8bc4\u7ea7\uff0c\u7528\u6237\u7ecf\u5e38\u4f7f\u7528“\u2605” \u7684\u591a\u5c11\u6765\u8ff8\u884c\u8868\u8ff0\u3002\u5982\u679c\u73b0\u5728\u9700\u8981\u5bf9\u5ba2\u6237\u7684\u7ea7\u522b\u8ff8\u884c \u8868\u8ff0,\u5728Excel\u4e2d\u540c\u6837\u53ef\u4ee5\u501f\u52a9“\u2605”\u6765\u8868\u793a\u3002\u6bd4\u5982\u67d0\u5546 \u57ce\u4f1a\u5458\u6839\u636e\u79ef\u5206\u5206\u4e3a\u666e\u901a\u4f1a\u5458\uff08\u5c0f\u4e8e57\u5206,\u5bf9\u5e94\u4e09\u661f\u7ea7 \u4ee5\u4e0b\u4f1a\u5458\uff09\u3001\u9ad8\u7ea7\u4f1a\u5458\uff08\u79ef\u5206\u572857~76\u5206,\u5bf9\u5e94\u4e09\u661f\u7ea7 \u4f1a\u5458\uff09\u548cVIP\u4f1a\u5458\uff08\u79ef\u5206\u5927\u4e8e76\u5206\uff0c\u56db\u661f\u7ea7\u4ee5\u4e0a\u4f1a\u5458\uff09\u4e09 \u6863,\u5982\u679c\u624b\u52a8\u8ff8\u884c\u5206\u7c7b\u586b\u5199\uff0c\u8d39\u65f6\u8d39\u529b\uff0c\u501f\u52a9REPT\u51fd \u6570\u548cIF\u51fd\u6570\uff0c\u5219\u53ef\u4ee5\u5c06\u4f1a\u5458\u7ea7\u522b\u66f4\u76f4\u89c2\u5730\u4f53\u73b0\u51fa\u6765\u3002<\/p>\n

\n
=REPT(\"\u2605\",B2\/19)<\/pre>\n<\/div>\n
REPT \u51fd\u6570\u683c\u5f0f\u662f”REPT \uff08text, number_times\uff09”, \u5176\u4e2dtext\u662f\u6307\u9700\u8981\u91cd\u590d\u663e\u793a\u7684\u6587\u672c,number_times \u5219\u8868\u793a\u6307\u5b9a\u6587\u672c\u91cd\u590d\u6b21\u6570\u7684\u6574\u6570\uff08\u5982\u679cnumber_times\u4e0d\u662f\u6574\u6570\uff0c\u5219\u5c06\u88ab\u622a\u5c3e\u53d6\u6574\uff09\u3002\u800c\u901a\u8fc7\u79ef\u5206\u89c4\u5219\u53ef\u4ee5\u77e5\u9053,\u8fd9\u91cc\u6bcf19\u4e2a\u79ef\u5206\u5bf9\u5e94 \u4e00\u9897\u661f\uff0c\u56e0\u6b64\u7528\u6237\u53ea\u8981\u5728=2\u8f93\u5165\u516c\u5f0f“\uff1fREPT4 \u2605”\uff0c B2\/19 \uff09”,\u8868\u793a\u4f7f\u7528=2\u7684\u6570\u503c\u9664\u4ee519\u5f97\u5230\u91cd\u590d\u663e\u793a\u6587 \u672c\u6570\uff08\u6587\u672c\u5219\u4e3a“ \u2605 ”\u7b26\u53f7\uff09,\u8fd9\u6837\u5c06\u516c\u5f0f\u4e0b\u62c9\u586b\u5145\u540e, \u5c31\u53ef\u4ee5\u76f4\u63a5\u770b\u5230\u5ba2\u6237\u7684\u661f\u7ea7\u4e86 \u5982\u4e0b\u56fe<\/p>\n
 \"\"<\/p>\n
IF\u51fd\u6570\u5219\u53ef\u4ee5\u5c06\u5ba2\u6237\u661f\u7ea7\u6807\u6ce8\u4e3a\u5bf9\u5e94\u7684\u7ea7\u522b\uff0c\u5b9a\u4f4d\u5230D2\u8f93\u5165\u516c\u5f0f
<\/span><\/span><\/span><\/span><\/span><\/p>\n
\n
=IF(B2<57,\"\u666e\u901a\u4f1a\u5458\",IF(B2<76, \"\u9ad8\u7ea7\u4f1a\u5458\",\"VIP\u4f1a\u5458\"))\n<\/pre>\n<\/div>\n
\u3000\u8fd9\u91cc\u4f7f\u7528\u5d4c\u5957 \u51fd\u6570\u5bf9B2\u7684\u503c\u8fdb\u884c\u5224\u65ad\uff0c\u6309\u7167\u79ef\u5206\u7684\u6807\u51c6\u663e\u793a\u6307\u5b9a\u7684 \u4f1a\u5458\u540d\u79f0\uff0c\u540c\u4e0a\u4e0b\u62c9\u516c\u5f0f\u540e\uff0c\u5c31\u53ef\u4ee5\u663e\u793a\u6240\u6709\u4f1a\u5458\u7ea7 \u522b\u540d\u79f0\u3002\u7ecf\u8fc7\u8fd9\u6837\u7684\u8bbe\u8ba1\uff0c\u4f1a\u5458\u662f\u4ec0\u4e48\u661f\u7ea7\uff0c\u5bf9\u5e94\u4ec0\u4e48 \u7ea7\u522b\u7684\u4f1a\u5458\u662f\u4e0d\u662f\u4e00\u76ee\u4e86\u7136\u4e86<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u7528\u5de5\u5177:REPT\u51fd\u6570+IF\u51fd\u6570   \u4e3a\u4e86\u76f4\u89c2\u5730\u8868\u793a\u4e00\u5b9a\u7684\u8bc4\u7ea7\uff0c\u7528\u6237\u7ecf\u5e38\u4f7f\u7528“\u2605&rdqu … \u7ee7\u7eed\u9605\u8bfb Excel\u5ba2\u6237\u7b49\u7ea7\u661f\u7ea7\u8868\u8fbe<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/884"}],"collection":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/comments?post=884"}],"version-history":[{"count":0,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}