{"id":2787,"date":"2024-03-04T15:20:56","date_gmt":"2024-03-04T06:20:56","guid":{"rendered":"http:\/\/tmstmr.kir.jp\/kaisha\/?page_id=2787"},"modified":"2024-03-26T14:15:15","modified_gmt":"2024-03-26T05:15:15","slug":"%e4%b8%ad%e5%ad%a6%e7%94%9f%e3%81%ae%e3%81%bf%e3%81%aa%e3%81%95%e3%82%93%e3%81%b8","status":"publish","type":"page","link":"http:\/\/cibik.think-mate.gr.jp\/?page_id=2787","title":{"rendered":"\u8abf\u67fb\u5831\u544a\u66f8\u306e\u30af\u30ed\u30b9\u96c6\u8a08\u3092\u52a0\u5de5\u3057\u3001\u95a2\u9023\u3092\u78ba\u304b\u3081\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u3059\u309d\u3081<\/h2>\n\n\n\n<p>\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3059\u308b\u3068\u304d\u306b\u306f\u3001\u300cGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u300d\u306e\uff3b\u633f\u5165\uff3d\u30e1\u30cb\u30e5\u30fc\u306b\u3042\u308b\uff3b\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\uff3d\u3092\u4f7f\u3044\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u3053\u3068\u3092\u3001\uff3b\u633f\u5165\uff3d\u2015\uff3b\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\uff3d\u3092\u4f7f\u3044\u307e\u3057\u3087\u3046\u3001\u3068\u66f8\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u306f\u3058\u3081\u306b<\/h2>\n\n\n\n<p>x\u5e74\u306e\u30c7\u30fc\u30bf\u3092\u8868\u8a08\u7b97\u30bd\u30d5\u30c8\u3067\u8aad\u307f\u8fbc\u3093\u3067\u3001\u6295\u7968\u7387\u3092\u96c6\u8a08\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\uff3b\u633f\u5165\uff3d\u2015\uff3b\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\uff3d<br>\u300c\u884c\u300d\u306b\u300c\u8ffd\u52a0\u300d\u3067\u300c\uff08\u6295\u7968\u53c2\u52a0\u306e\u5909\u6570\u540d\uff09\u300d<br>\u300c\u5024\u300d\u306b\u300c\u8ffd\u52a0\u300d\u3067\u300c\uff08ID\uff09\u300d\u3068\u3057\u3001\u300c\u96c6\u8a08\u300d\u304b\u3089\u300cCOUNT\u300d\u3092\u9078\u629e<br>\u6ce8\u610f\uff1a\u300c\u5024\u300d\u306e\u300c\u96c6\u8a08\u300d\u304c\u300cSUM\u300d\u3060\u3068\u300cID\u300d\u306e\u5408\u8a08\u5024\u304c\u8868\u793a\u3055\u308c\u307e\u3059<\/p>\n\n\n\n<p>\u6295\u7968\u7387\u306f\u671f\u65e5\u524d\u6295\u7968\u3001\u4e0d\u5728\u8005\u6295\u7968\u3001\u767d\u7968\u3092\u542b\u307f\u307e\u3059\u3002\u3053\u306e\u8abf\u67fb\u3067\u306f\u3001\u6295\u7968\u53c2\u52a0\u306b\u3064\u3044\u3066\u306f\u4ee5\u4e0b\u306e\u9805\u76ee\u306b\u5206\u3051\u3066\u305f\u305a\u306d\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5f53\u65e5\u6295\u7968\u3057\u305f<\/li>\n\n\n\n<li>\u671f\u65e5\u524d\u6295\u7968\u3092\u3057\u305f<\/li>\n\n\n\n<li>\u4e0d\u5728\u8005\u6295\u7968\u3092\u3057\u305f<\/li>\n\n\n\n<li>\u767d\u7968\u3092\u6295\u7968\u3057\u305f<\/li>\n\n\n\n<li>\u6295\u7968\u3057\u306a\u304b\u3063\u305f<\/li>\n\n\n\n<li>\u5fd8\u308c\u305f\u30fb\u899a\u3048\u3066\u3044\u306a\u3044<\/li>\n<\/ol>\n\n\n\n<p>\u3057\u305f\u304c\u3063\u3066\u3001\u4e0b\u306e\u3044\u305a\u308c\u304b\u306e\u4f5c\u696d\u304c\u5fc5\u8981\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u300c\u6295\u7968\u53c2\u52a0\u300d\u306e\u9805\u76ee\u3092\u96c6\u8a08\u3057\u3001\u5408\u8a08\u3059\u308b<\/li>\n\n\n\n<li>\u300c\u6295\u7968\u53c2\u52a0\u300d\u306e\u9805\u76ee\u3092\u307e\u3068\u3081\u3066\u304b\u3089\u96c6\u8a08\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6295\u7968\u53c2\u52a0\u306e\u9805\u76ee\u3092\u307e\u3068\u3081\u308b\u5834\u5408<br>\u6295\u7968\u53c2\u52a0\u306e\u5217\u306e\u53f3\u5074\uff08\u306a\u3069\uff09\u306b\u5217\u3092\u633f\u5165\u3057\u3001\u300c\u6295\u7968\u53c2\u52a0\u306e\u6709\u7121\u300d\u3068\u540d\u4ed8\u3051\u305f\u5217\u3092\u4f5c\u308b\u3068\u3088\u3044\u3067\u3057\u3087\u3046\u3002<br>\u305d\u306e\u5217\u306b\u3001\u3082\u3068\u3082\u3068\u306e\u300c\u6295\u7968\u53c2\u52a0\u300d\u306e\u5024\u306b\u5fdc\u3058\u3066\u3001\u300c\u5f53\u65e5\u6295\u7968\u300d\u300c\u671f\u65e5\u524d\u6295\u7968\u300d\u300c\u4e0d\u5728\u8005\u6295\u7968\u300d\u300c\u767d\u7968\u300d\u3092\u3059\u3079\u3066\u540c\u3058\u4e00\u3064\u306e\u5024\u306b\u3001\u300c\u6295\u7968\u3057\u306a\u304b\u3063\u305f\u300d\u3092\u4e00\u3064\u306e\u5024\u306b\u3001\u300c\u5fd8\u308c\u305f\u30fb\u899a\u3048\u3066\u3044\u306a\u3044\u300d\u3092\u4e00\u3064\u306e\u5024\u306b\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u3053\u306e\u3088\u3046\u306a\u5834\u5408\u306b\u306fifs\u3068\u3044\u3046\u95a2\u6570\u3092\u4f7f\u3046\u3068\u4fbf\u5229\u3067\u3059\u3002<br>\u53c2\u8003\uff1aifs\u95a2\u6570\uff08<a href=\"https:\/\/support.google.com\/docs\/table\/25273?hl=ja#query=ifs\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/support.google.com\/docs\/table\/25273?hl=ja#query=ifs<\/a>\uff09<br>\u4eee\u306b\u6295\u7968\u53c2\u52a0\u306e\u5217\u304cB\u3067\u300c\u5f53\u65e5\u6295\u7968\u300d\u304c1\u3001\u300c\u671f\u65e5\u524d\u6295\u7968\u300d\u304c2\u3001\u300c\u4e0d\u5728\u8005\u6295\u7968\u300d\u304c3\u3001\u300c\u767d\u7968\u300d\u304c4\u3001\u300c\u6295\u7968\u3057\u306a\u304b\u3063\u305f\u300d\u304c5\u3001\u300c\u5fd8\u308c\u305f\u30fb\u899a\u3048\u3066\u3044\u306a\u3044\u300d\u304c6\u3060\u3063\u305f\u3068\u3057\u307e\u3057\u3087\u3046\u3002\u65b0\u3057\u3044\u300c\u6295\u7968\u53c2\u52a0\u306e\u6709\u7121\u300d\u306f\u300c\u5f53\u65e5\u3001\u671f\u65e5\u524d\u3001\u4e0d\u5728\u8005\u3001\u767d\u7968\u300d\u30921\u3001\u300c\u6295\u7968\u3057\u306a\u304b\u3063\u305f\u300d\u30920\u3001\u300c\u5fd8\u308c\u305f\u30fb\u899a\u3048\u3066\u3044\u306a\u3044\u300d\u3092888\u3068\u3057\u307e\u3059\u3002<br>=IFS(B2=1,1,B2=2,1,B2=3,1,B2=4,1,B2=5,0,B2=6,888,TRUE,999)<br>\u6700\u5f8c\u306e\u300cTRUE,999\u300d\u3068\u3044\u3046\u306e\u306f\u3001\u3069\u308c\u306b\u3082\u5f53\u3066\u306f\u307e\u3089\u306a\u304b\u3063\u305f\u5834\u5408\uff08\u305f\u3068\u3048\u3070\u7a7a\u6b04\u306a\u3069\uff09\u306e\u3068\u304d\u306b999\u3068\u3059\u308b\u3001\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002<br>1\u306e\u4ee3\u308f\u308a\u306b&#8221;\u6295\u7968&#8221;\u30010\u306e\u4ee3\u308f\u308a\u306b&#8221;\u68c4\u6a29&#8221;\u3001\u306a\u3069\u3068\u6587\u5b57\u306b\u3057\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002\u6587\u5b57\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f&#8221;\uff08\u30c0\u30d6\u30eb\u30b3\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\uff09\u3067\u56f2\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>4\u4ee5\u4e0b\u30921\u30015\u30920\u30016\u3092888\u3067\u3059\u304b\u3089\u4ee5\u4e0b\u306e\u901a\u308a\u306b\u66f8\u3051\u3070\u3044\u3044\u306e\u3067\u306f\u306a\u3044\u304b\u3001\u3068\u601d\u3063\u305f\u3042\u306a\u305f\u306f\u304a\u3057\u3044\uff01<br>=IFS(B2&lt;=4,1,B2=5,0,D2=6,888,TRUE,999)<br>\u3068\u66f8\u304f\u3068\u3001\u7a7a\u6b04\u306e\u5834\u5408\u306b\u300c4\u3088\u308a\u5c0f\u3055\u3044\u300d\u3068\u5224\u5b9a\u3055\u308c\u3066\u30011\u304c\u5165\u308a\u307e\u3059\u3002<br>\u6700\u521d\u306b\u7a7a\u6b04\u304b\u3069\u3046\u304b\u306e\u5224\u5b9a\u3092\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<br>=IFS(ISBLANK(B2),999,B2&lt;=4,1,B2=5,0,D2=6,888,TRUE,999)<\/p>\n\n\n\n<p>x\u5e74\u306e\u9078\u6319\u3067\u306f\u3001\u5e74\u9f62\u306b\u3088\u3063\u3066\u6295\u7968\u7387\u306b\u5dee\u304c\u3042\u308b\u3067\u3057\u3087\u3046\u304b\uff1f<br>\u5e74\u9f62\u306f\u5b9f\u969b\u306e\u5e74\u9f62\u3092\u7b54\u3048\u3066\u3082\u3089\u3063\u3066\u3044\u308b\u306e\u3067\u300110\u6b73\u533a\u5207\u308a\u306b\u3057\u3066\u304b\u3089\u96c6\u8a08\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u53c2\u8003\uff1aifs\u95a2\u6570\uff08https:\/\/support.google.com\/docs\/table\/25273?hl=ja#query=ifs\uff09<br>\u4eee\u306b\u5b9f\u969b\u306e\u5e74\u9f62\u306e\u5165\u3063\u305f\u5217\u3092D\u30011\u884c\u76ee\u306b\u5909\u6570\u540d\u304c\u5165\u3063\u3066\u3044\u308b\uff082\u884c\u76ee\u304b\u3089\u30c7\u30fc\u30bf\u304c\u59cb\u307e\u3063\u3066\u3044\u308b\uff09\u3068\u3059\u308b\u3068\u3001<br>E\u5217\u306b\u65b0\u3057\u3044\u5217\u3092\u4f5c\u3063\u3066\u300c\u5e74\u9f62\uff0810\uff09\u300d\u306a\u3069\u3068\u3057\u3001E2\u306b\u306f<br>=IFS(D2&gt;=80,8,D2&gt;=70,7,D2&gt;=60,6,D2&gt;=50,5,D2&gt;=40,4,D2&gt;=30,3,D2&gt;=20,2,D2&gt;=10,1,TRUE,999)<br>\u3068\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u3053\u308c\u306f\u3001\u300cD2\uff08E2\u306e\u81ea\u5206\u306e\u3059\u3050\u5de6\u96a3\uff09\u304c80\u4ee5\u4e0a\u306a\u3089\u30708\u300180\u4ee5\u4e0a\u3067\u306a\u304f70\u4ee5\u4e0a\u306a\u30897\u3001\u305d\u3046\u3067\u306a\u3051\u308c\u30706\u3001\u305d\u3046\u3067\u306a\u3051\u308c\u30705\u2026\u300d\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002<br>\u300cx\u4ee5\u4e0a\u306e\u5834\u5408\u306f\u2026\u300d\u3068\u3044\u3046\u5224\u5b9a\u65b9\u6cd5\u306a\u306e\u3067\u3001\u7a7a\u6b04\u304c80\u3068\u5224\u5b9a\u3055\u308c\u308b\u5371\u967a\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3089\u3001ISBLANK\u3068\u3044\u3046\u5224\u5b9a\u306f\u66f8\u3044\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\uff3b\u633f\u5165\uff3d\u2015\uff3b\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\uff3d<br>\u300c\u5217\u300d\u306b\u300c\u8ffd\u52a0\u300d\u3067\u300c\uff08\u6295\u7968\u53c2\u52a0\u306e\u6709\u7121\u306e\u5909\u6570\u540d\uff09\u300d<br>\u300c\u884c\u300d\u306b\u300c\u8ffd\u52a0\u300d\u3067\u300c\uff08\u5e74\u9f6210\uff09\u300d<br>\u300c\u5024\u300d\u306b\u300c\u8ffd\u52a0\u300d\u3067\u300c\uff08ID\uff09\u300d\u3068\u3057\u3001\u300c\u96c6\u8a08\u300d\u304b\u3089\u300cCOUNT\u300d\u3092\u9078\u629e<br>\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u3053\u308c\u3067\u3082\u898b\u306b\u304f\u3044\u3067\u3059\u306d\u3002<br>\u76f4\u611f\u7684\u306b\u5224\u65ad\u3067\u304d\u308b\u306e\u306f\u9811\u5f35\u3063\u3066\u30825\u884cx5\u5217\u304f\u3089\u3044\u304c\u9650\u754c\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<br>\u5c11\u3057\u5206\u3051\u65b9\u3092\u5909\u3048\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u73fe\u5728\u3001\u82e5\u3044\u4eba\u305f\u3061\uff08\u300c\u82e5\u5e74\u5c64\u300d\uff09\u306e\u6295\u7968\u7387\u304c\u4ed6\u306e\u4e16\u4ee3\u306b\u6bd4\u3079\u3066\u4f4e\u3044\u3053\u3068\u304c\u554f\u984c\u306b\u306a\u3063\u3066\u3044\u307e\u3059\uff08\u305d\u306e\u7d50\u679c\u3001\u9078\u6319\u306b\u884c\u304f\u5e74\u914d\u306e\u4eba\u305f\u3061\u306e\u58f0\u3070\u304b\u308a\u304c\u53d6\u308a\u4e0a\u3052\u3089\u308c\u3066\u3044\u308b\u3068\u3044\u3046\u610f\u5473\u3067\u300c\u30b7\u30eb\u30d0\u30fc\u6c11\u4e3b\u4e3b\u7fa9\u300d\u3068\u554f\u984c\u8996\u3059\u308b\u58f0\u3082\u3042\u308a\u307e\u3059\uff09\u3002<br>\u3053\u3053\u3067\u300c\u82e5\u5e74\u5c64\u300d\u3068\u547c\u3070\u308c\u3066\u3044\u308b\u306e\u306f30\u6b73\u4ee3\u307e\u3067\uff08\uff01\uff09\u306a\u306e\u3067\u3001\u300c39\u6b73\u4ee5\u4e0b\u300d40\u304b\u308964\u6b73\uff08\u300c\u751f\u7523\u5e74\u9f62\u4eba\u53e3\u300d\u304c64\u6b73\u307e\u3067\u3067\u3059\uff09\u3001\u300c65\u6b73\u4ee5\u4e0a\u300d\u306e3\u3064\u306b\u5206\u3051\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u624b\u9806<br>\u300c\u5e74\u9f62\uff0810\uff09\u300d\u306e\u6a2a\u306e\u5217\uff08\u9055\u3063\u3066\u3082\u3088\u3044\uff09\u306b\u5217\u3092\u633f\u5165\u3057\u300c\u5e74\u9f62\uff083\u533a\u5206\uff09\u300d\u3068\u3059\u308b\u3002<br>=IFS(D2&gt;=65,3,D2&gt;=40,2,D2&gt;=18,1)<\/p>\n\n\n\n<p>\u3055\u3042\u3001\u3053\u306e\u300c\u5e74\u9f62\uff083\u533a\u5206\uff09\u300d\u3068\u300c\u6295\u7968\u53c2\u52a0\u306e\u6709\u7121\u300d\u3068\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u305d\u308c\u305e\u308c\u306e\u5e74\u9f62\u533a\u5206\u306e\u4eba\u53e3\u304c\u9055\u3046\u306e\u3067\u308f\u304b\u308a\u306b\u304f\u3044\u3067\u3059\u306d\u3002<br>\u4eca\u77e5\u308a\u305f\u3044\u306e\u306f\u3001\u5e74\u9f62\u533a\u5206\u306b\u3088\u3063\u3066\u6295\u7968\u7387\u306b\u5dee\u304c\u3042\u308b\u306e\u304b\u3001\u3067\u3059\u304b\u3089\u3001\u305d\u308c\u305e\u308c\u306e\u5e74\u9f62\u533a\u5206\u3054\u3068\u306b\u6295\u7968\u7387\u3092\u8a08\u7b97\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u6295\u7968\u7387\uff1d\u6295\u7968\u3057\u305f\u4eba\u306e\u6570\uff0f\u3059\u3079\u3066\u306e\u6570\uff08\u4eca\u306f\u5e74\u9f62\u533a\u5206\u306e\u8a72\u5f53\u8005\u6570\uff09<br>\u3067\u3059\u306d\u3002<br>\u3055\u3066\u3001\u3069\u3046\u3067\u3057\u305f\u304b\uff1f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u3059\u309d\u3081 \u30c7\u30fc\u30bf\u3092\u5206\u6790\u3059\u308b\u3068\u304d\u306b\u306f\u3001\u300cGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u300d\u306e\uff3b\u633f\u5165\uff3d\u30e1\u30cb\u30e5\u30fc\u306b\u3042\u308b\uff3b\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\uff3d\u3092\u4f7f\u3044\u307e\u3057\u3087\u3046\u3002\u3053\u306e\u3053\u3068\u3092\u3001\uff3b\u633f\u5165\uff3d\u2015\uff3b\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\uff3d\u3092\u4f7f\u3044\u307e\u3057\u3087\u3046\u3001\u3068\u66f8\u304d\u307e\u3059\u3002 \u306f\u3058 [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"parent":2812,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2787","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/pages\/2787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2787"}],"version-history":[{"count":3,"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/pages\/2787\/revisions"}],"predecessor-version":[{"id":3349,"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/pages\/2787\/revisions\/3349"}],"up":[{"embeddable":true,"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=\/wp\/v2\/pages\/2812"}],"wp:attachment":[{"href":"http:\/\/cibik.think-mate.gr.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}