{"id":1415,"date":"2026-05-03T23:00:00","date_gmt":"2026-05-03T14:00:00","guid":{"rendered":"https:\/\/shtincircle.com\/?p=1415"},"modified":"2026-05-04T11:44:04","modified_gmt":"2026-05-04T02:44:04","slug":"if%e3%81%97%e3%82%8a%e3%83%bc%e3%81%9a","status":"publish","type":"post","link":"https:\/\/shtincircle.com\/?p=1415","title":{"rendered":"IF\u3057\u308a\u30fc\u305a"},"content":{"rendered":"\n<div class=\"wp-block-math\"><math display=\"block\"><semantics><mrow><mo>=<\/mo><mi>I<\/mi><mi>F<\/mi><mo form=\"prefix\" stretchy=\"false\">(<\/mo><mtext>\u8ad6<\/mtext><mtext>\u7406<\/mtext><mtext>\u5f0f<\/mtext><mo separator=\"true\">,<\/mo><mtext>\u771f<\/mtext><mtext>\u306e<\/mtext><mtext>\u5834<\/mtext><mtext>\u5408<\/mtext><mo separator=\"true\">,<\/mo><mtext>\u507d<\/mtext><mtext>\u306e<\/mtext><mtext>\u5834<\/mtext><mtext>\u5408<\/mtext><mo form=\"postfix\" stretchy=\"false\">)<\/mo><\/mrow><annotation encoding=\"application\/x-tex\">=IF(\u8ad6\u7406\u5f0f, \u771f\u306e\u5834\u5408, \u507d\u306e\u5834\u5408)<\/annotation><\/semantics><\/math><\/div>\n\n\n\n<p>\u6761\u4ef6\uff08A1\uff1d\u4e03\u702c\u5bb6,&#8221;\u3007&#8221;,&#8221;\u2715&#8221;\uff09<br>\u6761\u4ef6\u306b\u4e00\u81f4 \u3059 \u308b\u5834\u5408\uff1a \u6761\u4ef6\u304c\u6b63\u3057\u3044\uff08TRUE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u3007<br>\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\uff1a \u6761\u4ef6\u304c\u9593\u9055\u3063\u3066\u3044\u308b\uff08FALSE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u2715<\/p>\n\n\n\n<p>\u5c11\u6570\u306e\u6642\u306f\u3053\u3063\u3061\u304c\u3044\u3044<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-text-align-center\"><math data-latex=\"=IFS(\u8ad6\u7406\u5f0f1, \u50241, [\u8ad6\u7406\u5f0f2, \u50242], ...)\"><semantics><mrow><mo>=<\/mo><mi>I<\/mi><mi>F<\/mi><mi>S<\/mi><mo form=\"prefix\" stretchy=\"false\">(<\/mo><mtext>\u8ad6<\/mtext><mtext>\u7406<\/mtext><mtext>\u5f0f<\/mtext><mn>1<\/mn><mo separator=\"true\">,<\/mo><mtext>\u5024<\/mtext><mn>1<\/mn><mo separator=\"true\">,<\/mo><mo form=\"prefix\" stretchy=\"false\">[<\/mo><mtext>\u8ad6<\/mtext><mtext>\u7406<\/mtext><mtext>\u5f0f<\/mtext><mn>2<\/mn><mo separator=\"true\">,<\/mo><mtext>\u5024<\/mtext><mn>2<\/mn><mo form=\"postfix\" stretchy=\"false\">]<\/mo><mo separator=\"true\">,<\/mo><mi>.<\/mi><mi>.<\/mi><mi>.<\/mi><mo form=\"postfix\" stretchy=\"false\">)<\/mo><\/mrow><annotation encoding=\"application\/x-tex\">=IFS(\u8ad6\u7406\u5f0f1, \u50241, [\u8ad6\u7406\u5f0f2, \u50242], &#8230;)<\/annotation><\/semantics><\/math><\/p>\n\n\n\n<p><strong>\u8907\u6570<\/strong>\u306e\u6761\u4ef6\u3092\u9806\u756a\u306b\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u6700\u521d\u306b\u4e00\u81f4\u3057\u305f\u3082\u306e\u3092\u51fa\u3057\u3066\u304f\u308c\u308b<\/p>\n\n\n\n<p>\u5168\u3066\u306e\u6761\u4ef6\u306b\u5f53\u3066\u306f\u307e\u3089\u306a\u3044\u3068\u304d\u306f\u6700\u5f8c\u306b<\/p>\n\n\n\n<p>TRUE\u201d\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u201d<\/p>\n\n\n\n<p>\u306b\u3059\u308b\u3068\u3044\u3044\u3089\u3057\u3044<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"132\" src=\"https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-172-1.png\" alt=\"\" class=\"wp-image-1420\" srcset=\"https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-172-1.png 555w, https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-172-1-300x71.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>\u5b9f\u969b\u306b\u4f7f\u3063\u305f\u3068\u3053<\/strong><\/p>\n\n\n\n<p><strong>H5\uff1d$C$13,$D$6<\/strong><\/p>\n\n\n\n<p>\u2191\u3053\u308c\u3067\u3072\u3068\u304b\u305f\u307e\u308a\u3002\u3053\u308c\u304c\u5408\u308f\u306a\u3044\u306a\u3089\u3001<\/p>\n\n\n\n<p><strong>H5=$C$15,$D$7<\/strong><\/p>\n\n\n\n<p>\u2191\u305d\u306e\u6b21\u306e\u5f0f\u3067\u691c\u8a3c\u3059\u308b<\/p>\n\n\n\n<p>\u3053\u308c\u306e\u7e70\u308a\u8fd4\u3057<br>\u305f\u304f\u3055\u3093\u306eIF\u304c\u4f7f\u3044\u305f\u3044\u306a\u3089\u3053\u3063\u3061\u304c\u3044\u3044<\/p>\n\n\n\n<p>$C$\u3000\u2190$\u3067\u56f2\u3080\u3068C\u5217\u304b\u3089\u52d5\u304b\u306a\u3044\u3067\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3050\u30fc\u3093\u3067\u304d\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"673\" height=\"132\" src=\"https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-174.png\" alt=\"\" class=\"wp-image-1422\" style=\"width:668px;height:auto\" srcset=\"https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-174.png 673w, https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-174-300x59.png 300w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/figure>\n\n\n\n<p>\u3053\u3053\u306b\u3082\u3042\u3063\u305f<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-math\"><math display=\"block\"><semantics><mrow><mo>=<\/mo><mi>I<\/mi><mi>F<\/mi><mi>E<\/mi><mi>R<\/mi><mi>R<\/mi><mi>O<\/mi><mi>R<\/mi><mo form=\"prefix\" stretchy=\"false\">(<\/mo><mtext>\u5024<\/mtext><mo separator=\"true\">,<\/mo><mtext>\u30a8<\/mtext><mtext>\u30e9<\/mtext><mtext>\u30fc<\/mtext><mtext>\u306e<\/mtext><mtext>\u5834<\/mtext><mtext>\u5408<\/mtext><mtext>\u306e<\/mtext><mtext>\u5024<\/mtext><mo form=\"postfix\" stretchy=\"false\">)<\/mo><\/mrow><annotation encoding=\"application\/x-tex\">=IFERROR(\u5024, \u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024)<\/annotation><\/semantics><\/math><\/div>\n\n\n\n<p>\u5168\u90e8\u5f53\u3066\u306f\u307e\u3089\u306a\u304f\u3066\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u306b\u3001\u30a8\u30e9\u30fc\u306e\u6642\u306b\u51fa\u3059\u5024\u3092\u5165\u308c\u3089\u308c\u308b<\/p>\n\n\n\n<p>\u30a8\u30e9\u30fc\u3067\u308b\u3053\u3068\u3042\u308b\u6642\u306b\u4f7f\u3046\u3068\u826f\u3044<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"211\" src=\"https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-173.png\" alt=\"\" class=\"wp-image-1418\" srcset=\"https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-173.png 582w, https:\/\/shtincircle.com\/wp-content\/uploads\/2026\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-173-300x109.png 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/figure>\n\n\n\n<p><strong>VLOOKUP<\/strong>\u3067\u51fa\u3066\u3053\u306a\u3044\u3068\u304d\u3068\u304b\u306b\u304a\u3059\u3059\u3081<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6761\u4ef6\uff08A1\uff1d\u4e03\u702c\u5bb6,&#8221;\u3007&#8221;,&#8221;\u2715&#8221;\uff09\u6761\u4ef6\u306b\u4e00\u81f4 \u3059 \u308b\u5834\u5408\uff1a \u6761\u4ef6\u304c\u6b63\u3057\u3044\uff08TRUE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u3007\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\uff1a \u6761\u4ef6\u304c\u9593\u9055\u3063\u3066\u3044\u308b\uff08FALSE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u2715 \u5c11\u6570\u306e\u6642\u306f\u3053\u3063\u3061\u304c\u3044\u3044 =IFS(\u8ad6\u7406\u5f0f1,\u50241,[\u8ad6\u7406\u5f0f2,\u50242],&#8230;)=IFS(\u8ad6\u7406\u5f0f1, \u50241, [\u8ad6\u7406\u5f0f2, \u50242], &#8230;) \u8907\u6570\u306e\u6761\u4ef6\u3092\u9806\u756a\u306b\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u6700\u521d\u306b\u4e00\u81f4\u3057\u305f\u3082\u306e\u3092\u51fa\u3057\u3066\u304f\u308c\u308b \u5168\u3066\u306e\u6761\u4ef6\u306b\u5f53\u3066\u306f\u307e\u3089\u306a\u3044\u3068\u304d\u306f\u6700\u5f8c\u306b TRUE\u201d\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u201d \u306b\u3059\u308b\u3068\u3044\u3044\u3089\u3057\u3044 \u5b9f\u969b\u306b\u4f7f\u3063\u305f\u3068\u3053 H5\uff1d$C$13,$D$6 \u2191\u3053\u308c\u3067\u3072\u3068\u304b\u305f\u307e\u308a\u3002\u3053\u308c\u304c\u5408\u308f\u306a\u3044\u306a\u3089\u3001 H5=$C$15,$D$7 \u2191\u305d\u306e\u6b21\u306e\u5f0f\u3067\u691c\u8a3c\u3059\u308b \u3053\u308c\u306e\u7e70\u308a\u8fd4\u3057\u305f\u304f\u3055\u3093\u306eIF\u304c\u4f7f\u3044\u305f\u3044\u306a\u3089\u3053\u3063\u3061\u304c\u3044\u3044 $C$\u3000\u2190$\u3067\u56f2\u3080\u3068C\u5217\u304b\u3089\u52d5\u304b\u306a\u3044\u3067\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3050\u30fc\u3093\u3067\u304d\u308b \u3053\u3053\u306b\u3082\u3042\u3063\u305f \u5168\u90e8\u5f53\u3066\u306f\u307e\u3089\u306a\u304f\u3066\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u306b\u3001\u30a8\u30e9\u30fc\u306e\u6642\u306b\u51fa\u3059\u5024\u3092\u5165\u308c\u3089\u308c\u308b \u30a8\u30e9\u30fc\u3067\u308b\u3053\u3068\u3042\u308b\u6642\u306b\u4f7f\u3046\u3068\u826f\u3044 VLOOKUP\u3067\u51fa\u3066\u3053\u306a\u3044\u3068\u304d\u3068\u304b\u306b\u304a\u3059\u3059\u3081<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[26],"class_list":["post-1415","post","type-post","status-publish","format-standard","hentry","category-22","tag-26"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>IF\u3057\u308a\u30fc\u305a - \u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IF\u3057\u308a\u30fc\u305a - \u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061\" \/>\n<meta property=\"og:description\" content=\"\u6761\u4ef6\uff08A1\uff1d\u4e03\u702c\u5bb6,&#8221;\u3007&#8221;,&#8221;\u2715&#8221;\uff09\u6761\u4ef6\u306b\u4e00\u81f4 \u3059 \u308b\u5834\u5408\uff1a \u6761\u4ef6\u304c\u6b63\u3057\u3044\uff08TRUE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u3007\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\uff1a \u6761\u4ef6\u304c\u9593\u9055\u3063\u3066\u3044\u308b\uff08FALSE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u2715 \u5c11\u6570\u306e\u6642\u306f\u3053\u3063\u3061\u304c\u3044\u3044 =IFS(\u8ad6\u7406\u5f0f1,\u50241,[\u8ad6\u7406\u5f0f2,\u50242],...)=IFS(\u8ad6\u7406\u5f0f1, \u50241, [\u8ad6\u7406\u5f0f2, \u50242], &#8230;) \u8907\u6570\u306e\u6761\u4ef6\u3092\u9806\u756a\u306b\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u6700\u521d\u306b\u4e00\u81f4\u3057\u305f\u3082\u306e\u3092\u51fa\u3057\u3066\u304f\u308c\u308b \u5168\u3066\u306e\u6761\u4ef6\u306b\u5f53\u3066\u306f\u307e\u3089\u306a\u3044\u3068\u304d\u306f\u6700\u5f8c\u306b TRUE\u201d\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u201d \u306b\u3059\u308b\u3068\u3044\u3044\u3089\u3057\u3044 \u5b9f\u969b\u306b\u4f7f\u3063\u305f\u3068\u3053 H5\uff1d$C$13,$D$6 \u2191\u3053\u308c\u3067\u3072\u3068\u304b\u305f\u307e\u308a\u3002\u3053\u308c\u304c\u5408\u308f\u306a\u3044\u306a\u3089\u3001 H5=$C$15,$D$7 \u2191\u305d\u306e\u6b21\u306e\u5f0f\u3067\u691c\u8a3c\u3059\u308b \u3053\u308c\u306e\u7e70\u308a\u8fd4\u3057\u305f\u304f\u3055\u3093\u306eIF\u304c\u4f7f\u3044\u305f\u3044\u306a\u3089\u3053\u3063\u3061\u304c\u3044\u3044 $C$\u3000\u2190$\u3067\u56f2\u3080\u3068C\u5217\u304b\u3089\u52d5\u304b\u306a\u3044\u3067\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3050\u30fc\u3093\u3067\u304d\u308b \u3053\u3053\u306b\u3082\u3042\u3063\u305f \u5168\u90e8\u5f53\u3066\u306f\u307e\u3089\u306a\u304f\u3066\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u306b\u3001\u30a8\u30e9\u30fc\u306e\u6642\u306b\u51fa\u3059\u5024\u3092\u5165\u308c\u3089\u308c\u308b \u30a8\u30e9\u30fc\u3067\u308b\u3053\u3068\u3042\u308b\u6642\u306b\u4f7f\u3046\u3068\u826f\u3044 VLOOKUP\u3067\u51fa\u3066\u3053\u306a\u3044\u3068\u304d\u3068\u304b\u306b\u304a\u3059\u3059\u3081\" \/>\n<meta property=\"og:url\" content=\"https:\/\/shtincircle.com\/?p=1415\" \/>\n<meta property=\"og:site_name\" content=\"\u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-03T14:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-04T02:44:04+00:00\" \/>\n<meta name=\"author\" content=\"\u2605\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u2605\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415\"},\"author\":{\"name\":\"\u2605\",\"@id\":\"https:\\\/\\\/shtincircle.com\\\/#\\\/schema\\\/person\\\/4966da3ae34469978fc324cc40580458\"},\"headline\":\"IF\u3057\u308a\u30fc\u305a\",\"datePublished\":\"2026-05-03T14:00:00+00:00\",\"dateModified\":\"2026-05-04T02:44:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415\"},\"wordCount\":30,\"keywords\":[\"\u304a\u3044\u3057\u3044\uff01\"],\"articleSection\":[\"\u307b\u3057\u305e\u3089\u4ead\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415\",\"url\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415\",\"name\":\"IF\u3057\u308a\u30fc\u305a - \u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/shtincircle.com\\\/#website\"},\"datePublished\":\"2026-05-03T14:00:00+00:00\",\"dateModified\":\"2026-05-04T02:44:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/shtincircle.com\\\/#\\\/schema\\\/person\\\/4966da3ae34469978fc324cc40580458\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/shtincircle.com\\\/?p=1415\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/shtincircle.com\\\/?p=1415#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/shtincircle.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IF\u3057\u308a\u30fc\u305a\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/shtincircle.com\\\/#website\",\"url\":\"https:\\\/\\\/shtincircle.com\\\/\",\"name\":\"\u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/shtincircle.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/shtincircle.com\\\/#\\\/schema\\\/person\\\/4966da3ae34469978fc324cc40580458\",\"name\":\"\u2605\",\"sameAs\":[\"https:\\\/\\\/shtincircle.com\"],\"url\":\"https:\\\/\\\/shtincircle.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IF\u3057\u308a\u30fc\u305a - \u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"ja_JP","og_type":"article","og_title":"IF\u3057\u308a\u30fc\u305a - \u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061","og_description":"\u6761\u4ef6\uff08A1\uff1d\u4e03\u702c\u5bb6,&#8221;\u3007&#8221;,&#8221;\u2715&#8221;\uff09\u6761\u4ef6\u306b\u4e00\u81f4 \u3059 \u308b\u5834\u5408\uff1a \u6761\u4ef6\u304c\u6b63\u3057\u3044\uff08TRUE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u3007\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\uff1a \u6761\u4ef6\u304c\u9593\u9055\u3063\u3066\u3044\u308b\uff08FALSE\uff09\u6642\u306b\u8868\u793a\u3059\u308b\u5024\u3001\u2715 \u5c11\u6570\u306e\u6642\u306f\u3053\u3063\u3061\u304c\u3044\u3044 =IFS(\u8ad6\u7406\u5f0f1,\u50241,[\u8ad6\u7406\u5f0f2,\u50242],...)=IFS(\u8ad6\u7406\u5f0f1, \u50241, [\u8ad6\u7406\u5f0f2, \u50242], &#8230;) \u8907\u6570\u306e\u6761\u4ef6\u3092\u9806\u756a\u306b\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u6700\u521d\u306b\u4e00\u81f4\u3057\u305f\u3082\u306e\u3092\u51fa\u3057\u3066\u304f\u308c\u308b \u5168\u3066\u306e\u6761\u4ef6\u306b\u5f53\u3066\u306f\u307e\u3089\u306a\u3044\u3068\u304d\u306f\u6700\u5f8c\u306b TRUE\u201d\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u201d \u306b\u3059\u308b\u3068\u3044\u3044\u3089\u3057\u3044 \u5b9f\u969b\u306b\u4f7f\u3063\u305f\u3068\u3053 H5\uff1d$C$13,$D$6 \u2191\u3053\u308c\u3067\u3072\u3068\u304b\u305f\u307e\u308a\u3002\u3053\u308c\u304c\u5408\u308f\u306a\u3044\u306a\u3089\u3001 H5=$C$15,$D$7 \u2191\u305d\u306e\u6b21\u306e\u5f0f\u3067\u691c\u8a3c\u3059\u308b \u3053\u308c\u306e\u7e70\u308a\u8fd4\u3057\u305f\u304f\u3055\u3093\u306eIF\u304c\u4f7f\u3044\u305f\u3044\u306a\u3089\u3053\u3063\u3061\u304c\u3044\u3044 $C$\u3000\u2190$\u3067\u56f2\u3080\u3068C\u5217\u304b\u3089\u52d5\u304b\u306a\u3044\u3067\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3050\u30fc\u3093\u3067\u304d\u308b \u3053\u3053\u306b\u3082\u3042\u3063\u305f \u5168\u90e8\u5f53\u3066\u306f\u307e\u3089\u306a\u304f\u3066\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u306b\u3001\u30a8\u30e9\u30fc\u306e\u6642\u306b\u51fa\u3059\u5024\u3092\u5165\u308c\u3089\u308c\u308b \u30a8\u30e9\u30fc\u3067\u308b\u3053\u3068\u3042\u308b\u6642\u306b\u4f7f\u3046\u3068\u826f\u3044 VLOOKUP\u3067\u51fa\u3066\u3053\u306a\u3044\u3068\u304d\u3068\u304b\u306b\u304a\u3059\u3059\u3081","og_url":"https:\/\/shtincircle.com\/?p=1415","og_site_name":"\u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061","article_published_time":"2026-05-03T14:00:00+00:00","article_modified_time":"2026-05-04T02:44:04+00:00","author":"\u2605","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"\u2605","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"2\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/shtincircle.com\/?p=1415#article","isPartOf":{"@id":"https:\/\/shtincircle.com\/?p=1415"},"author":{"name":"\u2605","@id":"https:\/\/shtincircle.com\/#\/schema\/person\/4966da3ae34469978fc324cc40580458"},"headline":"IF\u3057\u308a\u30fc\u305a","datePublished":"2026-05-03T14:00:00+00:00","dateModified":"2026-05-04T02:44:04+00:00","mainEntityOfPage":{"@id":"https:\/\/shtincircle.com\/?p=1415"},"wordCount":30,"keywords":["\u304a\u3044\u3057\u3044\uff01"],"articleSection":["\u307b\u3057\u305e\u3089\u4ead"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/shtincircle.com\/?p=1415","url":"https:\/\/shtincircle.com\/?p=1415","name":"IF\u3057\u308a\u30fc\u305a - \u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061","isPartOf":{"@id":"https:\/\/shtincircle.com\/#website"},"datePublished":"2026-05-03T14:00:00+00:00","dateModified":"2026-05-04T02:44:04+00:00","author":{"@id":"https:\/\/shtincircle.com\/#\/schema\/person\/4966da3ae34469978fc324cc40580458"},"breadcrumb":{"@id":"https:\/\/shtincircle.com\/?p=1415#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/shtincircle.com\/?p=1415"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/shtincircle.com\/?p=1415#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/shtincircle.com\/"},{"@type":"ListItem","position":2,"name":"IF\u3057\u308a\u30fc\u305a"}]},{"@type":"WebSite","@id":"https:\/\/shtincircle.com\/#website","url":"https:\/\/shtincircle.com\/","name":"\u3057\u3042\u308f\u305b\u306b\u306a\u308b\u3063\u3061","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/shtincircle.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/shtincircle.com\/#\/schema\/person\/4966da3ae34469978fc324cc40580458","name":"\u2605","sameAs":["https:\/\/shtincircle.com"],"url":"https:\/\/shtincircle.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/shtincircle.com\/index.php?rest_route=\/wp\/v2\/posts\/1415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shtincircle.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shtincircle.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shtincircle.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shtincircle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1415"}],"version-history":[{"count":4,"href":"https:\/\/shtincircle.com\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions"}],"predecessor-version":[{"id":1423,"href":"https:\/\/shtincircle.com\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions\/1423"}],"wp:attachment":[{"href":"https:\/\/shtincircle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shtincircle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shtincircle.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}