{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kei1959871/20240526/20240526204113.png","published":"2024-05-26 20:47:29","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkeiex.hatenablog.com%2Fentry%2F2024%2F05%2F26%2F204729\" title=\"\u6570\u5b57\u3092\u5207\u308a\u3088\u304f\u6574\u7406\u3059\u308b\u3000(\u5207\u308a\u4e0a\u3052\u308b/\u5207\u308a\u4e0b\u3052\u308b) - \u30b3\u30d4\u30da\u3067\u7c21\u5358\uff01\u4ed5\u4e8b\u3067\u4f7f\u3048\u308b\uff01\u30a8\u30af\u30bb\u30eb\u4fbf\u5229\u30b9\u30ad\u30eb\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","blog_url":"https://keiex.hatenablog.com/","provider_name":"Hatena Blog","blog_title":"\u30b3\u30d4\u30da\u3067\u7c21\u5358\uff01\u4ed5\u4e8b\u3067\u4f7f\u3048\u308b\uff01\u30a8\u30af\u30bb\u30eb\u4fbf\u5229\u30b9\u30ad\u30eb","type":"rich","title":"\u6570\u5b57\u3092\u5207\u308a\u3088\u304f\u6574\u7406\u3059\u308b\u3000(\u5207\u308a\u4e0a\u3052\u308b/\u5207\u308a\u4e0b\u3052\u308b)","author_name":"kei1959871","description":"\u3069\u3093\u306a\u6642\u306b\u4f7f\u3048\u308b\uff1f \u5165\u529b\u3055\u308c\u305f\u6570\u5024\u3092\u5207\u308a\u304c\u3088\u3044\u6570\u5024\u306b\u306a\u308b\u3088\u3046\u306b\u300c\u5207\u308a\u4e0a\u3052/\u5207\u308a\u4e0b\u3052\u300d\u3059\u308b (10, 50, 100, 1000\u5358\u4f4d\u306a\u3069) \u5207\u308a\u4e0b\u3052\u306e\u5834\u5408 \uff1aFLOOR.MATH\u95a2\u6570 \u5207\u308a\u4e0a\u3052\u306e\u5834\u5408 \uff1aCEILING.MATH\u95a2\u6570 \u8fd1\u3044\u65b9\u5411\u306b\u307e\u3068\u3081\u308b\u5834\u5408\uff1aMROUND\u95a2\u6570 \u4f8b\uff1a\u300c50\u300d\u306e\u5358\u4f4d\u3067\u5207\u308a\u4e0b\u3052 (FLOOR.MATH\u95a2\u6570\u306e\u5834\u5408) \u2460C2\u30bb\u30eb\u306b\u300c=FLOOR.MATH(B2,50)\u300d\u3092\u5165\u529b \uff08\u8a73\u7d30\u306f\u4ee5\u4e0b\u30dd\u30a4\u30f3\u30c8\u53c2\u7167\uff09 \u2461\u5fc5\u8981\u306a\u30bb\u30eb\u307e\u3067\u30b3\u30d4\u30fc\uff06\u30da\u30fc\u30b9\u30c8 \u30dd\u30a4\u30f3\u30c8 \u30fb\u300cFLOOR.MATH\u95a2\u6570\u300d\u300cCEILING.MATH\u95a2\u6570\u300d\u300cMROUND\u95a2\u6570\u300d\u3092\u6d3b\u7528\u3059\u308b \u3053\u3068\u3067\u3001\u300c\u3042\u308b\u6570\u5024\u306e\u5358\u4f4d\u300d\u3067\u5207\u308a\u4e0b\u3052\u2026","width":"100%","categories":["\u30ea\u30b9\u30c8","\u30c7\u30fc\u30bf\u96c6\u8a08"],"author_url":"https://blog.hatena.ne.jp/kei1959871/","url":"https://keiex.hatenablog.com/entry/2024/05/26/204729","version":"1.0","height":"190"}