{"author_url":"https://blog.hatena.ne.jp/dz_dzone/","url":"https://dz11.hatenadiary.jp/entry/2020/05/08/130132","blog_url":"https://dz11.hatenadiary.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdz11.hatenadiary.jp%2Fentry%2F2020%2F05%2F08%2F130132\" title=\"Excel\u3084\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u65e5\u4ed8\u304b\u3089\u6d88\u8cbb\u7a0e\u7387\u3092\u6c42\u3081\u308b\u6570\u5f0f - \u65e5\u672c\u8a9e\u5165\u529b\u30bd\u30d5\u30c8\u3068VBA\u306e\u899a\u3048\u66f8\u304d\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"dz_dzone","provider_url":"https://hatena.blog","published":"2020-05-08 13:01:32","blog_title":"\u65e5\u672c\u8a9e\u5165\u529b\u30bd\u30d5\u30c8\u3068VBA\u306e\u899a\u3048\u66f8\u304d","description":"\u306f\u3058\u3081\u306b Excel\u3084Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306a\u3069\u3067\u65e5\u4ed8\u3092\u8868\u3059\u30bb\u30eb\u304b\u3089\u6d88\u8cbb\u7a0e\u7387\u3092\u6c42\u3081\u307e\u3059\u3002 \u6570\u5f0f IF\u95a2\u6570\uff1aExcel, Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306a\u3069\u6c4e\u7528 \u53c2\u7167\u30bb\u30eb\uff1aA1 A1\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\uff1a\u65e5\u4ed8 =IF(A1>=43586,0.1,IF(A1>=41730,0.08,IF(A1>=35521,0.05,IF(A1>=32599,0.03,0)))) IFS\u95a2\u6570\uff1aExcel 365, Excel 2019\uff5e, Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306a\u3069 \u53c2\u7167\u30bb\u30eb\uff1aA1 A1\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\uff1a\u65e5\u4ed8 =IFS(A1>=43586,0.1,A1>=41730,0.08,A1>=35521,0.05,A1\u2026","width":"100%","image_url":null,"provider_name":"Hatena Blog","height":"190","version":"1.0","categories":["Excel","\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8"],"type":"rich","title":"Excel\u3084\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u65e5\u4ed8\u304b\u3089\u6d88\u8cbb\u7a0e\u7387\u3092\u6c42\u3081\u308b\u6570\u5f0f"}