{"id":1268,"date":"2015-04-12T15:32:17","date_gmt":"2015-04-12T06:32:17","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=1268"},"modified":"2015-04-12T15:32:17","modified_gmt":"2015-04-12T06:32:17","slug":"arithmetic_operator","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/arithmetic_operator\/","title":{"rendered":"VBA \u306e\u6f14\u7b97\u5b50\uff08\u7b97\u8853\u6f14\u7b97\u5b50\uff09"},"content":{"rendered":"

\u7b97\u8853\u6f14\u7b97\u5b50<\/h2>\n
\n

\u7b97\u8853\u6f14\u7b97\u3092\u884c\u3046\u3068\u304d\u306b\u4f7f\u7528\u3059\u308b\u6f14\u7b97\u5b50\u3067\u3059\u3002
\n ^\uff08\u3079\u304d\u4e57\uff09\u3001*\uff08\u7a4d\uff09\u3001\/\uff08\u5546\uff09\u3001\\\uff08\u5546\uff09\u3001+\uff08\u548c\uff09\u3001-\uff08\u5dee\uff09\u3001Mod\uff08\u5270\u4f59\uff09<\/p>\n
<\/div>\n

^ \u6f14\u7b97\u5b50<\/h2>\n
\n

\u6570\u5024\u306e\u3079\u304d\u4e57\u3092\u6c42\u3081\u307e\u3059<\/p>\n

\u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

result<\/em> = number<\/em> ^<\/strong> exponent<\/em><\/p>\n<\/div>\n
\n

\u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
    \n
  • number  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
  • exponent  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
  • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n
    \n

    1 \u3064\u306e\u5f0f\u306e\u4e2d\u3067\u8907\u6570\u306e\u6307\u6570\u6f14\u7b97\u304c\u884c\u308f\u308c\u308b\u3068\u304d\u306f\u3001^ \u6f14\u7b97\u5b50<\/strong>\u306f\u5de6\u304b\u3089\u53f3\u306e\u9806\u306b\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002<\/p>\n

    number<\/em> \u307e\u305f\u306f exponent<\/em> \u306e\u3044\u305a\u308c\u304b\u304c Null \u5024<\/strong>\u306b\u8a55\u4fa1\u3055\u308c\u308b\u5f0f\u306e\u3068\u304d\u306f\u3001\u6f14\u7b97\u7d50\u679c result<\/em> \u3082 Null \u5024<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n\n

    * \u6f14\u7b97\u5b50<\/h2>\n
    \n

    \u6570\u5024\u306e\u7a4d\u3092\u6c42\u3081\u307e\u3059<\/p>\n

    \u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

    result<\/em> = number1<\/em> *<\/strong> number2<\/em><\/p>\n<\/div>\n
    \n

    \u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
      \n
    • number1,number2  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
    • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n<\/ul>\n
      \n

      \u4e00\u65b9\u307e\u305f\u306f\u4e21\u65b9\u306e\u5f0f\u304c Null \u5024<\/strong>\u306e\u3068\u304d\u3001result<\/em> \u306f Null \u5024<\/strong>\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

      Empty \u5024<\/strong>\u3092\u6301\u3064\u5f0f\u306f\u30010 \u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002<\/p>\n
      <\/div>\n

      \/ \u6f14\u7b97\u5b50<\/h2>\n
      \n

      \uff12\u3064\u306e\u6570\u5024\u306e\u5546\u3092\u6c42\u3081\u307e\u3059<\/p>\n

      \u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

      result<\/em> = number1<\/em> \/<\/strong> number2<\/em><\/p>\n<\/div>\n
      \n

      \u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
        \n
      • number1  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
      • number2  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
      • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n
        \n

        \u6f14\u7b97\u7d50\u679c\uff08 result<\/em> \uff09\u306e\u30c7\u30fc\u30bf\u578b\u306f\u3001\u901a\u5e38\u306f\u500d\u7cbe\u5ea6\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570\u578b\uff08 Double \uff09\u307e\u305f\u306f\u5185\u90e8\u51e6\u7406\u5f62\u5f0f\u304c\u500d\u7cbe\u5ea6\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570\u578b\u306e\u30d0\u30ea\u30a2\u30f3\u30c8\u578b\uff08 Variant \uff09\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

        number1<\/em> \u307e\u305f\u306f number2<\/em> \u306e\u3044\u305a\u308c\u304b\u3001\u307e\u305f\u306f\u305d\u306e\u4e21\u65b9\u304c\u3001Null \u5024<\/strong>\u306b\u8a55\u4fa1\u3055\u308c\u308b\u5f0f\u306e\u3068\u304d\u306f\u3001\u6f14\u7b97\u7d50\u679c result<\/em> \u3082 Null \u5024<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

        Empty \u5024<\/strong> \u3092\u6301\u3064\u5f0f\u306f\u30010 \u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002<\/p>\n
        <\/div>\n

        \\ \u6f14\u7b97\u5b50<\/h2>\n
        \n

        \uff12\u3064\u306e\u6570\u5024\u306e\u5546\u3092\u6c42\u3081\u307e\u3059\uff08\u7d50\u679c\u306f\u6574\u6570\uff09<\/p>\n

        \u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

        result<\/em> = number1<\/em> \\<\/strong> number2<\/em><\/p>\n<\/div>\n
        \n

        \u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
          \n
        • number1  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
        • number2  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
        • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n
          \n

          \u6f14\u7b97\u7d50\u679c\uff08 result<\/em> \uff09\u306f\u3001\u6574\u6570\u3068\u306a\u308a\u307e\u3059\uff08\u5c0f\u6570\u90e8\u5206\u306f\u5207\u308a\u6368\u3066\uff09\u3002<\/p>\n

          number1<\/em> \u307e\u305f\u306f number2<\/em> \u306e\u3044\u305a\u308c\u304b\u3001\u307e\u305f\u306f\u305d\u306e\u4e21\u65b9\u304c\u3001Null \u5024<\/strong>\u306b\u8a55\u4fa1\u3055\u308c\u308b\u5f0f\u306e\u3068\u304d\u306f\u3001\u6f14\u7b97\u7d50\u679c result<\/em> \u3082 Null \u5024<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

          Empty \u5024<\/strong> \u3092\u6301\u3064\u5f0f\u306f\u30010 \u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002<\/p>\n
          <\/div>\n

          + \u6f14\u7b97\u5b50<\/h2>\n
          \n

          \uff12\u3064\u306e\u6570\u5024\u306e\u548c\u3092\u6c42\u3081\u307e\u3059<\/p>\n

          \u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

          result<\/em> = expression1<\/em> +<\/strong> expression2<\/em><\/p>\n<\/div>\n
          \n

          \u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
            \n
          • expression1  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
          • expression2  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
          • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n
            \n

            expression1<\/em> \u307e\u305f\u306f expression2<\/em> \u306e\u3044\u305a\u308c\u304b\u3001\u307e\u305f\u306f\u305d\u306e\u4e21\u65b9\u304c\u3001Null \u5024<\/strong>\u306b\u8a55\u4fa1\u3055\u308c\u308b\u5f0f\u306e\u3068\u304d\u306f\u3001\u6f14\u7b97\u7d50\u679c result<\/em> \u3082 Null \u5024<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

            \u4e21\u65b9\u306e\u5f0f\u304c Empty \u5024<\/strong> \u3092\u6301\u3064\u5834\u5408\u3001result<\/em> \u306f\u6574\u6570\u578b\u3068\u306a\u308a\u307e\u3059\u3002\u4e00\u65b9\u306e\u5f0f\u306e\u307f\u304c Empty \u5024<\/strong> \u306e\u5834\u5408\u3001\u4ed6\u65b9\u306e\u5f0f\u304c\u305d\u306e\u307e\u307e result<\/em> \u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

            expression1<\/em> \u3001expression2<\/em> \u306e\u4e21\u65b9\u304c\u3001\u6587\u5b57\u5217\u578b\uff08 String \uff09\u3001\u307e\u305f\u306f\u3001\u4e00\u65b9\u304c\u6587\u5b57\u5217\u578b\u3067\u4ed6\u65b9\u304c\u30d0\u30ea\u30a2\u30f3\u30c8\u578b\uff08 Variant \uff09\u3001\u307e\u305f\u4e21\u65b9\u304c\u30d0\u30ea\u30a2\u30f3\u30c8\u578b\u3067\u4e21\u65b9\u306e\u5185\u90e8\u51e6\u7406\u5f62\u5f0f\u304c\u6587\u5b57\u5217\u578b\u306e\u5834\u5408\u306b\u884c\u308f\u308c\u308b\u6f14\u7b97\u65b9\u6cd5\u306f\u3001\u300c\u6587\u5b57\u9023\u7d50<\/strong>\u300d\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n
            <\/div>\n

            – \u6f14\u7b97\u5b50<\/h2>\n
            \n

            \u6570\u5024\u306e\u3079\u304d\u4e57\u3092\u6c42\u3081\u307e\u3059<\/p>\n

            \u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

            result<\/em> = number1<\/em> –<\/strong> number2<\/em><\/p>\n<\/div>\n
            \n

            \u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
              \n
            • number1  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
            • number2  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
            • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n
              \n

              number1<\/em> \u307e\u305f\u306f number2<\/em> \u306e\u3044\u305a\u308c\u304b\u3001\u307e\u305f\u306f\u305d\u306e\u4e21\u65b9\u304c\u3001Null \u5024<\/strong>\u306b\u8a55\u4fa1\u3055\u308c\u308b\u5f0f\u306e\u3068\u304d\u306f\u3001\u6f14\u7b97\u7d50\u679c result<\/em> \u3082 Null \u5024<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

              Empty \u5024<\/strong> \u3092\u6301\u3064\u5f0f\u306f\u30010 \u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002<\/p>\n

              \n
              <\/div>\n

              Mod \u6f14\u7b97\u5b50<\/h2>\n
              \n

              2 \u3064\u306e\u6570\u5024\u306e\u9664\u7b97\u3092\u884c\u3044\u3001\u305d\u306e\u5270\u4f59\u3092\u8fd4\u3057\u307e\u3059<\/p>\n

              \u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

              result<\/em> = number1<\/em> Mod<\/strong> number2<\/em><\/p>\n<\/div>\n
              \n

              \u9805\u76ee\u306e\u8aac\u660e<\/h3>\n
                \n
              • number1  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
              • number2  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u30fb\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n
              • result  \u30fb\u30fb\u30fb  \u4efb\u610f\u306e\u6570\u5024\u5909\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n
                \n

                result<\/em> \u306f\u3001number1<\/em> \u3092 number2<\/em> \u3067\u9664\u7b97\u3057\u305f\u6642\u306e\u4f59\u308a\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

                number1<\/em> \u307e\u305f\u306f number2<\/em> \u306e\u3044\u305a\u308c\u304b\u3001\u307e\u305f\u306f\u305d\u306e\u4e21\u65b9\u304c\u3001Null \u5024<\/strong>\u306b\u8a55\u4fa1\u3055\u308c\u308b\u5f0f\u306e\u3068\u304d\u306f\u3001\u6f14\u7b97\u7d50\u679c result<\/em> \u3082 Null \u5024<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

                Empty \u5024<\/strong> \u3092\u6301\u3064\u5f0f\u306f\u30010 \u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002<\/p>\n

                \u6570\u5f0f\uff08 number1<\/em>\u3001number2<\/em> \uff09\u306e\u4e2d\u306e\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570\u306f\u6574\u6570\u306b\u4e38\u3081\u3089\u308c\u307e\u3059\u3002
                \n\u3000\u3000\uff08\u4f8b\uff09result = 10 mod 3.5<\/strong>
                \n\u306e result<\/strong> \u306f\u3001\u300c2\u300d\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
                <\/div>\n

                \n","protected":false},"excerpt":{"rendered":"

                \u7b97\u8853\u6f14\u7b97\u5b50 \u7b97\u8853\u6f14\u7b97\u3092\u884c\u3046\u3068\u304d\u306b\u4f7f\u7528\u3059\u308b\u6f14\u7b97\u5b50\u3067\u3059\u3002 ^\uff08\u3079\u304d\u4e57\uff09\u3001*\uff08\u7a4d\uff09\u3001\/ … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":"\u30d6\u30ed\u30b0\u3092\u66f4\u65b0\u3057\u307e\u3057\u305f\uff01"},"categories":[37],"tags":[102,63,38,101],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Ye9i-ks","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/1268"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=1268"}],"version-history":[{"count":13,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/1268\/revisions"}],"predecessor-version":[{"id":1281,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/1268\/revisions\/1281"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=1268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=1268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=1268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}