{"id":23,"date":"2023-11-20T14:34:55","date_gmt":"2023-11-20T14:34:55","guid":{"rendered":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/"},"modified":"2023-12-11T07:05:14","modified_gmt":"2023-12-11T07:05:14","slug":"%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/","title":{"rendered":"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 excel \uae30\ub2a5"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1830938232\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <div class=\"gb-container gb-container-3b8286e6\"><h2 id=\"10-if-function\" class=\"wp-block-heading\"> 1. IF \ud568\uc218<\/h2><p> <strong>IF \ud568\uc218\ub294 \uc9c0\uc815\ud55c \uc870\uac74\uc774 TRUE\uc774\uba74 \uac12\uc744 \ubc18\ud658\ud558\uace0, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ub2e4\ub978 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c IF \ud568\uc218\ub294 \uba3c\uc800 \uc870\uac74\uc744 \ud14c\uc2a4\ud2b8\ud558\uace0 \ud574\ub2f9 \uc870\uac74\uc758 \uacb0\uacfc\uc5d0 \ub530\ub77c \uac12\uc744 \ubc18\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><h3 id=\"11-syntax-\" class=\"wp-block-heading\"> \ud1b5\uc0ac\ub860<\/h3><p> IF(\ub17c\ub9ac_\ud14c\uc2a4\ud2b8, \uac12_if_true, \uac12_if_false)<\/p><h3 id=\"12-arguments-\" class=\"wp-block-heading\"> \uc778\uc218<\/h3><ul><li> <strong>logic_test:<\/strong> \ud3c9\uac00\ud558\ub824\ub294 \uc870\uac74\uc785\ub2c8\ub2e4.<\/li><li> <strong>value_if_true:<\/strong> \uc774 \uc870\uac74\uc774 TRUE\uc778 \uacbd\uc6b0 \uc5bb\uace0\uc790 \ud558\ub294 \uac12\uc785\ub2c8\ub2e4.<\/li><li> <strong>value_if_false:<\/strong> \uc774 \uc870\uac74\uc774 FALSE\uc778 \uacbd\uc6b0 \uc5bb\uace0\uc790 \ud558\ub294 \uac12\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"13-notes-\" class=\"wp-block-heading\"> \ucf54\uba58\ud2b8<\/h3><ul><li> \uc218\ud589\ud560 \uc218 \uc788\ub294 \ucd5c\ub300 \uc911\ucca9 \uc870\uac74 \uc218\ub294 64\uac1c\uc785\ub2c8\ub2e4.<\/li><li> \ube44\uad50 \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc870\uac74\uc744 \ud3c9\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"14-example\" class=\"wp-block-heading\"> \uc608<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 \ube44\uad50 \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\uc591\ud55c \uc870\uac74\uc744 \ud3c9\uac00\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37036\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-if-\ud568\uc218-\uc608\uc81c-1\" width=\"1274\" height=\"378\"><\/figure><\/div><ol><li> \uc870\uac74 \ucda9\uc871 \uc5ec\ubd80\uc5d0 \ub530\ub978 \uacb0\uacfc\ub97c \uc5bb\uae30 \uc704\ud574 \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4.<\/li><li> TRUE \ubc0f FALSE\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc870\uac74\uc774 TRUE\uc778 \uacbd\uc6b0 \uacb0\uacfc\ub97c \uc5bb\uae30 \uc704\ud574 \uac12 \uc9c0\uc815\uc744 \uac74\ub108\ub6f0\uba74 0\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><li> \uadf8\ub9ac\uace0 \uc870\uac74\uc774 FALSE\uc778 \uacbd\uc6b0 \uacb0\uacfc\ub97c \uc5bb\uae30 \uc704\ud574 \uac12 \uc9c0\uc815\uc744 \uac74\ub108\ub6f0\uba74 0\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><\/ol><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 IF \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc911\ucca9 \uc218\uc2dd\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37037\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-if-\ud568\uc218-\uc608\uc81c-2\" width=\"487\" height=\"385\"><\/figure><\/div><p> \uc870\uac74\uc744 \uc9c0\uc815\ud588\uace0 \ud574\ub2f9 \uc870\uac74\uc774 \uac70\uc9d3\uc774\uba74 \ub2e4\ub978 IF\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\ub978 \uc870\uac74\uc744 \ud3c9\uac00\ud558\uace0 \uc791\uc5c5\uc744 \uc218\ud589\ud588\uc73c\uba70 \ud574\ub2f9 \uc870\uac74\uc774 FALSE\uc774\uba74 \ub2e4\ub978 IF\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4.<\/p><p> \uc774\ub7f0 \uc2dd\uc73c\ub85c IF\ub97c 5\ubc88 \uc0ac\uc6a9\ud558\uc5ec \uc911\ucca9 \uc218\uc2dd\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \uc911\ucca9 \uc218\uc2dd\uc5d0\ub294 \ub3d9\uc77c\ud55c \ub0b4\uc6a9\uc744 64\ubc88 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><\/div><div class=\"gb-container gb-container-94098a45\"><h2 id=\"15-iferror-function\" class=\"wp-block-heading\"> 2.IFERROR \ud568\uc218<\/h2><p> <strong>IFERROR \ud568\uc218\ub294 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uba74 \ud2b9\uc815 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c \uac12\uc744 \ud14c\uc2a4\ud2b8\ud560 \uc218 \uc788\uc73c\uba70 \ud574\ub2f9 \uac12\uc774 \uc624\ub958\uc778 \uacbd\uc6b0 \uc9c0\uc815\ud55c \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p><h3 id=\"16-syntax-\" class=\"wp-block-heading\"> \ud1b5\uc0ac\ub860<\/h3><p> <em>IFERROR(\uac12, value_if_error)<\/em><\/p><h3 id=\"17-arguments-\" class=\"wp-block-heading\"> \uc778\uc218<\/h3><ul><li> <strong>\uac12:<\/strong> \uc624\ub958\ub97c \ud14c\uc2a4\ud2b8\ud558\ub824\ub294 \uac12\uc785\ub2c8\ub2e4.<\/li><li> <strong>value_if_error:<\/strong> \uc624\ub958\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c \ubc18\ud658\ubc1b\uace0 \uc2f6\uc740 \uac12\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"18-notes-\" class=\"wp-block-heading\"> \ucf54\uba58\ud2b8<\/h3><ul><li> IFERROR \ud568\uc218\ub294 \uc624\ub958 \uc720\ud615\uc774 \uc544\ub2cc \uc624\ub958 \ubc1c\uc0dd\uacfc \uad00\ub828\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uac12\uc774\ub098 value_if_error\ub97c \ubb34\uc2dc\ud558\uba74 \uacb0\uacfc\uc5d0 0\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><li> #N\/A, #REF!, #DIV\/0!, #VALUE!, #NUM!, #NAME?\uc744 \ud14c\uc2a4\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 #NULL!.<\/li><li> \ubc30\uc5f4\uc744 \ud3c9\uac00\ud558\uba74 \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc5d0 \ub300\ud55c \uacb0\uacfc \ubc30\uc5f4\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"19-example\" class=\"wp-block-heading\"> \uc608<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 IFERROR \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec #DIV\/0! \uc758\ubbf8\uc788\ub294 \ud14d\uc2a4\ud2b8\ub85c. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37041\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-iferror-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-iferror-\ud568\uc218-\uc608\uc81c-1\" width=\"441\" height=\"240\"><\/figure><\/div><p> IFERROR\ub294 2007 \uc774\ud558 \ubc84\uc804\uacfc\ub9cc \ud638\ud658\ub429\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub824\uba74 ISERROR\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><\/div><div class=\"gb-container gb-container-01635ccf\"><h2 id=\"40-trunc-function\" class=\"wp-block-heading\">3.TRUNC \uae30\ub2a5<\/h2><p> TRUNC \ud568\uc218\ub294 <strong>\uc6d0\ub798 \uc22b\uc790\ub97c \uc798\ub77c\ub0b8 \ud6c4 \uc815\uc218\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c \ud2b9\uc815 \uc815\ubc00\ub3c4\ub97c \uac00\uc9c4 \uc22b\uc790\uc5d0\uc11c \uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9bf\uc218\ub97c \uc81c\uac70\ud55c \ub2e4\uc74c \uacb0\uacfc\uc758 \uc815\uc218 \ubd80\ubd84\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p><h3 id=\"41-syntax-\" class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> <em>TRUNC(\uc22b\uc790, [\uc22b\uc790_\uc22b\uc790])<\/em><\/p><h3 id=\"42-arguments-\" class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>number:<\/strong> \uc798\ub77c\ub0b4\ub824\ub294 \uc22b\uc790\uc785\ub2c8\ub2e4.<\/li><li> <strong>[num_digits]:<\/strong> \uc22b\uc790\ub97c \uc790\ub974\ub294 \uc815\ubc00\ub3c4\ub97c \uc9c0\uc815\ud558\ub294 \uc22b\uc790\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"43-notes-\" class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> \ub2e4\uc911 \uc9c0\uc815\uc744 \ubb34\uc2dc\ud558\uba74 \uc624\ub958\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><li> 0\ubd80\ud130 \ubc18\uc62c\ub9bc\ub429\ub2c8\ub2e4.<\/li><li> \uac19\uc740 \uac70\ub9ac\uc5d0 \ub450 \uac1c\uc758 \ubc30\uc218\uac00 \uc788\ub294 \uacbd\uc6b0 \ubc18\uc62c\ub9bc\ud558\ub294 \uc22b\uc790\uc758 \ub354 \ub192\uc740 \ubc30\uc218\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"44-example\" class=\"wp-block-heading\"> \uc608<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 TRUNC\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc798\ub77c \ub0a0\uc9dc\uc5d0\uc11c \uc2dc\uac04\uc744 \uc81c\uac70\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37359\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-tronc-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-trunc-\ud568\uc218-\uc608\uc81c-1\" width=\"395\" height=\"418\"><\/figure><\/div><\/div><div class=\"gb-container gb-container-8dc99f1c\"><h2 id=\"50-sumif-function\" class=\"wp-block-heading\">4. SUMIF \ud568\uc218<\/h2><p> SUMIF \ud568\uc218\ub294 <strong>\uc9c0\uc815\ud55c \uc870\uac74\uc744 \ucda9\uc871\ud558\ub294 \uc22b\uc790\uc758 \ud569\uacc4\ub97c<\/strong> \ubc18\ud658\ud569\ub2c8\ub2e4. \uc27d\uac8c \ub9d0\ud558\uba74 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \uac12\ub4e4\uc758 \ud569\ub9cc\uc744 \uace0\ub824\ud558\uc5ec \uacc4\uc0b0\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p><h3 id=\"51-syntax-\" class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> <em>SUMIF(\ubc94\uc704, \uae30\uc900, [\ud569\uacc4_\ubc94\uc704])<\/em><\/p><h3 id=\"52-arguments-\" class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>\ubc94\uc704:<\/strong> \uae30\uc900\uc744 \ud655\uc778\ud558\ub824\ub294 \uc140 \ubc94\uc704\uc785\ub2c8\ub2e4.<\/li><li> <strong>\uae30\uc900:<\/strong> \uc22b\uc790, \ud14d\uc2a4\ud2b8, \ud45c\ud604\uc2dd, \uc140 \ucc38\uc870 \ub610\ub294 \ud568\uc218\uc77c \uc218 \uc788\ub294 \uae30\uc900\uc785\ub2c8\ub2e4.<\/li><li> <strong>[sum_range]:<\/strong> \ud569\uc0b0\ud558\ub824\ub294 \uac12\uc774 \ud3ec\ud568\ub41c \uc140 \ubc94\uc704\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"53-notes-\" class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> sum_range\ub97c \uc0dd\ub7b5\ud558\uba74 \ubc94\uc704 \ub0b4 \uc140\uc758 \ud569\uc774 \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/li><li> \ud14d\uc2a4\ud2b8 \uae30\uc900\uc744 \uc9c0\uc815\ud558\uac70\ub098 \ud070\ub530\uc634\ud45c\ub85c \ubb36\uc5b4\uc57c \ud558\ub294 \uc218\ud559 \uae30\ud638\ub97c \ud3ec\ud568\ud558\ub824\uba74 \ud070\ub530\uc634\ud45c\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li><li> \uae30\uc900 \ubc94\uc704\uc640 \ud569\uacc4 \ubc94\uc704\uc758 \ud06c\uae30\ub294 \ub3d9\uc77c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li><\/ul><h3 id=\"54-example\" class=\"wp-block-heading\"> \uc608<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 A1:A9\ub97c \uae30\uc900 \ubc94\uc704\ub85c, B1:B9\ub97c \ud569\uacc4 \ubc94\uc704\ub85c \uc9c0\uc815\ud55c \ub2e4\uc74c \uac12\uc774 C\uc778 A12\uc5d0 \uae30\uc900\uc744 \uc9c0\uc815\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-1\" width=\"453\" height=\"510\"><\/figure><\/div><p> \ud568\uc218\uc5d0 \uae30\uc900\uc744 \uc9c1\uc811 \uc0bd\uc785\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798 \uc608\uc5d0\uc11c\ub294 \ubcc4\ud45c \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc54c\ud30c\ubcb3 &#8220;S&#8221;\uac00 \uc788\ub294 \uae30\uc900\uc744 \uc9c0\uc815\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-2\" width=\"450\" height=\"480\"><\/figure><\/div><p> \uadf8\ub9ac\uace0 \ud569\uacc4 \ubc94\uc704\ub97c \ubb34\uc2dc\ud558\uba74 \uae30\uc900 \ubc94\uc704\uc758 \ud569\uacc4\uac00 \ub098\uc635\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774\ub294 \uae30\uc900 \ubc94\uc704\uc5d0 \uc22b\uc790 \uac12\uc774 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-3\" width=\"410\" height=\"411\"><\/figure><\/div><\/div><div class=\"gb-container gb-container-a35391aa\"><h2 class=\"wp-block-heading\"> 5. \uc778\ub371\uc2a4 \uae30\ub2a5<\/h2><p> <strong>INDEX \ud568\uc218\ub294 \uc778\ub371\uc2a4 \ubc88\ud638\ub97c \uae30\uc900\uc73c\ub85c \uac12 \ubaa9\ub85d\uc5d0\uc11c \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c INDEX\ub294 \uac12 \ubaa9\ub85d\uc5d0\uc11c \uac12\uc744 \ubc18\ud658\ud558\uba70 \ud574\ub2f9 \uac12\uc758 \uc704\uce58\ub97c \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> INDEX\uc5d0\ub294 \ub450 \uac00\uc9c0 \ub2e4\ub978 \uad6c\ubb38\uc774 \uc788\uc2b5\ub2c8\ub2e4. <strong>\ucc98\uc74c<\/strong> \uc5d0\ub294 \uc778\ub371\uc2a4\uc758 \ubc30\uc5f4 \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \uc704\uce58\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubaa9\ub85d\uc5d0\uc11c \uac12\uc744 \uac04\ub2e8\ud788 \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> INDEX(\ubc30\uc5f4, \ud589_\ubc88\ud638, [\uc5f4_\ubc88\ud638])<\/p><p> <strong>\ub450 \ubc88\uc9f8<\/strong> \ub85c\ub294 \uc2e4\uc0dd\ud65c\uc5d0\uc11c \uc798 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \ud6c4\uc6d0\uc591\uc2dd\uc744 \ud65c\uc6a9\ud558\uc2e4 \uc218 \uc788\uc73c\ub098, \ud64d\ubcf4\ud560 \ubc94\uc704\uac00 2\uac1c \uc774\uc0c1\uc778 \uacbd\uc6b0\uc5d0 \ud65c\uc6a9\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> INDEX(\ucc38\uc870, row_num, [column_num], [area_num])<\/p><h3 class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>\ubc30\uc5f4:<\/strong> \uc140 \ubc94\uc704 \ub610\ub294 \ubc30\uc5f4 \uc0c1\uc218\uc785\ub2c8\ub2e4.<\/li><li> <strong>\ucc38\uc870:<\/strong> \uc140 \ubc94\uc704 \ub610\ub294 \uc5ec\ub7ec \ubc94\uc704.<\/li><li> <strong>row_number:<\/strong> \uac12\uc744 \uc5bb\uc73c\ub824\ub294 \ud589 \ubc88\ud638\uc785\ub2c8\ub2e4.<\/li><li> <strong>[col_number]:<\/strong> \uac12\uc744 \uc5bb\uc73c\ub824\ub294 \uc5f4\uc758 \ubc88\ud638\uc785\ub2c8\ub2e4.<\/li><li> <strong>[area_number]:<\/strong> \uc5ec\ub7ec \uc140 \ubc94\uc704\ub97c \ucc38\uc870\ud558\ub294 \uacbd\uc6b0(\ucc38\uc870 \uad6c\ubb38 \uc0ac\uc6a9) \uc140 \uc804\uccb4 \uc911\uc5d0\uc11c \ud558\ub098\uc758 \ubc94\uc704\ub97c \ucc38\uc870\ud558\ub294 \uc22b\uc790\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> row_num \ubc0f column_num \uc778\uc218\uac00 \uc9c0\uc815\ub418\uba74 \ub458\uc758 \uad50\ucc28\uc810\uc5d0 \uc788\ub294 \uc140\uc758 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li><li> row_num \ub610\ub294 column_num\uc744 0(\uc601)\uc73c\ub85c \uc9c0\uc815\ud558\uba74 \uac01\uac01 \uc804\uccb4 \uc5f4 \ub610\ub294 \ud589\uc5d0 \ub300\ud55c \uac12\uc758 \ubc30\uc5f4\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li><li> row_num \ubc0f column_num\uc774 \ubc94\uc704\ub97c \ubc97\uc5b4\ub098\uba74 #REF\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4! \uc624\ub958.<\/li><li> Area_number\uac00 \uc9c0\uc815\ud55c \uc22b\uc790 \ubc94\uc704\ubcf4\ub2e4 \ud06c\uba74 #REF!\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc608 1 &#8211; ARRAY\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubaa9\ub85d\uc5d0\uc11c \uac12 \uac00\uc838\uc624\uae30<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 INDEX \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec 6\uc6d4\uc758 \uc218\ub7c9\uc744 \uac00\uc838\uc654\uc2b5\ub2c8\ub2e4. \ubaa9\ub85d\uc5d0\uc11c Jun\uc740 6\ubc88\uc9f8 \uc704\uce58(6\ubc88\uc9f8 \ud589)\uc5d0 \uc788\uc73c\ubbc0\ub85c row_number\uc5d0 6\uc744 \uc9c0\uc815\ud588\uc2b5\ub2c8\ub2e4. INDEX\ub294 \uacb0\uacfc\uc5d0 1904 \uac12\uc744 \ubc18\ud658\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Exemple-de-fonction-dindex-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-\uc0c9\uc778-\ud568\uc218-\uc608\uc81c-1\" width=\"557\" height=\"334\"><\/figure><\/div><p> \uadf8\ub9ac\uace0 \ub458 \uc774\uc0c1\uc758 \uc5f4\uc774 \uc788\ub294 \ubc94\uc704\ub97c \ucc38\uc870\ud558\ub294 \uacbd\uc6b0 \uc5f4 \ubc88\ud638\ub97c \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> \uc608 2 \u2013 REFERENCE\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5ec\ub7ec \ubaa9\ub85d\uc758 \uac12 \uac00\uc838\uc624\uae30<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 \uc804\uccb4 \ubc94\uc704\ub97c \ud55c \ubc88\uc5d0 \uc120\ud0dd\ud558\ub294 \ub300\uc2e0 \uc138 \uac00\uc9c0 \ubc94\uc704\uc5d0\uc11c \uc120\ud0dd\ud588\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9 \uc778\uc218\uc5d0\uc11c \uc6b0\ub9ac\ub294 \uc774\ub7ec\ud55c \uc138 \uac00\uc9c0 \ub2e4\ub978 \ubc94\uc704\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ubc94\uc704\ub97c \uc815\uc758\ud558\ub294area_number\uc5d0 2\ub97c \uc9c0\uc815\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37060\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Exemple-de-fonction-dindex-Excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-\uc0c9\uc778-\ud568\uc218-\uc608\uc81c-2\" width=\"627\" height=\"311\"><\/figure><\/div><p> \uc774\uc81c \ub450 \ubc88\uc9f8 \ud589\uc5d0\uc11c\ub294 \ub2e4\uc12f \ubc88\uc9f8 \ud589\uacfc \uccab \ubc88\uc9f8 \uc5f4\uc744 \ucc38\uc870\ud569\ub2c8\ub2e4. INDEX\ub294 \ub450 \ubc88\uc9f8 \ud589\uc758 \ub2e4\uc12f \ubc88\uc9f8 \ud589\uc5d0 \uc788\ub294 \uac12 172\ub97c \ubc18\ud658\ud588\uc2b5\ub2c8\ub2e4.<\/p><\/div><div class=\"gb-container gb-container-3b02e5f8\"><h2 class=\"wp-block-heading\"> 6.VLOOKUP \uae30\ub2a5<\/h2><p> <strong>VLOOKUP \ud568\uc218\ub294 \ud14c\uc774\ube14\uc758 \uccab \ubc88\uc9f8 \uc5f4\uc5d0\uc11c \uac12\uc744 \ucc3e\uc544 \uc778\ub371\uc2a4 \ubc88\ud638\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \uac12\uacfc \ub3d9\uc77c\ud55c \ud589\uc758 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c \uc218\uc9c1 \uac80\uc0c9\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> <em>VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>lookup_value:<\/strong> \uc5f4\uc5d0\uc11c \ucc3e\uace0\uc790 \ud558\ub294 \uac12\uc785\ub2c8\ub2e4. \uac80\uc0c9 \uac12\uc774 \ud3ec\ud568\ub41c \uc140\uc744 \ucc38\uc870\ud558\uac70\ub098 \ud574\ub2f9 \uac12\uc744 \ud568\uc218\uc5d0 \uc9c1\uc811 \uc785\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> <strong>table_array:<\/strong> \uc140 \ubc94\uc704, \uac12\uc744 \ucc3e\uc73c\ub824\ub294 \uba85\uba85\ub41c \ubc94\uc704\uc785\ub2c8\ub2e4.<\/li><li> <strong>col_index_num:<\/strong> \uc22b\uc790\ub294 \uac12\uc744 \uac80\uc0c9\ud558\ub824\ub294 \uc5f4 \ubc88\ud638\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/li><li> <strong>range_lookup:<\/strong> \uc815\ud655\ud55c \uc77c\uce58\uc5d0\ub294 false \ub610\ub294 0\uc744 \uc0ac\uc6a9\ud558\uace0 \uc801\uc808\ud55c \uc77c\uce58\uc5d0\ub294 true \ub610\ub294 1\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 True\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> VLOOKUP\uc774 \uc6d0\ud558\ub294 \uac12\uc744 \ucc3e\uc9c0 \ubabb\ud558\uba74 #N\/A\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li><li> VLOOKUP\uc740 \uc870\ud68c \uac12 \uc624\ub978\ucabd\uc5d0 \uc788\ub294 \uac12\ub9cc \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc624\ub978\ucabd\uc5d0\uc11c \ubcf4\uace0 \uc2f6\ub2e4\uba74 INDEX\uc640 MATCH\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/li><li> \uc815\ud655\ud788 \uc77c\uce58\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc5f4\uc758 \uccab \ubc88\uc9f8 \uac12\ub9cc \uc77c\uce58\ud569\ub2c8\ub2e4.<\/li><li> VLOOKUP\uc5d0 \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc801\uc808\ud55c \uc77c\uce58\ub97c \uc6d0\ud558\uba74 TRUE \ub610\ub294 1\uc744 \uc0ac\uc6a9\ud558\uace0 \uc815\ud655\ud55c \uc77c\uce58\ub97c \uc6d0\ud558\uba74 FALSE \ub610\ub294 0\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uc801\uc808\ud55c \uc77c\uce58\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0(True): \uc815\ud655\ud55c \uc77c\uce58\uac00 \uc5c6\uc73c\uba74 \ubaa9\ub85d\uc5d0\uc11c \ub2e4\uc74c\uc73c\ub85c \uac00\uc7a5 \uc791\uc740 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li><li> \ucc3e\uace0 \uc788\ub294 \uac12\uc774 \ubaa9\ub85d\uc5d0\uc11c \uac00\uc7a5 \uc791\uc740 \uac12\ubcf4\ub2e4 \uc791\uc740 \uacbd\uc6b0 VLOOKUP\uc740 #N\/A\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li><li> \ucc3e\uace0 \uc788\ub294 \uc815\ud655\ud55c \uac12\uc774 \uc788\uc73c\uba74 \ud574\ub2f9 \uac12\uc774 \uc81c\uacf5\ub429\ub2c8\ub2e4.<\/li><li> \ubaa9\ub85d\uc744 \uc624\ub984\ucc28\uc21c\uc73c\ub85c \uc815\ub82c\ud588\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc608<\/h3><h4 class=\"wp-block-heading\"> 1. \uce74\ud14c\uace0\ub9ac\uc5d0 VLOOKUP \uc0ac\uc6a9<\/h4><p> \uc544\ub798 \uc608\uc5d0\ub294 \ubc1b\uc740 \uc131\uc801\uc774 \ud3ec\ud568\ub41c \ud559\uc0dd \ubaa9\ub85d\uc774 \uc788\uc73c\uba70 \ube44\uace0 \uc5f4\uc5d0\ub294 \uc131\uc801\uc5d0 \ub530\ub978 \uc131\uc801\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37377\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-vlookup-\ud568\uc218-\uc608\uc81c-1\" width=\"385\" height=\"386\"><\/figure><\/div><p> \uc704\uc758 \ube0c\ub79c\ub4dc \ubaa9\ub85d\uc5d0 \uc544\ub798 \uce74\ud14c\uace0\ub9ac \ubc94\uc704\uc5d0 \ub530\ub978 \ube44\uace0\ub97c \ucd94\uac00\ud558\uace0\uc790 \ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-vlookup-\ud568\uc218-\uc608\uc81c-2\" width=\"369\" height=\"132\"><\/figure><\/div><p> \uc5ec\uae30\uc5d0\ub294 \ub450 \uac00\uc9c0 \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> <strong>\uccab \ubc88\uc9f8<\/strong> \ub294 IF\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc911\ucca9 \uc218\uc2dd\uc744 \ub9cc\ub4dc\ub294 \uac83\uc778\ub370 \uc2dc\uac04\uc774 \uc870\uae08 \uac78\ub9bd\ub2c8\ub2e4. <strong>\ub450 \ubc88\uc9f8<\/strong> \uc635\uc158\uc740 \uc801\uc808\ud55c \uc77c\uce58 \ud56d\ubaa9\uc774 \uc788\ub294 VLOOKUP\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc218\uc2dd\uc744 \ub9cc\ub4dc\ub294 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uacf5\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p><p> =VLOOKUP(B2,$E$2:$G$5,3,TRUE) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37379\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-vlookup-\ud568\uc218-\uc608\uc81c-3\" width=\"479\" height=\"321\"><\/figure><\/div><p> <strong>\uc791\ub3d9 \uc6d0\ub9ac<\/strong><\/p><p> &#8220;MIN MARKS&#8221; \uc5f4\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc870\ud68c \uac12\uc744 \uc77c\uce58\uc2dc\ud0a4\uace0 &#8220;Remarks&#8221; \uc5f4\uc5d0\uc11c \uac12\uc744 \ub2e4\uc2dc \uac00\uc838\uc635\ub2c8\ub2e4.<\/p><p> TRUE\ub97c \uc0ac\uc6a9\ud558\uace0 \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \uac80\uc0c9 \uac12\uc774 \uc5c6\uc73c\uba74 \uac80\uc0c9 \uac12\uc5d0\uc11c \ub2e4\uc74c\uc73c\ub85c \uac00\uc7a5 \uc791\uc740 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4\uace0 \uc774\ubbf8 \uc5b8\uae09\ud588\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uce74\ud14c\uace0\ub9ac \ud14c\uc774\ube14\uc5d0\uc11c 77\uc774\ub77c\ub294 \uac12\uc744 \uac80\uc0c9\ud558\uba74 65\uac00 77 \ub2e4\uc74c\uc73c\ub85c \uac00\uc7a5 \uc791\uc740 \uac12\uc785\ub2c8\ub2e4.<\/p><p> \uc774\uac83\uc774 \uc6b0\ub9ac\uac00 \ubc1c\uc5b8\uc5d0\uc11c \u201c\uc88b\uc74c\u201d\uc744 \uc5bb\uc740 \uc774\uc720\uc785\ub2c8\ub2e4.<\/p><h4 class=\"wp-block-heading\"> 2. VLOOKUP \ud568\uc218\uc758 \uc624\ub958 \ucc98\ub9ac<\/h4><p> VLOOKUP\uc744 \uc0ac\uc6a9\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \ubb38\uc81c \uc911 \ud558\ub098\ub294 \uc77c\uce58\ud558\ub294 \ud56d\ubaa9\uc774 \uc5c6\uc744 \ub54c\ub9c8\ub2e4 #N\/A\uac00 \ubc1c\uc0dd\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774 \ubb38\uc81c\uc5d0 \ub300\ud55c \ud574\uacb0\ucc45\uc740 \uac04\ub2e8\ud558\uace0 \uc27d\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud55c \uc608\ub97c \ub4e4\uc5b4 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p><p> \uc544\ub798 \uc608\uc5d0\ub294 \uc774\ub984\uacfc \ub098\uc774 \ubaa9\ub85d\uc774 \uc788\uc73c\uba70 \uc140 E6\uc5d0\ub294 VLOOKUP \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubaa9\ub85d\uc5d0\uc11c \uc774\ub984\uc744 \uac80\uc0c9\ud569\ub2c8\ub2e4. \ubaa9\ub85d\uc5d0 \uc5c6\ub294 \uc774\ub984\uc744 \uc785\ub825\ud560 \ub54c\ub9c8\ub2e4 #N\/A\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37380\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-vlookup-\ud568\uc218-\uc608\uc81c-4\" width=\"560\" height=\"404\"><\/figure><\/div><p> \ud558\uc9c0\ub9cc \uc5ec\uae30\uc11c \ub0b4\uac00 \uc6d0\ud558\ub294 \uac83\uc740 \uc624\ub958 \ub300\uc2e0 \uc758\ubbf8 \uc788\ub294 \uba54\uc2dc\uc9c0\ub97c \ud45c\uc2dc\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc218\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. =IFNA(VLOOKUP(D6,Sheet3!$A$1:$B$14,2,0),&#8221;\ucc3e\uc744 \uc218 \uc5c6\uc74c&#8221;) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37381\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-5.png\" sizes=\"auto, \" srcset=\"\" alt=\"\uc5d1\uc140-vlookup-\ud568\uc218-\uc608\uc81c-5\" width=\"601\" height=\"359\"><\/figure><\/div><p> <strong>\uc791\ub3d9 \ubc29\uc2dd<\/strong> : IFNA\ub294 #N\/A \uac12\uc744 \ud14c\uc2a4\ud2b8\ud560 \uc218 \uc788\uc73c\uba70 \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0 \uc624\ub958 \ub300\uc2e0 \uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><\/div><div class=\"gb-container gb-container-c8d02e8d\"><h2 class=\"wp-block-heading\"> 7. IFNA \uae30\ub2a5<\/h2><p> <strong>IFNA \ud568\uc218\ub294 #N\/A \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uba74 \ud2b9\uc815 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> IFERROR\uc640 \ub2ec\ub9ac #N\/A \uc624\ub958\ub9cc \ud3c9\uac00\ud558\uace0 \uc9c0\uc815\ud55c \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> IFNA(\uac12, value_if_na)<\/p><h3 class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>value:<\/strong> #N\/A \uc624\ub958\ub97c \ud14c\uc2a4\ud2b8\ud558\ub824\ub294 \uac12\uc785\ub2c8\ub2e4.<\/li><li> <strong>value_if_na:<\/strong> \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c \uacbd\uc6b0 \ubc18\ud658\ud560 \uac12\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> \uc778\uc218\ub97c \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 IFNA\ub294 \uc774\ub97c \ube48 \ubb38\uc790\uc5f4(&#8220;&#8221;)\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/li><li> \uac12\uc774 \ubc30\uc5f4\uc774\uba74 \uacb0\uacfc\uac00 \ubc30\uc5f4\ub85c \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><li> \ub2e4\ub978 \ubaa8\ub4e0 \uc624\ub958 #REF!, #DIV\/0!, #VALUE!, #NUM!, #NAME?\uc744 \ubb34\uc2dc\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 #NULL!.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc608<\/h3><p> VLOOKUP \ud568\uc218\uc5d0\uc11c\ub294 \uc870\ud68c \uac12\uc774 \uc870\ud68c \ubc94\uc704\uc5d0 \uc5c6\uc744 \ub54c #N\/A\uac00 \ubc1c\uc0dd\ud558\ub294\ub370, \uc774\uc5d0 \ub300\ud574 IFNA\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc758\ubbf8 \uc788\ub294 \uba54\uc2dc\uc9c0\ub97c \uc9c0\uc815\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37051\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-ifna-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ifna-\ud568\uc218-\uc608\uc81c-1\" width=\"537\" height=\"259\"><\/figure><\/div><p class=\"qt-tip\"> <strong>\ucc38\uace0:<\/strong> IFNA\ub294 Excel 2013\uc5d0 \ub3c4\uc785\ub418\uc5c8\uc73c\ubbc0\ub85c \uc774\uc804 \ubc84\uc804\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p><\/div><div class=\"gb-container gb-container-593242fc\"><h2 class=\"wp-block-heading\"> 8. \ub79c\ub4dc \ud568\uc218<\/h2><p> <strong>RAND \ud568\uc218\ub294 0\uacfc 1 \uc0ac\uc774\uc758 \ub09c\uc218\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4<\/strong> . \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c 0\uacfc 1 \uc0ac\uc774\uc758 \ub09c\uc218\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\uc6cc\ud06c\uc2dc\ud2b8\ub97c \ubcc0\uacbd\ud560 \ub54c\ub9c8\ub2e4 \ud574\ub2f9 \uac12\uc774 \uc5c5\ub370\uc774\ud2b8\ub429\ub2c8\ub2e4).<\/p><h3 class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> <em>\ub79c\ub4dc()<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> RAND \ud568\uc218\uc5d0 \uc9c0\uc815\ud560 \uc778\uc218\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> \ubc30\uc218\uc5d0 0\uc744 \ub123\uc73c\uba74 \uacb0\uacfc\uc5d0 0\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><li> \ub2e4\uc911 \uc9c0\uc815\uc744 \ubb34\uc2dc\ud558\uba74 \uc624\ub958\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><li> 0\ubd80\ud130 \ubc18\uc62c\ub9bc\ub429\ub2c8\ub2e4.<\/li><li> \uac19\uc740 \uac70\ub9ac\uc5d0 \ub450 \uac1c\uc758 \ubc30\uc218\uac00 \uc788\ub294 \uacbd\uc6b0 \ubc18\uc62c\ub9bc\ud558\ub294 \uc22b\uc790\uc758 \ub354 \ub192\uc740 \ubc30\uc218\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc608<\/h3><p> 0\uacfc 1 \uc0ac\uc774\uc758 \uc22b\uc790 \uc678\uc5d0\ub3c4 \ub450 \ud2b9\uc815 \uc22b\uc790 \uc0ac\uc774\uc758 \ub09c\uc218\uc5d0 \ub300\ud574 RAND\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798 \uc608\uc5d0\uc11c\ub294 \uc774\ub97c \uc0ac\uc6a9\ud558\uc5ec 50\uc5d0\uc11c 100 \uc0ac\uc774\uc758 \ub09c\uc218\ub97c \uc0dd\uc131\ud558\ub294 \uc218\uc2dd\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37234\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-rand-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-rand-\ud568\uc218-\uc608\uc81c-1\" width=\"449\" height=\"394\"><\/figure><\/div><p> \uc774 \uc218\uc2dd\uc744 \uc140\uc5d0 \uc785\ub825\ud558\uba74 RAND\uc5d0\uc11c \ubc18\ud658\ub41c \uac12\uc5d0 \uc6b0\ub9ac\uac00 \uc0ac\uc6a9\ud55c \ubc29\uc815\uc2dd\uc744 \uacf1\ud558\uc5ec 100\uc5d0\uc11c 50 \uc0ac\uc774\uc758 \uc22b\uc790\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4. \uc774 \uacf5\uc2dd\uc744 \uc774\ud574\ud558\ub824\uba74 \uc774\ub97c \uc138 \ubd80\ubd84\uc73c\ub85c \ub098\ub204\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p><ol><li> \uba3c\uc800, \ub192\uc740 \uc22b\uc790\uc5d0\uc11c \ub0ae\uc740 \uc22b\uc790\ub97c \uac10\uc9c0\ud558\uba74 \ub458 \uc0ac\uc774\uc758 \ucc28\uc774\ub97c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li> \uadf8\ub7f0 \ub2e4\uc74c \uc774 \ucc28\uc774\uc5d0 \ube84\uc148 \ud6c4\uc5d0 \ubc18\ud658\ub41c \ub09c\uc218\ub97c \uacf1\ud569\ub2c8\ub2e4.<\/li><li> \uc14b\uc9f8, \ubc29\uc815\uc2dd\uc758 \uc138 \ubc88\uc9f8 \ubd80\ubd84\uc5d0 \uac00\uc7a5 \ub0ae\uc740 \ub0a8\uc740 \uc22b\uc790\uc640 \ud568\uaed8 \uc774 \uc22b\uc790\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li><\/ol><p> <strong>\uad00\ub828:<\/strong> Excel\uc5d0\uc11c \uc784\uc758\uc758 \ubb38\uc790\ub97c \ube60\ub974\uac8c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95<\/p><\/div><div class=\"gb-container gb-container-c4855d41\"><h2 class=\"wp-block-heading\"> 9. SUM \ud568\uc218<\/h2><p> SUM \ud568\uc218\ub294 <strong>\uc81c\uacf5\ub41c \uac12\uc758 \ud569\uacc4\ub97c<\/strong> \ubc18\ud658\ud569\ub2c8\ub2e4. \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c SUM \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uac12 \ubaa9\ub85d\uc758 \ud569\uacc4\ub97c \uacc4\uc0b0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\ud568\uc218\uc5d0 \uac12\uc744 \uc9c1\uc811 \uc785\ub825\ud558\uac70\ub098 \uc140 \ubc94\uc704\ub97c \ucc38\uc870\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4).<\/p><h3 class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> <em>SUM(\uc22b\uc7901,[\uc22b\uc7902],\u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>number1<\/strong> : \uc22b\uc790, \uc22b\uc790\uac00 \ud3ec\ud568\ub41c \uc140 \ubc94\uc704 \ub610\ub294 \uc22b\uc790\uac00 \ud3ec\ud568\ub41c \ub2e8\uc77c \uc140\uc785\ub2c8\ub2e4.<\/li><li> <strong>[number2]<\/strong> : \uc22b\uc790, \uc22b\uc790\uac00 \ud3ec\ud568\ub41c \uc140 \ubc94\uc704 \ub610\ub294 \uc22b\uc790\uac00 \ud3ec\ud568\ub41c \ub2e8\uc77c \uc140\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> \ud14d\uc2a4\ud2b8 \uac12\uc740 \ubb34\uc2dc\ub429\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc608<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 \uc22b\uc790 \uc0ac\uc774\uc5d0 \uc27c\ud45c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc22b\uc790\ub97c \ud568\uc218\uc5d0 \uc9c1\uc811 \uc0bd\uc785\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-somme-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-1\" width=\"433\" height=\"284\"><\/figure><\/div><p> \ubc94\uc704\ub97c \ucc38\uc870\ud558\uc5ec \uc22b\uc790\uc758 \ud569\uc744 \uacc4\uc0b0\ud560 \uc218\ub3c4 \uc788\uc73c\uba70 \ud14d\uc2a4\ud2b8, \ub17c\ub9ac\uac12 \ub610\ub294 \ube48 \uc140\uc774 \uc788\uc73c\uba74 \ubb34\uc2dc\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-somme-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-2\" width=\"392\" height=\"434\"><\/figure><\/div><p> \ucc38\uc870\ud558\ub294 \uc140\uc5d0 \uc624\ub958 \uac12\uc774 \uc788\uc73c\uba74 \uacb0\uacfc\uc5d0 #N\/A\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37326\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-somme-excel-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-3\" width=\"440\" height=\"429\"><\/figure><\/div><p> \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc758 \uc22b\uc790 \uac12\uc774 \uc788\uc73c\uba74 \ubb34\uc2dc\ub429\ub2c8\ub2e4. SUM\uc744 \uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 \uc22b\uc790\ub85c \ubcc0\ud658\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37328\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-somme-excel-4-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ud569\uacc4-\ud568\uc218-\uc608\uc81c-4\" width=\"430\" height=\"493\"><\/figure><\/div><\/div><div class=\"gb-container gb-container-d78822f8\"><h2 class=\"wp-block-heading\"> 10. OR \uae30\ub2a5<\/h2><p> <strong>OR \ud568\uc218\ub294 \uc9c0\uc815\ud55c \uc870\uac74\uc744 \ud14c\uc2a4\ud2b8\ud55c \ud6c4 \ubd80\uc6b8 \uac12(TRUE \ub610\ub294 FALSE)\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/strong> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c AND \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5ec\ub7ec \uc870\uac74\uc744 \ud14c\uc2a4\ud2b8\ud560 \uc218 \uc788\uc73c\uba70 \uc774\ub7ec\ud55c \uc870\uac74 \uc911 \ud558\ub098(\ub610\ub294 \ubaa8\ub450)\uac00 TRUE\uc774\uba74 TRUE\ub97c \ubc18\ud658\ud558\uace0 \ubaa8\ub4e0 \uc870\uac74\uc774 FALSE\uc778 \uacbd\uc6b0\uc5d0\ub9cc FALSE\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> <strong>\ud1b5\uc0ac\ub860<\/strong><\/h3><p> OR(\ub17c\ub9ac1, [\ub17c\ub9ac2], \u2026)<\/p><h3 class=\"wp-block-heading\"> <strong>\uc778\uc218<\/strong><\/h3><ul><li> <strong>logic1:<\/strong> \ud655\uc778\ud558\ub824\ub294 \uc870\uac74\uc785\ub2c8\ub2e4.<\/li><li> <strong>[\ub17c\ub9ac2]:<\/strong> \ud655\uc778\ud558\ub824\ub294 \ucd94\uac00 \uc870\uac74\uc785\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\ucf54\uba58\ud2b8<\/strong><\/h3><ul><li> \ucc38\uc870 \uc140\uc774\ub098 \ud45c\uc5d0 \ube48 \uc140\uc774\ub098 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\uba74 \uac12\uc774 \ubb34\uc2dc\ub429\ub2c8\ub2e4.<\/li><li> \uc870\uac74\uc758 \uacb0\uacfc\ub294 \ub17c\ub9ac\uac12(TRUE \ub610\ub294 FALSE)\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li><li> \ub17c\ub9ac\uac12\uc774 \ubc18\ud658\ub418\uc9c0 \uc54a\uc73c\uba74 \uc624\ub958\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li><\/ul><h3 class=\"wp-block-heading\"> \uc608<\/h3><p> \uc544\ub798 \uc608\uc5d0\uc11c\ub294 IF \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud559\uc0dd\uc774 \ub450 \uacfc\ubaa9 \uc911 \ud558\ub098\uc5d0\uc11c 60\uc810 \uc774\uc0c1\uc744 \ud68d\ub4dd\ud558\uba74 \uc218\uc2dd\uc774 TRUE\ub97c \ubc18\ud658\ud558\ub294 \uc870\uac74\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37225\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-ou-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-\ub610\ub294-\ud568\uc218-\uc608\uc81c-1\" width=\"472\" height=\"280\"><\/figure><\/div><p> \uc774\uc81c \uc544\ub798 \uc608\uc5d0\uc11c\ub294 \uc218\uc2dd\uc5d0\uc11c \ub17c\ub9ac\uac12\uc744 \uc5bb\uae30 \uc704\ud574 \uc22b\uc790\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \uc704\uc758 \uc870\uac74\uc744 \uc5ed\uc21c\uc73c\ub85c \uc218\ud589\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uc22b\uc790 \ub300\uc2e0 TRUE \ubc0f FALSE\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. OR \ud568\uc218\ub294 \uc774\ub7ec\ud55c \ub17c\ub9ac\uac12\uc744 \uc22b\uc790\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p><\/div><div class=\"gb-container gb-container-68a47082\"><h2 class=\"wp-block-heading\"> \ub354 \ub9ce\uc740 \ud29c\ud1a0\ub9ac\uc5bc<\/h2><p> <strong>\ud1b5\uacc4 \ud568\uc218<\/strong> \/ <strong>\ub0a0\uc9dc \ud568\uc218<\/strong> \/ <strong>\ubb38\uc790\uc5f4 \u2013 \ud14d\uc2a4\ud2b8 \ud568\uc218<\/strong> \/ <strong>\uae08\uc735 \ud568\uc218<\/strong><\/p><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-23","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 Excel \uae30\ub2a5(\uc608\uc81c \ud3ec\ud568)<\/title>\n<meta name=\"description\" content=\"\uc774 \uac00\uc774\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0d8\ud50c \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\uc5ec \uc608\uc81c\uc640 \ud568\uaed8 \ucd5c\uace0\uc758 Excel \uae30\ub2a5\uc774 \uc644\uc804\ud788 \ub85c\ub4dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ko\/\uc5d1\uc140-\uae30\ub2a5\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 Excel \uae30\ub2a5(\uc608\uc81c \ud3ec\ud568)\" \/>\n<meta property=\"og:description\" content=\"\uc774 \uac00\uc774\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0d8\ud50c \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\uc5ec \uc608\uc81c\uc640 \ud568\uaed8 \ucd5c\uace0\uc758 Excel \uae30\ub2a5\uc774 \uc644\uc804\ud788 \ub85c\ub4dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ko\/\uc5d1\uc140-\uae30\ub2a5\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T07:05:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/\",\"name\":\"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 Excel \uae30\ub2a5(\uc608\uc81c \ud3ec\ud568)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\",\"datePublished\":\"2023-11-20T14:34:55+00:00\",\"dateModified\":\"2023-12-11T07:05:14+00:00\",\"description\":\"\uc774 \uac00\uc774\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0d8\ud50c \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\uc5ec \uc608\uc81c\uc640 \ud568\uaed8 \ucd5c\uace0\uc758 Excel \uae30\ub2a5\uc774 \uc644\uc804\ud788 \ub85c\ub4dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\uc9d1\",\"item\":\"https:\/\/exceladvisor.org\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 excel \uae30\ub2a5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"name\":\"Excel Advisor\",\"description\":\"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 Excel \uae30\ub2a5(\uc608\uc81c \ud3ec\ud568)","description":"\uc774 \uac00\uc774\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0d8\ud50c \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\uc5ec \uc608\uc81c\uc640 \ud568\uaed8 \ucd5c\uace0\uc758 Excel \uae30\ub2a5\uc774 \uc644\uc804\ud788 \ub85c\ub4dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/ko\/\uc5d1\uc140-\uae30\ub2a5\/","og_locale":"ko_KR","og_type":"article","og_title":"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 Excel \uae30\ub2a5(\uc608\uc81c \ud3ec\ud568)","og_description":"\uc774 \uac00\uc774\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0d8\ud50c \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\uc5ec \uc608\uc81c\uc640 \ud568\uaed8 \ucd5c\uace0\uc758 Excel \uae30\ub2a5\uc774 \uc644\uc804\ud788 \ub85c\ub4dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.","og_url":"https:\/\/exceladvisor.org\/ko\/\uc5d1\uc140-\uae30\ub2a5\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-11T07:05:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/","url":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/","name":"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 Excel \uae30\ub2a5(\uc608\uc81c \ud3ec\ud568)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png","datePublished":"2023-11-20T14:34:55+00:00","dateModified":"2023-12-11T07:05:14+00:00","description":"\uc774 \uac00\uc774\ub4dc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0d8\ud50c \ud30c\uc77c\uc744 \ud3ec\ud568\ud558\uc5ec \uc608\uc81c\uc640 \ud568\uaed8 \ucd5c\uace0\uc758 Excel \uae30\ub2a5\uc774 \uc644\uc804\ud788 \ub85c\ub4dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ko\/%ec%97%91%ec%85%80-%ea%b8%b0%eb%8a%a5\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\uc9d1","item":"https:\/\/exceladvisor.org\/ko\/"},{"@type":"ListItem","position":2,"name":"\uac00\uc7a5 \uc911\uc694\ud55c 10\uac00\uc9c0 excel \uae30\ub2a5"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ko\/#website","url":"https:\/\/exceladvisor.org\/ko\/","name":"Excel Advisor","description":"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!","publisher":{"@id":"https:\/\/exceladvisor.org\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ko\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/23\/revisions"}],"predecessor-version":[{"id":1337,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/23\/revisions\/1337"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/media?parent=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}