{"id":14,"date":"2016-12-28T15:34:06","date_gmt":"2016-12-28T07:34:06","guid":{"rendered":"http:\/\/limitironbox.frog.tw\/?p=1"},"modified":"2020-05-22T16:27:21","modified_gmt":"2020-05-22T08:27:21","slug":"hello-world-2","status":"publish","type":"post","link":"https:\/\/limitironbox.myds.me\/wordpress\/hello-world-2\/","title":{"rendered":"EXCEL\u8a08\u7b97\u5e74\u8cc7\u4e26\u5e36\u51fa\u4f11\u5047\u5929\u6578"},"content":{"rendered":"<p>\u5c0f\u516c\u53f8\u5982\u9047\u5230\u9700\u8981\u7b97\u5e74\u8cc7\u8207\u5929\u6578\u6642\uff0c\u624b\u52d5\u7b97\u4e5f\u662f\u53ef\u4ee5<\/p>\n<p>\u4f46\u4eba\u6578\u9054\u5230\u4e00\u5b9a\u91cf\u6642\uff0c\u5c31\u4e0d\u5bb9\u6613\u4e86!<\/p>\n<p>\u6700\u8fd1\u525b\u597d\u6709\u6b64\u9700\u6c42\u7684\u554f\u984c<\/p>\n<p>\u5df2\u7d93\u7528Excel\u7684DATEDIF\u51fd\u6578\u7b97\u51fa\u5e74\u8cc7\uff0c\u5982\u4e0d\u61c2\u5982\u4f55\u7528\u7684<a href=\"http:\/\/limitironbox.frog.tw\/it%E9%9B%9C%E7%89%A9%E5%B7%A5\/excel%E5%87%BD%E6%95%B8datedif%E7%94%A8%E6%B3%95\/\">\u8acb\u770b\u6b64<\/a><\/p>\n<p><a href=\"http:\/\/limitironbox.myds.me\/wordpress\/wp-content\/uploads\/2016\/12\/2016-12-29_163607.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-26\" src=\"http:\/\/limitironbox.myds.me\/wordpress\/wp-content\/uploads\/2016\/12\/2016-12-29_163607-300x176.jpg\" alt=\"\" width=\"484\" height=\"284\" \/><\/a><\/p>\n<p>\u7e7c\u7e8c\u8a08\u7b97\u6838\u5b9a\u5e74\u5047\u5929\u6578<\/p>\n<p><strong>106\u5e74\u8cc7\u4f11\u5047\u898f\u5247\u5982\u4e0b\uff1a<\/strong><\/p>\n<p>\u534a\u5e74\u4ee5\u4e0a 3\u5929<br \/>\n1\u5e74 7\u5929<br \/>\n2\u5e74 10\u5929<br \/>\n3\u5e74~5\u5e74 14\u5929<br \/>\n5\u5e74~9\u5e74 15\u5929<br \/>\n10\u5e74 16\u5929<br \/>\n11\u5e74 17\u5929<br \/>\n12\u5e74 18\u5929<br \/>\n13\u5e74 19\u5929<br \/>\n14\u5e74 20\u5929<br \/>\n15\u5e74 21\u5929<br \/>\n16\u5e74 22\u5929<br \/>\n17\u5e74 23\u5929<br \/>\n18\u5e74 24\u5929<br \/>\n19\u5e74 25\u5929<br \/>\n20\u5e74 26\u5929<br \/>\n21\u5e74 27\u5929<br \/>\n22\u5e74 28\u5929<br \/>\n23\u5e74 29\u5929<br \/>\n24\u5e74 30\u5929<\/p>\n<p><strong>\u8a08\u7b97\u516c\u5f0f\u5982\u4e0b\uff1a <\/strong><\/p>\n<p>=IF(D4&gt;=1,IF(D4&gt;=2,IF(D4&gt;=3,IF(D4&gt;=6,IF(D4&gt;=10,IF(D4=10,16,D4+6),15),14),10),7),3)<\/p>\n<p>\u6b64\u516c\u5f0f\u586b\u5165\u4e0a\u5716H4\uff0c\u6703\u81ea\u52d5\u53d6D4\u7684\u6578\u503c\u9032\u884c\u904b\u7b97\uff0c\u81f3\u65bc\u70ba\u4f55\u8981D4+6\uff0c\u56e0\u689d\u4ef6\u9700\u6c42\u81ea\u52d5\u5224\u65b7\uff0cex: 11\u5e74&#8212;&#8211;17\u5929\uff0c\u4ee5\u6b64\u985e\u63a8\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c0f\u516c\u53f8\u5982\u9047\u5230\u9700\u8981\u7b97\u5e74\u8cc7\u8207\u5929\u6578\u6642\uff0c\u624b\u52d5\u7b97\u4e5f&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pmpro_default_level":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts\/14"}],"collection":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":1,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts\/14\/revisions"}],"predecessor-version":[{"id":275,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts\/14\/revisions\/275"}],"wp:attachment":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/categories?post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/tags?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}