{"id":536,"date":"2022-09-26T23:15:59","date_gmt":"2022-09-26T14:15:59","guid":{"rendered":"https:\/\/chaerang.net\/?p=536"},"modified":"2022-09-26T23:16:00","modified_gmt":"2022-09-26T14:16:00","slug":"itq%ec%97%91%ec%85%80-%ec%a0%9c1%ec%9e%91%ec%97%85-%ed%91%9c%ec%84%9c%ec%8b%9d-%ec%9e%91%ec%84%b1-%eb%b0%8f-%ea%b0%92-%ea%b3%84%ec%82%b0-3-rank-eq%ed%95%a8%ec%88%98-if%ed%95%a8%ec%88%98-right","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=536","title":{"rendered":"ITQ\uc5d1\uc140 &#8211; \uc81c1\uc791\uc5c5 \ud45c\uc11c\uc2dd \uc791\uc131 \ubc0f \uac12 \uacc4\uc0b0 &#8211; (3) Rank.EQ\ud568\uc218 , IF\ud568\uc218, Right\ud568\uc218, Left\ud568\uc218 , Mid\ud568\uc218"},"content":{"rendered":"\n<p>\uc548\ub155\ud558\uc138\uc694? \uc6c3\ub294 \uc0ac\uc790\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ube14\ub85c\uadf8\ub97c \uc2dc\uc791\ud55c\uc9c0 7\uc77c\uc774 \ub418\uc5c8\ub124\uc694. \uc544\uc9c1 ITQ\ud55c\uacfc\ubaa9\ubc16\uc5d0 \ub05d\ub0b4\uc9c0 \ubabb\ud574\uc11c \ub9d8\uc774 \uae09\ud558\uae30\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub798\ub3c4 \uc5ec\uc720\ub97c \uac00\uc9c0\uace0 \ud558\ub2e4\ubcf4\uba74 ITQ\uc138\uac1c\uc758 \uacfc\ubaa9\uc744 \uc5ec\ub7ec\ubc88 \uae30\ucd9c\uc744 \ud480\ub0a0\uc774 \uc624\uaca0\uc8e0 ^^<\/p>\n\n\n\n<p>\uc721\uc544 \ud1f4\uadfc\uc744 \ud558\uba74 \ub9ce\uc740 \uc0dd\uac01\uc744 \ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc624\ub298 \ud558\ub8e8 \uc885\uc77c \ub0b4\uac00 \uc544\uc774\uc5d0\uac8c \uc798\ud574\uc92c\ub098&#8230;\uc0ac\uc2e4 \uc624\ub298 \ubd84\ub178\uc870\uc808 \uc7a5\uc560\uac00 \uc628\uac83\uc774 \uc544\ub2cc\uac00 \uc2f6\uc740 \ub0a0\uc774\uc600\uac70\ub4e0\uc694.<\/p>\n\n\n\n<p>\uc544\uc774\ub294 \uc804\uc0dd\uc774 \uc6d0\uc218\ub77c\ub354\ub2c8&#8230; \uadf8\uac70 \ubcf5\uc218\ud558\ub7ec \uc624\ub298 \ub0a0\uc7a1\uc558\ub098 \uc2f6\ub354\ub77c\uad6c\uc694.. \uadf8\ub798\uc11c \ub9ce\uc774 \ud654\ub0c8\ub294\ub370<\/p>\n\n\n\n<p>\uc5d0\ud734&#8230; \uc790\uace0\uc788\ub294 \ubaa8\uc2b5\ubcf4\uba74 \ub531\ud558\uace0.. \uc624\ub298\uc740 \ub9d8\uc774 \uc880 \uadf8\ub7f0 \ubc24\uc785\ub2c8\ub2e4. \u315c\u315c \uc2ac\ud504\ub124\uc694&#8230;<\/p>\n\n\n\n<p>\uc9c0\uae08 \uc6b0\ub9ac\uac00 \uacf5\ubd80\ud558\uace0\uc788\ub294 \uac83\uc740&nbsp;<strong>ITQ\uc5d1\uc140 \uae30\ucd9c \ubb38\uc81c\uc911\uc5d0 2021109\ud68c\ucc28 A\ud615 \ubb38\uc81c<\/strong>\uc785\ub2c8\ub2e4.&nbsp;<\/p>\n\n\n\n<p>\uc5d1\uc140\uc758 \uaf43\uc740 \ud568\uc218\uc8e0 ^^&nbsp;<\/p>\n\n\n\n<p>\uc800\ub294 \ud568\uc218\uac00 \ucc38 \uc88b\ub354\ub77c\uad6c\uc694. \uc870\uae08\ub9cc \uc6d0\ub9ac\ub97c \uc54c\uba74 \ucc99\ucc99 \ub2e4 \uacc4\uc0b0\ud574\uc8fc\uace0 ^^<\/p>\n\n\n\n<p>\ud568\uc218 \ubb38\uc81c \uc870\uac74\uc744 \uc0b4\ud3b4 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>1) \uc778\uae30\uc21c\uc704 : \ud310\ub9e4\uc218\ub7c9\uc758 \ub0b4\ub9bc\ucc28\uc21c \uc21c\uc704\ub97c \uad6c\ud55c \uacb0\uacfc\uac12\uc5d0 &#8220;\uc704&#8221; \ub97c \ubd99\uc774\uc2dc\uc624.<\/p>\n\n\n\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (RANK.EQ\ud568\uc218, &amp; \uc5f0\uc0b0\uc790) \uacb0\uacfc \uac12 \uc608 : 1\uc704<\/p>\n\n\n\n<p>\uc790 \uadf8\ub7fc \uc21c\uc704 \ud558\uba74 \ub531 RANK\uc8e0 \uadf8\ub7f0\ub370 \uc804 \uc61b\ub0a0 \uc0ac\ub78c\uc774\ub77c \uadf8\ub7f0\uc9c0 \ubab0\ub77c\ub3c4 RANK.EQ\ud568\uc218 \uc790\uccb4\uac00 \ucc38 \uc0dd\uc18c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc804 \ub9cc\uc57d \uc800\ub807\uac8c \uc2dc\ud5d8\ubb38\uc81c\uac00 \ub098\uc654\ub294\ub370 \uc2dc\ud5d8\uc7a5 \uc774\uc600\ub2e4\uba74 \ub2f9\ud669\ud588\uc744\uaebc\uc5d0\uc694.<\/p>\n\n\n\n<p>\uc81c \uba38\ub9ac\uc18d\uc5d4<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/GDdkX\/btrgWEBzyfl\/T91RPPw2IgbdSkXf7EqPmk\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc774\ub7f0 RANK\ud568\uc218\ub9cc \uba38\ub9ac\uc5d0 \uc788\uac70\ub4e0\uc694. \uadf8\ub798\uc11c \ub0b4\ub9bc\ucc28\uc21c \uad6c\ud558\uc2dc\uc624. \ud558\uba74 0\uc744 \ub9c8\uc9c0\ub9c9 order\uc790\ub9ac\uc5d0 \ub123\uc5c8\uaca0\uc8e0.<\/p>\n\n\n\n<p>Rank.EQ\ud568\uc218\ub3c4 \ubcc4\uac70 \uc544\ub2c8\ub124\uc694 ^^ \uadf8\ub0e5 \ubc29\ubc95\uc740 \uac19\uc2b5\ub2c8\ub2e4. \uadf8\ub7fc \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc77c\ub2e8 \uc21c\uc704\ub77c\ub294 \uac74 \uc9c0\uae08 \ub0b4 \uc790\uc2e0\uc758 \uc21c\uc704\uac00 \uad81\uae08 \ud55c\uac70\uc796\uc544\uc694!!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/dvhRiH\/btrgXhznzJp\/tmPla0DqC3vUHIKFF7kbh0\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc804\uccb4 \ubc94\uc704\uc5d0\uc11c \ubc94\uc704\ub294 \ubcc0\ud558\uc9c0 \uc54a\uc544\uc11c \uace0\uc815 \uc774\uac83\uc774 \ubb34\uc2a8 \uc758\ubbf8\uc774\ub0d0\uba74!!<\/p>\n\n\n\n<p>\uc77c\ub2e8 \ub0b4\uac00 \uac00\uc218\ub77c\uace0 \uccd0\ubd05\uc2dc\ub2e4.&nbsp; \ubba4\uc9c1\ubc45\ud06c\uc5d0 \ub098\uac14\uc2b5\ub2c8\ub2e4. 10\uba85\uc911\uc5d0\uc11c \uba87\ub4f1\uc77c\uc9c0 \uc54c\uace0\uc2f6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8 10\uba85\uc774 \uc5b4\uca54\ub54c\ub294 BTS\uac00 \ud3ec\ud568\ub418\uace0 \uc5b4\uca54\ub54c\ub294 \ube60\uc9c0\uace0 \uadf8\ub7ec\ub294 \uac83\uc774 \uc544\ub2c8\ub77c<\/p>\n\n\n\n<p>\uadf8 10\uba85\uc774 \uace0\uc815\uc774\uace0 \uadf8 \uace0\uc815\ub0b4\uc5d0\uc11c \ub0b4\uac00 \uba87\ub4f1\uc778\uc9c0 \ud30c\uc545\uc744 \ud558\ub294\uac83\uc785\ub2c8\ub2e4. \uc54c\uae30\uc27d\uac8c \uc124\uba85\uc774 \ub418\uc5c8\ub098\uc694?<\/p>\n\n\n\n<p>\uace0\uc815\uc740 \uc5b4\ub5bb\uac8c \ud558\ub294\uac83\uc774\ub0d0!!!!!<\/p>\n\n\n\n<p>\ubc14\ub85c&nbsp;<strong>\uc808\ub300\ucc38\uc870 F4 \ub2e8\ucd95\ud0a4<\/strong>\ub97c \ub20c\ub7ec\uc90d\ub2c8\ub2e4. \uadf8\ub7fc&nbsp;<strong>$ \ud45c\uc2dc<\/strong>\uac00 \ubd99\ub294\ub370\uc694.&nbsp;<\/p>\n\n\n\n<p>\uc808\ub300\ucc38\uc870\ub97c \ud55c\uacbd\uc6b0\uc640 \ud558\uc9c0 \uc54a\uc558\uc744 \uacbd\uc6b0 \ube44\uad50\ud574\uc11c \uc54c\ub824\ub4dc\ub9b4\uac8c\uc694.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/ciOefW\/btrgYkQf4GM\/SXTmIR1P7BezqU7dyzvd2K\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc774\uac74 \uc808\ub300\ucc38\uc870 \ub97c \uc0ac\uc6a9\ud558\uc600\uc744 \uacbd\uc6b0\uc785\ub2c8\ub2e4.&nbsp;<strong>\uc808\ub300\ucc38\uc870F4\ud0a4\ub97c \uc774\uc6a9\ud574\uc11c \ubc94\uc704 \ubd80\ubd84\uc744 \uace0\uc815\ud574\uc8fc\uace0 \ucc44\uc6b0\uae30\ud578\ub4e4\uc744 \uc0ac\uc6a9<\/strong>\ud574\uc11c \uc544\ub798\ub85c \ub0b4\ub824\uc8fc\uba74 \uc778\uae30\uc21c\uc704\uac00 \ub450\ubc88\uc9f8 \ucc98\ub7fc \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uc790\uc138\ud788 \ud558\ub098\uc758 \uc140\uc744 \ud074\ub9ad\ud574\uc11c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/ZaXfj\/btrgYMeyPXx\/dKLLTIl7zJaJ596JhXpiFk\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc774\ub807\uac8c \uac01\uac01\uc758 \uc140\uc5d0 \uacb0\uacfc\uac12\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubc94\uc704\uac00 \uace0\uc815\uc774 \ub418\ub2c8 \uc778\uae30\uc21c\uc704\uac00 \uc21c\uc11c\ub300\ub85c \uc798 \ub098\ud0c0\ub098\uc8e0.<\/p>\n\n\n\n<p>\uadf8\ub7f0\ub370&nbsp;<strong>\uc808\ub300 \ucc38\uc870\ub97c \ud558\uc9c0 \uc54a\uace0 \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucc44\uc6b0\uba74!!!<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/vPntJ\/btrg0qJppgj\/3ovcpkBk2Wna9yJAW3AGFK\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc774\ub807\uac8c \uc21c\uc11c\ub3c4 \uc5c9\ub9dd\uc774\ub429\ub2c8\ub2e4. \uadf8\uc774\uc720\ub294&nbsp;<strong>\uc624\ub978\ucabd \uadf8\ub9bc\ucc98\ub7fc \ubc94\uc704\uac00 \ub2ec\ub77c\uc838\uc11c \uc21c\uc11c\ub97c \uc815\ud560 \uc22b\uc790\uac00 \uc0ac\ub77c\uc9c0\ub294\uac70\uc8e0!!<\/strong><\/p>\n\n\n\n<p>\uadf8\ub798\uc11c \uc808\ub300\ucc38\uc870\uac00 \uc5c4\uccad \uc911\uc694\ud55c\uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc808\ub300 \ucc38\uc870\ub97c \ud558\uae30 \uc2eb\ub2e4\uba74!!!! \uc804 \uadf8\ub7f0 \uae30\ub2a5 \ubabb\ud558\uc6a9\ud558\uaca0\uc5b4\uc694!! \ud558\uc2dc\uba74&#8230;..<\/p>\n\n\n\n<p>\uadf8\ub0e5 8\ubc88 Rank\ud568\uc218 \uc0ac\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4&#8230; \u315c\u315c<\/p>\n\n\n\n<p>\uadf8\ub7fc \uc808\ub300 \ucc38\uc870\ub97c \ud558\ub294<strong>&nbsp;F4 \ud0a4\ub294 \uc5b8\uc81c \ub204\ub974\ub0d0!!! $\ub97c \uc5b4\ub5bb\uac8c \ubd99\uc774\ub0d0!!!<\/strong><\/p>\n\n\n\n<p>ref \ubd80\ubd84<strong>&nbsp;\uc601\uc5ed\uc744 \uc7a1\uace0<\/strong>\ub098\uc11c \ubc14\ub85c<strong>&nbsp; F4\ud0a4\ub97c \ud55c\ubc88 \ub204\ub974\uba74 \ub429\ub2c8\ub2e4. \uc27d\uc8e0!!! ^^<\/strong><\/p>\n\n\n\n<p><strong>F4\ud0a4\ub97c \ub108\ubb34 \ub9ce\uc774 \ub204\ub974\uac8c\ub418\uba74 \uace0\uc815\ub418\ub294 \ubd80\ubd84\uc774 \ud589\uc774\ub418\uae30\ub3c4 \ud558\uace0 \uc5f4\uc774 \ub418\uae30\ub3c4 \ud558\uace0 \ubcc0\ud654\ud558\ub2c8&nbsp;\uaf2d $\ud45c\uc2dc\uac00 \ud589\uacfc \uc5f4\uc5d0 \ub2e4 \ubd99\ub3c4\ub85d 1\ubc88\ub9cc \ub20c\ub7ec\uc8fc\uc138\uc694!!!<\/strong><\/p>\n\n\n\n<p>\uadf8\ub7fc \uc774\uc81c&nbsp;<strong>\uc5f0\uc0b0\uc790 &amp;\uc758 \uc0ac\uc6a9<\/strong>\uc778\ub370\uc694. \ubd84\uba85 \ubb38\uc81c \uc870\uac74\uc5d0 \uc21c\uc11c\ub4a4\uc5d0 &#8220;\uc704&#8221; \uc790\ub97c \ubd99\uc774\ub77c\uace0 \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/REhls\/btrg3NiXC2G\/n9wE6zSMrMQoToujGjf8Rk\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc774\ub807\uac8c \ud568\uc218\uc2dd \ub4a4\uc5d0 &amp;\uc5f0\uc0b0\uc790\ub97c \uc368\uc8fc\uace0 \ud544\uc694\ud55c \uae00\uc790\ub97c \ud070\ub530\uc634\ud45c \uc548\uc5d0 \ub123\uc5b4\uc11c \uc368\uc8fc\uace0<\/p>\n\n\n\n<p>\ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4. \uac04\ub2e8\ud558\uac8c \ud574\uacb0\ud588\uc8e0 ^^<\/p>\n\n\n\n<p>Rank\ud568\uc218 \uae08\ubc29 \uc124\uba85\uc774 \ub05d\ub0a0\uc904 \uc54c\uc558\ub354\ub2c8 \ud560\ub9d0\uc774 \ub9ce\uc558\ub124\uc694.<\/p>\n\n\n\n<p>\uadf8\ub7fc \ub2e4\uc74c\uc73c\ub85c \ub118\uc5b4\uac00\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>2) \uc870\ub9ac\ubc29\ubc95 : \ubc18\ucc2c\ucf54\ub4dc\uc758 \ub9c8\uc9c0\ub9c9 \uae00\uc790\uac00 1\uc774\uba74 &#8220;\ubcf6\uc74c\/\uc870\ub9bc&#8221;. 2\uba74 &#8220;\ubb34\uce68&#8221;, \uadf8\uc678\uc5d0\ub294 &#8220;\ucc1c&#8221; \uc73c\ub85c \uad6c\ud558\uc138\uc694&nbsp;<\/p>\n\n\n\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (IF, RIGHT \ud568\uc218)<\/p>\n\n\n\n<p>\uc774\uc815\ub3c4 \uc870\uac74\uc774\uba74&#8230; \uac70\uc758 \ud568\uc218 \uc124\uba85\uc744 \uc870\uac74\uc774 \ub2e4 \ud574\uc900\uac70\ub098 \ub9c8\ucc2c\uac00\uc9c0 \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>IF\ud568\uc218 \uc124\uba85\uc744 \uc870\uac74\uc774 \ub2e4\ud574\uc92c\ub124\uc694. \u314e\u314e\u314e<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/dM2u7G\/btrg2MxUVof\/fRZkqGVLjOuDmbmaqj95NK\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc774\ub7f0 \uac04\ub2e8\ud55c \uc758\ubbf8\uc785\ub2c8\ub2e4. \ucc38 \uc27d\uc8e0 ^^&nbsp;<\/p>\n\n\n\n<p>\uadf8\ub7fc&nbsp;<strong>RIGHT \ud568\uc218<\/strong>\ub97c \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc0ac\uc2e4 \uc774 \ud568\uc218 \uac19\uc740 \uacbd\uc6b0\ub294&nbsp;3\uac00\uc9c0 \uacbd\uc6b0\uac00 \uc788\ub294\ub370\uc694.<\/p>\n\n\n\n<p><strong>LEFT \ud568\uc218, MID \ud568\uc218, RIGHT \ud568\uc218 \uc774\ub807\uac8c 3\uac00\uc9c0\ub85c \ubd84\ub958<\/strong>\uac00 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub7fc \ud558\ub098\uc529 \uc124\uba85\ub4dc\ub9b4\uac8c\uc694 ^^<\/p>\n\n\n\n<p>\ucc98\uc74c&nbsp;<strong>LEFT\ud568\uc218(Text, [num_chars])<\/strong>&nbsp;\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/bkfTzB\/btrg1ZYRKqL\/nqlo4pzzvFGLa5MqNNj9WK\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uac04\ub2e8\ud558\uc8e0 ^^<\/p>\n\n\n\n<p>&nbsp;<strong>RIGHT\ud568\uc218(Text, [num_chars])<\/strong>&nbsp;\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/xTbak\/btrg0qWYn8Y\/Ky9jyASUfVWwHKOrKWcS71\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c&nbsp;<strong>MID\ud568\uc218(Text, start_num, num_chars)<\/strong>&nbsp;\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\uc608\uc804\uc5d0\ub294 \uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638 7\ubc88\uc9f8 \uc790\ub9ac \uc22b\uc790\uac00 1,3\uc774\uba74 \ub0a8\uc790, 2,4\uba74 \uc5ec\uc790 \ub77c\uace0 \ud45c\uc2dc\ud574\uc8fc\uc138\uc694.<\/strong><\/p>\n\n\n\n<p><strong>\uc774\ub7f0\ubb38\uc81c\uac00 \ub098\uc62c\ub54c IF\ud568\uc218\uc640 \ud568\uaed8 Mid\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uace4\ud588\uc5c8\uc2b5\ub2c8\ub2e4. \uc9c0\uae08\ub3c4 \ub098\uc624\ub824\ub098??<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/x8LXm\/btrgXgN7Uqw\/OnNFheWFnPDhbvIk4jahn0\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uc790 \uadf8\ub7fc \ud568\uc218 \uc0ac\uc6a9\ubc29\ubc95\uc740 \uc54c\uc558\uc73c\ub2c8<\/p>\n\n\n\n<p>\ub450\ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \ubb38\uc81c\ub97c \ud574\uacb0\ud574\uc57c \uaca0\uc9c0\uc694 ^^<\/p>\n\n\n\n<p>\ub2e4\uc2dc \uc870\uac74\uc73c\ub85c \ub3cc\uc544\uc640\uc11c<\/p>\n\n\n\n<p>\uc870\ub9ac\ubc29\ubc95 : \ubc18\ucc2c\ucf54\ub4dc\uc758 \ub9c8\uc9c0\ub9c9 \uae00\uc790\uac00 1\uc774\uba74 &#8220;\ubcf6\uc74c\/\uc870\ub9bc&#8221;. 2\uba74 &#8220;\ubb34\uce68&#8221;, \uadf8\uc678\uc5d0\ub294 &#8220;\ucc1c&#8221; \uc73c\ub85c \uad6c\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc9c1\uc811 \ub2f5\uc5d0 \ub9de\uac8c \uc5ec\uae30\uc5d0 \uc368\ubcf4\uc790\uba74<\/p>\n\n\n\n<p>=IF(Right(B5,1)=&#8221;1&#8243;,&#8221;\ubcf6\uc74c\/\uc870\ub9bc&#8221;,if(Right(B5,1)=&#8221;2&#8243;,&#8221;\ubb34\uce68&#8221;,&#8221;\ucc1c&#8221;)) \uc774\ub807\uac8c&nbsp;<strong>\uc911\ucca9IF \ubb38<\/strong>\uc774 \ub098\uc624\uaca0\ub124\uc694.<\/p>\n\n\n\n<p>\uadf8\ub098\ub9c8&nbsp;<strong>\uacb0\uacfc\uac12\uc774 \uc885\ub958\uac00 3\uac1c\ub77c if\ub97c 2\ubc88 \uc0ac\uc6a9\ud588\uc9c0 4\uac1c\uc600\uc74c.. if\ub97c 3\ubc88 \uc0ac\uc6a9\ud574\uc57c\uaca0\uc8e0 ^^<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dn\/dLsxhT\/btrgWBq48j5\/78TOdOtvacnbGVp1lurKlK\/img.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\uac04\ub2e8\ud558\uc8e0 ^^&nbsp;<\/p>\n\n\n\n<p>=IF(Right(B5,1)=&#8221;1&#8243;,&#8221;\ubcf6\uc74c\/\uc870\ub9bc&#8221;,if(Right(B5,1)=&#8221;2&#8243;,&#8221;\ubb34\uce68&#8221;,&#8221;\ucc1c&#8221;))&lt;&lt;\uc880\ub354 \uc27d\uac8c \ubb36\uc5b4\ubcf4\uc790\uba74.<\/p>\n\n\n\n<p>\uc774\ub807\uac8c \ub9cc\uc57d \ubcf4\ub77c\uc0c9\uac12\uc774 \ub098\uc624\uba74, \ud30c\ub780\uc0c9\uc744 \ucd9c\ub825\ud558\uace0, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ucd08\ub85d\uc0c9\uc744 \ucd9c\ub825\ud574\ub77c.<\/p>\n\n\n\n<p>\uc774\uaca0\uc8e0. \uadf8\ub7f0\ub370 \uadf8 \ucd08\ub85d\uc0c9\uc5d0\ub3c4 \uc870\uac74\uc774 \uc788\uc2b5\ub2c8\ub2e4. 2\uba74 \ubb34\uce68, 3\uc774\uba74 \ucc1c\uc778\ub370.. 2\uac00\uc9c0\ub97c \ub3d9\uc2dc\uc5d0 \ucd9c\ub825\ud560\uc218 \uc5c6\uc73c\ub2c8 \ub098\ub220 \uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub798\uc11c \ucd08\ub85d\uc0c9\ub9cc \ubcf4\uc790\uba74&#8230;&nbsp;if(Right(B5,1)=&#8221;2&#8243;,&#8221;\ubb34\uce68&#8221;,&#8221;\ucc1c&#8221;)<\/p>\n\n\n\n<p>\uc55e\uc758 \ubcf4\ub77c\uc0c9\uc774 \uacb0\uacfc\ub85c \ub098\uc624\uba74 \ud30c\ub780\uc0c9\uc744 \ucd9c\ub825\ud558\uace0. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ucd08\ub85d\uc0c9\uc744 \ucd9c\ub825\ud558\ub77c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub611\uac19\uc740\uac8c \ub450\ubc88 \ub4e4\uc5b4\uac00\uc11c \uc6b0\ub9ac\uac00 \uc911\ucca9IF\ub77c\uace0 \ubd80\ub974\ub294 \uac70\uaca0\uc8e0 ^^<\/p>\n\n\n\n<p>\uadf8\ub7fc \uc624\ub298\uc740 \uc5ec\uae30\uae4c\uc9c0 \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubb38\uc81c 1\ubc88 2\ubc88 2\uac1c \ud478\ub294\ub370 \ubb54\uc124\uba85\uc744 \uc774\ub807\uac8c \ub9ce\uc774 \ud558\ub294\uc9c0 \ub2f5\ub2f5\ud558\uc2dc\uc8e0 \u3161.\u3161; \uadf8\ub798\ub3c4 \ub2e4 \ud53c\uac00 \ub418\uace0 \uc0b4\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud568\uc218\ub294 \uc7ac\ubbf8\uc788\uac70\ub4e0\uc694. ^^ \uc608\uc804\uc5d0 \ud68c\uc0ac\ub2e4\ub2c8\ub358 \ub3d9\uc0dd\uc774 \uc5b8\ub2c8 \uc5b4\ub5bb\uac8c \uc774\uac78 \uc5b4\ub5bb\uac8c \ud574\uc918\uc57c \uacb0\uacfc\ub97c \ub0b4\uac8c \ub9cc\ub4e4\uc5b4\uc57c\ud560\uc9c0 \ubaa8\ub974\uaca0\uc5b4 \uadf8\ub54c \uc81c\uac00 \ud568\uc218\ub85c \ud574\uacb0\ud574\uc92c\ub358&#8230;\u314e\u314e\u314e \uc81c\uc790\ub791\uc774\uc600\uc2b5\ub2c8\ub2e4.. \u314e\u314e\u314e<\/p>\n\n\n\n<p>\uadfc\ub370 \ub9ce\uc774 \uc78a\uc5b4\ubc84\ub838\ub124\uc694&#8230; \uc9c0\uae08\ub3c4 \uc774\ub807\uac8c \uc124\uba85\ub4dc\ub9ac\uba74\uc11c \ub2e4\uc2dc \uba38\ub9ac\uc18d\uc5d0\uc11c \ub044\uc9d1\uc5b4 \ub0b4\uace0\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uba38\ub9ac\ub294 \uc4f0\uba74 \uc4f8\uc218\ub85d \uc88b\uc544\uc9c0\uace0 \uce58\ub9e4\uc608\ubc29\ub3c4 \ub41c\ub2e4\ud558\ub2c8 \ub354 \uc368\ubcf4\ub835\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub7fc \uc774\uc81c \ubc24\ub3c4 \ub2a6\uc5c8\uc73c\ub2c8 \uc790\ub7ec \uac00\uc57c\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc5ec\ub7ec\ubd84 \ud798\ub0b4\uc138\uc694 ^^<\/p>\n\n\n<div class=\"taxonomy-post_tag wp-block-post-terms\"><a href=\"https:\/\/chaerang.net\/?tag=excel\" rel=\"tag\">#excel<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=if\" rel=\"tag\">#IF<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=itq\" rel=\"tag\">#ITQ<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=left\" rel=\"tag\">#left<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=mid\" rel=\"tag\">#mid<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=rank\" rel=\"tag\">#Rank<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=right\" rel=\"tag\">#Right<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=%ea%b8%b0%ec%b6%9c%eb%ac%b8%ec%a0%9c\" rel=\"tag\">#\uae30\ucd9c\ubb38\uc81c<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=%ea%b8%b0%ec%b6%9c%ed%92%80%ec%9d%b4\" rel=\"tag\">#\uae30\ucd9c\ud480\uc774<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/chaerang.net\/?tag=%ec%97%91%ec%85%80\" rel=\"tag\">#\uc5d1\uc140<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694? \uc6c3\ub294 \uc0ac\uc790\uc785\ub2c8\ub2e4. \ube14\ub85c\uadf8\ub97c \uc2dc\uc791\ud55c\uc9c0 7\uc77c\uc774 \ub418\uc5c8\ub124\uc694. \uc544\uc9c1 ITQ\ud55c\uacfc\ubaa9\ubc16\uc5d0 \ub05d\ub0b4\uc9c0 \ubabb\ud574\uc11c \ub9d8\uc774 \uae09\ud558\uae30\ub3c4 \ud569\ub2c8\ub2e4. \uadf8\ub798\ub3c4 \uc5ec\uc720\ub97c \uac00\uc9c0\uace0 \ud558\ub2e4\ubcf4\uba74 ITQ\uc138\uac1c\uc758 \uacfc\ubaa9\uc744 \uc5ec\ub7ec\ubc88 \uae30\ucd9c\uc744 \ud480\ub0a0\uc774 \uc624\uaca0\uc8e0 ^^ \uc721\uc544 \ud1f4\uadfc\uc744 \ud558\uba74 \ub9ce\uc740 \uc0dd\uac01\uc744 \ud558\uac8c \ub429\ub2c8\ub2e4. \uc624\ub298 \ud558\ub8e8 \uc885\uc77c \ub0b4\uac00 \uc544\uc774\uc5d0\uac8c \uc798\ud574\uc92c\ub098&#8230;\uc0ac\uc2e4 \uc624\ub298 \ubd84\ub178\uc870\uc808 \uc7a5\uc560\uac00 \uc628\uac83\uc774 \uc544\ub2cc\uac00 \uc2f6\uc740 \ub0a0\uc774\uc600\uac70\ub4e0\uc694. \uc544\uc774\ub294 \uc804\uc0dd\uc774 \uc6d0\uc218\ub77c\ub354\ub2c8&#8230; \uadf8\uac70 \ubcf5\uc218\ud558\ub7ec \uc624\ub298 \ub0a0\uc7a1\uc558\ub098 \uc2f6\ub354\ub77c\uad6c\uc694.. \uadf8\ub798\uc11c \ub9ce\uc774 \ud654\ub0c8\ub294\ub370 \uc5d0\ud734&#8230; \uc790\uace0\uc788\ub294 \ubaa8\uc2b5\ubcf4\uba74 \ub531\ud558\uace0.. \uc624\ub298\uc740 \ub9d8\uc774 \uc880 \uadf8\ub7f0 \ubc24\uc785\ub2c8\ub2e4. \u315c\u315c \uc2ac\ud504\ub124\uc694&#8230; \uc9c0\uae08 \uc6b0\ub9ac\uac00 \uacf5\ubd80\ud558\uace0\uc788\ub294 \uac83\uc740&nbsp;ITQ\uc5d1\uc140 \uae30\ucd9c \ubb38\uc81c\uc911\uc5d0 2021109\ud68c\ucc28 A\ud615 \ubb38\uc81c\uc785\ub2c8\ub2e4.&nbsp; \uc5d1\uc140\uc758 \uaf43\uc740 \ud568\uc218\uc8e0 ^^&nbsp; \uc800\ub294 \ud568\uc218\uac00 \ucc38 \uc88b\ub354\ub77c\uad6c\uc694. \uc870\uae08\ub9cc \uc6d0\ub9ac\ub97c \uc54c\uba74 \ucc99\ucc99 \ub2e4 \uacc4\uc0b0\ud574\uc8fc\uace0 ^^ \ud568\uc218 \ubb38\uc81c \uc870\uac74\uc744 \uc0b4\ud3b4 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. 1) \uc778\uae30\uc21c\uc704 : \ud310\ub9e4\uc218\ub7c9\uc758 \ub0b4\ub9bc\ucc28\uc21c \uc21c\uc704\ub97c \uad6c\ud55c \uacb0\uacfc\uac12\uc5d0 &#8220;\uc704&#8221; \ub97c \ubd99\uc774\uc2dc\uc624. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (RANK.EQ\ud568\uc218, &amp; \uc5f0\uc0b0\uc790) \uacb0\uacfc \uac12 \uc608 : 1\uc704 \uc790 \uadf8\ub7fc \uc21c\uc704 \ud558\uba74 \ub531 RANK\uc8e0 \uadf8\ub7f0\ub370 \uc804 \uc61b\ub0a0 \uc0ac\ub78c\uc774\ub77c \uadf8\ub7f0\uc9c0 \ubab0\ub77c\ub3c4 RANK.EQ\ud568\uc218 \uc790\uccb4\uac00 \ucc38 \uc0dd\uc18c\ud569\ub2c8\ub2e4. \uc804 \ub9cc\uc57d \uc800\ub807\uac8c \uc2dc\ud5d8\ubb38\uc81c\uac00 \ub098\uc654\ub294\ub370 \uc2dc\ud5d8\uc7a5 \uc774\uc600\ub2e4\uba74 \ub2f9\ud669\ud588\uc744\uaebc\uc5d0\uc694. \uc81c \uba38\ub9ac\uc18d\uc5d4 \uc774\ub7f0 RANK\ud568\uc218\ub9cc \uba38\ub9ac\uc5d0 \uc788\uac70\ub4e0\uc694. \uadf8\ub798\uc11c \ub0b4\ub9bc\ucc28\uc21c \uad6c\ud558\uc2dc\uc624. \ud558\uba74 0\uc744 \ub9c8\uc9c0\ub9c9 order\uc790\ub9ac\uc5d0 \ub123\uc5c8\uaca0\uc8e0. Rank.EQ\ud568\uc218\ub3c4 \ubcc4\uac70 \uc544\ub2c8\ub124\uc694 ^^ \uadf8\ub0e5 \ubc29\ubc95\uc740 \uac19\uc2b5\ub2c8\ub2e4. \uadf8\ub7fc \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc77c\ub2e8 \uc21c\uc704\ub77c\ub294 \uac74 \uc9c0\uae08 \ub0b4 \uc790\uc2e0\uc758 \uc21c\uc704\uac00 \uad81\uae08 \ud55c\uac70\uc796\uc544\uc694!! \uc804\uccb4 \ubc94\uc704\uc5d0\uc11c \ubc94\uc704\ub294 \ubcc0\ud558\uc9c0 \uc54a\uc544\uc11c \uace0\uc815 \uc774\uac83\uc774 \ubb34\uc2a8 \uc758\ubbf8\uc774\ub0d0\uba74!! \uc77c\ub2e8 \ub0b4\uac00 \uac00\uc218\ub77c\uace0 \uccd0\ubd05\uc2dc\ub2e4.&nbsp; \ubba4\uc9c1\ubc45\ud06c\uc5d0 \ub098\uac14\uc2b5\ub2c8\ub2e4. 10\uba85\uc911\uc5d0\uc11c \uba87\ub4f1\uc77c\uc9c0 \uc54c\uace0\uc2f6\uc2b5\ub2c8\ub2e4. \uadf8 10\uba85\uc774 \uc5b4\uca54\ub54c\ub294 BTS\uac00 \ud3ec\ud568\ub418\uace0 \uc5b4\uca54\ub54c\ub294 \ube60\uc9c0\uace0 \uadf8\ub7ec\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \uadf8 10\uba85\uc774 \uace0\uc815\uc774\uace0 \uadf8 \uace0\uc815\ub0b4\uc5d0\uc11c \ub0b4\uac00 \uba87\ub4f1\uc778\uc9c0 \ud30c\uc545\uc744 \ud558\ub294\uac83\uc785\ub2c8\ub2e4. \uc54c\uae30\uc27d\uac8c \uc124\uba85\uc774 \ub418\uc5c8\ub098\uc694? \uace0\uc815\uc740 \uc5b4\ub5bb\uac8c \ud558\ub294\uac83\uc774\ub0d0!!!!! \ubc14\ub85c&nbsp;\uc808\ub300\ucc38\uc870 F4 \ub2e8\ucd95\ud0a4\ub97c \ub20c\ub7ec\uc90d\ub2c8\ub2e4. \uadf8\ub7fc&nbsp;$ \ud45c\uc2dc\uac00 \ubd99\ub294\ub370\uc694.&nbsp; \uc808\ub300\ucc38\uc870\ub97c \ud55c\uacbd\uc6b0\uc640 \ud558\uc9c0 \uc54a\uc558\uc744 \uacbd\uc6b0 \ube44\uad50\ud574\uc11c \uc54c\ub824\ub4dc\ub9b4\uac8c\uc694. \uc774\uac74 \uc808\ub300\ucc38\uc870 \ub97c \uc0ac\uc6a9\ud558\uc600\uc744 \uacbd\uc6b0\uc785\ub2c8\ub2e4.&nbsp;\uc808\ub300\ucc38\uc870F4\ud0a4\ub97c \uc774\uc6a9\ud574\uc11c \ubc94\uc704 \ubd80\ubd84\uc744 \uace0\uc815\ud574\uc8fc\uace0 \ucc44\uc6b0\uae30\ud578\ub4e4\uc744 \uc0ac\uc6a9\ud574\uc11c \uc544\ub798\ub85c \ub0b4\ub824\uc8fc\uba74 \uc778\uae30\uc21c\uc704\uac00 \ub450\ubc88\uc9f8 \ucc98\ub7fc \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uc790\uc138\ud788 \ud558\ub098\uc758 \uc140\uc744 \ud074\ub9ad\ud574\uc11c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \uac01\uac01\uc758 \uc140\uc5d0 \uacb0\uacfc\uac12\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \ubc94\uc704\uac00 \uace0\uc815\uc774 \ub418\ub2c8 \uc778\uae30\uc21c\uc704\uac00 \uc21c\uc11c\ub300\ub85c \uc798 \ub098\ud0c0\ub098\uc8e0. \uadf8\ub7f0\ub370&nbsp;\uc808\ub300 \ucc38\uc870\ub97c \ud558\uc9c0 \uc54a\uace0 \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucc44\uc6b0\uba74!!! \uc774\ub807\uac8c \uc21c\uc11c\ub3c4 \uc5c9\ub9dd\uc774\ub429\ub2c8\ub2e4. \uadf8\uc774\uc720\ub294&nbsp;\uc624\ub978\ucabd \uadf8\ub9bc\ucc98\ub7fc \ubc94\uc704\uac00 \ub2ec\ub77c\uc838\uc11c \uc21c\uc11c\ub97c \uc815\ud560 \uc22b\uc790\uac00 \uc0ac\ub77c\uc9c0\ub294\uac70\uc8e0!! \uadf8\ub798\uc11c \uc808\ub300\ucc38\uc870\uac00 \uc5c4\uccad \uc911\uc694\ud55c\uac83\uc785\ub2c8\ub2e4. \uc808\ub300 \ucc38\uc870\ub97c \ud558\uae30 \uc2eb\ub2e4\uba74!!!! \uc804 \uadf8\ub7f0 \uae30\ub2a5 \ubabb\ud558\uc6a9\ud558\uaca0\uc5b4\uc694!! \ud558\uc2dc\uba74&#8230;.. \uadf8\ub0e5 8\ubc88 Rank\ud568\uc218 \uc0ac\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4&#8230; \u315c\u315c \uadf8\ub7fc \uc808\ub300 \ucc38\uc870\ub97c \ud558\ub294&nbsp;F4 \ud0a4\ub294 \uc5b8\uc81c \ub204\ub974\ub0d0!!! $\ub97c \uc5b4\ub5bb\uac8c \ubd99\uc774\ub0d0!!! ref \ubd80\ubd84&nbsp;\uc601\uc5ed\uc744 \uc7a1\uace0\ub098\uc11c \ubc14\ub85c&nbsp; F4\ud0a4\ub97c \ud55c\ubc88 \ub204\ub974\uba74 \ub429\ub2c8\ub2e4. \uc27d\uc8e0!!! ^^ F4\ud0a4\ub97c \ub108\ubb34 \ub9ce\uc774 \ub204\ub974\uac8c\ub418\uba74 \uace0\uc815\ub418\ub294 \ubd80\ubd84\uc774 \ud589\uc774\ub418\uae30\ub3c4 \ud558\uace0 \uc5f4\uc774 \ub418\uae30\ub3c4 \ud558\uace0 \ubcc0\ud654\ud558\ub2c8&nbsp;\uaf2d $\ud45c\uc2dc\uac00 \ud589\uacfc \uc5f4\uc5d0 \ub2e4 \ubd99\ub3c4\ub85d 1\ubc88\ub9cc \ub20c\ub7ec\uc8fc\uc138\uc694!!! \uadf8\ub7fc \uc774\uc81c&nbsp;\uc5f0\uc0b0\uc790 &amp;\uc758 \uc0ac\uc6a9\uc778\ub370\uc694. \ubd84\uba85 \ubb38\uc81c \uc870\uac74\uc5d0 \uc21c\uc11c\ub4a4\uc5d0 &#8220;\uc704&#8221; \uc790\ub97c \ubd99\uc774\ub77c\uace0 \ud588\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ud568\uc218\uc2dd \ub4a4\uc5d0 &amp;\uc5f0\uc0b0\uc790\ub97c \uc368\uc8fc\uace0 \ud544\uc694\ud55c \uae00\uc790\ub97c \ud070\ub530\uc634\ud45c \uc548\uc5d0 \ub123\uc5b4\uc11c \uc368\uc8fc\uace0 \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4. \uac04\ub2e8\ud558\uac8c \ud574\uacb0\ud588\uc8e0 ^^ Rank\ud568\uc218 \uae08\ubc29 \uc124\uba85\uc774 \ub05d\ub0a0\uc904 \uc54c\uc558\ub354\ub2c8 \ud560\ub9d0\uc774 \ub9ce\uc558\ub124\uc694. \uadf8\ub7fc \ub2e4\uc74c\uc73c\ub85c \ub118\uc5b4\uac00\uaca0\uc2b5\ub2c8\ub2e4. 2) \uc870\ub9ac\ubc29\ubc95 : \ubc18\ucc2c\ucf54\ub4dc\uc758 \ub9c8\uc9c0\ub9c9 \uae00\uc790\uac00 1\uc774\uba74 &#8220;\ubcf6\uc74c\/\uc870\ub9bc&#8221;. 2\uba74 &#8220;\ubb34\uce68&#8221;, \uadf8\uc678\uc5d0\ub294 &#8220;\ucc1c&#8221; \uc73c\ub85c \uad6c\ud558\uc138\uc694&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (IF, RIGHT \ud568\uc218) \uc774\uc815\ub3c4 \uc870\uac74\uc774\uba74&#8230; \uac70\uc758 \ud568\uc218 \uc124\uba85\uc744 \uc870\uac74\uc774 \ub2e4 \ud574\uc900\uac70\ub098 \ub9c8\ucc2c\uac00\uc9c0 \uc785\ub2c8\ub2e4. IF\ud568\uc218 \uc124\uba85\uc744 \uc870\uac74\uc774 \ub2e4\ud574\uc92c\ub124\uc694. \u314e\u314e\u314e \uc774\ub7f0 \uac04\ub2e8\ud55c \uc758\ubbf8\uc785\ub2c8\ub2e4. \ucc38 \uc27d\uc8e0 ^^&nbsp; \uadf8\ub7fc&nbsp;RIGHT \ud568\uc218\ub97c \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc0ac\uc2e4 \uc774 \ud568\uc218 \uac19\uc740 \uacbd\uc6b0\ub294&nbsp;3\uac00\uc9c0 \uacbd\uc6b0\uac00 \uc788\ub294\ub370\uc694. LEFT \ud568\uc218, MID \ud568\uc218, RIGHT \ud568\uc218 \uc774\ub807\uac8c 3\uac00\uc9c0\ub85c \ubd84\ub958\uac00 \ub429\ub2c8\ub2e4. \uadf8\ub7fc \ud558\ub098\uc529 \uc124\uba85\ub4dc\ub9b4\uac8c\uc694 ^^ \ucc98\uc74c&nbsp;LEFT\ud568\uc218(Text, [num_chars])&nbsp;\uc785\ub2c8\ub2e4. \uac04\ub2e8\ud558\uc8e0 ^^ &nbsp;RIGHT\ud568\uc218(Text, [num_chars])&nbsp;\uc785\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c&nbsp;MID\ud568\uc218(Text, start_num, num_chars)&nbsp;\uc785\ub2c8\ub2e4. \uc608\uc804\uc5d0\ub294 \uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638 7\ubc88\uc9f8 \uc790\ub9ac \uc22b\uc790\uac00 1,3\uc774\uba74 \ub0a8\uc790, 2,4\uba74 \uc5ec\uc790 \ub77c\uace0 \ud45c\uc2dc\ud574\uc8fc\uc138\uc694. \uc774\ub7f0\ubb38\uc81c\uac00 \ub098\uc62c\ub54c IF\ud568\uc218\uc640 \ud568\uaed8 Mid\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uace4\ud588\uc5c8\uc2b5\ub2c8\ub2e4. \uc9c0\uae08\ub3c4 \ub098\uc624\ub824\ub098?? \uc790 \uadf8\ub7fc \ud568\uc218 \uc0ac\uc6a9\ubc29\ubc95\uc740 \uc54c\uc558\uc73c\ub2c8 \ub450\ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \ubb38\uc81c\ub97c \ud574\uacb0\ud574\uc57c \uaca0\uc9c0\uc694 ^^ \ub2e4\uc2dc \uc870\uac74\uc73c\ub85c \ub3cc\uc544\uc640\uc11c \uc870\ub9ac\ubc29\ubc95 : \ubc18\ucc2c\ucf54\ub4dc\uc758 \ub9c8\uc9c0\ub9c9 \uae00\uc790\uac00 1\uc774\uba74 &#8220;\ubcf6\uc74c\/\uc870\ub9bc&#8221;. 2\uba74 &#8220;\ubb34\uce68&#8221;, \uadf8\uc678\uc5d0\ub294 &#8220;\ucc1c&#8221; \uc73c\ub85c \uad6c\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc9c1\uc811 \ub2f5\uc5d0 \ub9de\uac8c \uc5ec\uae30\uc5d0 \uc368\ubcf4\uc790\uba74 =IF(Right(B5,1)=&#8221;1&#8243;,&#8221;\ubcf6\uc74c\/\uc870\ub9bc&#8221;,if(Right(B5,1)=&#8221;2&#8243;,&#8221;\ubb34\uce68&#8221;,&#8221;\ucc1c&#8221;)) \uc774\ub807\uac8c&nbsp;\uc911\ucca9IF \ubb38\uc774 \ub098\uc624\uaca0\ub124\uc694. \uadf8\ub098\ub9c8&nbsp;\uacb0\uacfc\uac12\uc774 \uc885\ub958\uac00 3\uac1c\ub77c if\ub97c 2\ubc88 \uc0ac\uc6a9\ud588\uc9c0 4\uac1c\uc600\uc74c.. if\ub97c 3\ubc88 \uc0ac\uc6a9\ud574\uc57c\uaca0\uc8e0 ^^ \uac04\ub2e8\ud558\uc8e0 ^^&nbsp; =IF(Right(B5,1)=&#8221;1&#8243;,&#8221;\ubcf6\uc74c\/\uc870\ub9bc&#8221;,if(Right(B5,1)=&#8221;2&#8243;,&#8221;\ubb34\uce68&#8221;,&#8221;\ucc1c&#8221;))&lt;&lt;\uc880\ub354 \uc27d\uac8c \ubb36\uc5b4\ubcf4\uc790\uba74. \uc774\ub807\uac8c \ub9cc\uc57d \ubcf4\ub77c\uc0c9\uac12\uc774 \ub098\uc624\uba74, \ud30c\ub780\uc0c9\uc744 \ucd9c\ub825\ud558\uace0, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ucd08\ub85d\uc0c9\uc744 \ucd9c\ub825\ud574\ub77c. \uc774\uaca0\uc8e0. \uadf8\ub7f0\ub370 \uadf8 \ucd08\ub85d\uc0c9\uc5d0\ub3c4 \uc870\uac74\uc774 \uc788\uc2b5\ub2c8\ub2e4. 2\uba74 \ubb34\uce68, 3\uc774\uba74 \ucc1c\uc778\ub370.. 2\uac00\uc9c0\ub97c \ub3d9\uc2dc\uc5d0 \ucd9c\ub825\ud560\uc218 \uc5c6\uc73c\ub2c8 \ub098\ub220 \uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c \ucd08\ub85d\uc0c9\ub9cc \ubcf4\uc790\uba74&#8230;&nbsp;if(Right(B5,1)=&#8221;2&#8243;,&#8221;\ubb34\uce68&#8221;,&#8221;\ucc1c&#8221;) \uc55e\uc758 \ubcf4\ub77c\uc0c9\uc774 \uacb0\uacfc\ub85c \ub098\uc624\uba74 \ud30c\ub780\uc0c9\uc744 \ucd9c\ub825\ud558\uace0. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ucd08\ub85d\uc0c9\uc744 \ucd9c\ub825\ud558\ub77c\uc785\ub2c8\ub2e4. \ub611\uac19\uc740\uac8c \ub450\ubc88 \ub4e4\uc5b4\uac00\uc11c \uc6b0\ub9ac\uac00 \uc911\ucca9IF\ub77c\uace0 \ubd80\ub974\ub294 \uac70\uaca0\uc8e0 ^^ \uadf8\ub7fc \uc624\ub298\uc740 \uc5ec\uae30\uae4c\uc9c0 \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ubb38\uc81c 1\ubc88 2\ubc88 2\uac1c \ud478\ub294\ub370 \ubb54\uc124\uba85\uc744 \uc774\ub807\uac8c \ub9ce\uc774 \ud558\ub294\uc9c0 \ub2f5\ub2f5\ud558\uc2dc\uc8e0 \u3161.\u3161; \uadf8\ub798\ub3c4 \ub2e4 \ud53c\uac00 \ub418\uace0 \uc0b4\uc774 \ub429\ub2c8\ub2e4. \ud568\uc218\ub294 \uc7ac\ubbf8\uc788\uac70\ub4e0\uc694. ^^ \uc608\uc804\uc5d0 \ud68c\uc0ac\ub2e4\ub2c8\ub358 \ub3d9\uc0dd\uc774 \uc5b8\ub2c8 \uc5b4\ub5bb\uac8c \uc774\uac78 \uc5b4\ub5bb\uac8c \ud574\uc918\uc57c \uacb0\uacfc\ub97c \ub0b4\uac8c \ub9cc\ub4e4\uc5b4\uc57c\ud560\uc9c0 \ubaa8\ub974\uaca0\uc5b4 \uadf8\ub54c \uc81c\uac00 \ud568\uc218\ub85c \ud574\uacb0\ud574\uc92c\ub358&#8230;\u314e\u314e\u314e \uc81c\uc790\ub791\uc774\uc600\uc2b5\ub2c8\ub2e4.. \u314e\u314e\u314e \uadfc\ub370 \ub9ce\uc774 \uc78a\uc5b4\ubc84\ub838\ub124\uc694&#8230; \uc9c0\uae08\ub3c4 \uc774\ub807\uac8c \uc124\uba85\ub4dc\ub9ac\uba74\uc11c \ub2e4\uc2dc \uba38\ub9ac\uc18d\uc5d0\uc11c \ub044\uc9d1\uc5b4 \ub0b4\uace0\uc788\uc2b5\ub2c8\ub2e4. \uba38\ub9ac\ub294 \uc4f0\uba74 \uc4f8\uc218\ub85d \uc88b\uc544\uc9c0\uace0 \uce58\ub9e4\uc608\ubc29\ub3c4 \ub41c\ub2e4\ud558\ub2c8 \ub354 \uc368\ubcf4\ub835\ub2c8\ub2e4. \uadf8\ub7fc \uc774\uc81c \ubc24\ub3c4 \ub2a6\uc5c8\uc73c\ub2c8 \uc790\ub7ec \uac00\uc57c\uaca0\uc2b5\ub2c8\ub2e4. \uc5ec\ub7ec\ubd84 \ud798\ub0b4\uc138\uc694 ^^<\/p>\n","protected":false},"author":2,"featured_media":537,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5],"tags":[52,84,19,86,87,83,85,21,22,51],"class_list":["post-536","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itq-","tag-excel","tag-if","tag-itq","tag-left","tag-mid","tag-rank","tag-right","tag-21","tag-22","tag-51"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=536"}],"version-history":[{"count":1,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":538,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions\/538"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/537"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}