{"id":246,"date":"2015-02-07T23:18:36","date_gmt":"2015-02-07T14:18:36","guid":{"rendered":"https:\/\/sparrow9630.net\/?p=246"},"modified":"2015-02-07T23:18:36","modified_gmt":"2015-02-07T14:18:36","slug":"if%e9%96%a2%e6%95%b0%e3%82%92%e5%88%a9%e7%94%a8%e3%81%97%e3%81%a6%e3%80%8cture%e3%80%8d%e3%80%8cfalse%e3%80%8d%e3%82%92%e3%82%8f%e3%81%8b%e3%82%8a%e3%82%84%e3%81%99%e3%81%8f%e8%a1%a8%e7%a4%ba","status":"publish","type":"post","link":"https:\/\/sparrow9630.net\/?p=246","title":{"rendered":"IF\u95a2\u6570\u3092\u5229\u7528\u3057\u3066\u300cTURE\u300d\u300cFALSE\u300d\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u8868\u793a"},"content":{"rendered":"

IF\u95a2\u6570\u3092\u4f7f\u3046\u4e8b\u3067\u3001\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u3067\u304d\u308b\u3002<\/p>\n

\u8ad6\u7406\u5f0f<\/strong>
NOT(A=12)
\u771f\u306e\u5024<\/strong>
“12\u3068\u540c\u3058”
\u507d\u306e\u5024<\/strong>
“12\u3068\u9055\u3046”<\/p>\n

\u5f0f\u306b\u3059\u308b\u3068
=IF(NOT(A=12),”12\u3068\u540c\u3058”,”12\u3068\u9055\u3046”)<\/span>
[\u7d50\u679c]
(A)
12 \u3000\u300012\u3068\u9055\u3046
12 \u3000\u300012\u3068\u9055\u3046
23 \u3000\u300012\u3068\u540c\u3058
25 \u3000\u300012\u3068\u540c\u3058<\/p>\n

NOT\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u7d50\u679c\u304c\u9006\u306b\u306a\u308b\uff01<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jin_ogp_image_url":"","_jin_last_featured_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[24],"tags":[],"class_list":["post-246","post","type-post","status-publish","format-standard","hentry","category-excel"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":245,"url":"https:\/\/sparrow9630.net\/?p=245","url_meta":{"origin":246,"position":0},"title":"NOT\u95a2\u6570","author":"sparrow9630","date":"2015-02-07","format":false,"excerpt":"","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/sparrow9630.net\/?cat=24"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":242,"url":"https:\/\/sparrow9630.net\/?p=242","url_meta":{"origin":246,"position":1},"title":"\u95a2\u6570\u5f0f\u306e\u57fa\u672c\u3068\u306a\u308b\u7406\u8ad6\u5024","author":"sparrow9630","date":"2015-02-07","format":false,"excerpt":"","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/sparrow9630.net\/?cat=24"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1012,"url":"https:\/\/sparrow9630.net\/?p=1012","url_meta":{"origin":246,"position":2},"title":"IF\u95a2\u6570","author":"sparrow9630","date":"2018-05-01","format":false,"excerpt":"","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/sparrow9630.net\/?cat=24"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1013,"url":"https:\/\/sparrow9630.net\/?p=1013","url_meta":{"origin":246,"position":3},"title":"SUM\u95a2\u6570","author":"sparrow9630","date":"2018-05-01","format":false,"excerpt":"","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/sparrow9630.net\/?cat=24"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":244,"url":"https:\/\/sparrow9630.net\/?p=244","url_meta":{"origin":246,"position":4},"title":"OR\u95a2\u6570","author":"sparrow9630","date":"2015-02-07","format":false,"excerpt":"","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/sparrow9630.net\/?cat=24"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":243,"url":"https:\/\/sparrow9630.net\/?p=243","url_meta":{"origin":246,"position":5},"title":"AND\u95a2\u6570","author":"sparrow9630","date":"2015-02-07","format":false,"excerpt":"","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/sparrow9630.net\/?cat=24"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sparrow9630.net\/index.php?rest_route=\/wp\/v2\/posts\/246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sparrow9630.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sparrow9630.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sparrow9630.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sparrow9630.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=246"}],"version-history":[{"count":0,"href":"https:\/\/sparrow9630.net\/index.php?rest_route=\/wp\/v2\/posts\/246\/revisions"}],"wp:attachment":[{"href":"https:\/\/sparrow9630.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sparrow9630.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sparrow9630.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}