¾È³çÇϼ¼¿ä? Àü¿µ¼± ȸ¿ø´Ô!!
IT ÀڰݽÃÇè ¿Â¶óÀÎ °ÀÇ, ÃÖ°! ±â»çÄ£±¸ ÀÔ´Ï´Ù.
¹®ÀÇÇϽг»¿ë¿¡ ´äº¯µå¸³´Ï´Ù. ^^
»ç¿ø¹øÈ£ÀÇ 5¹øÂ° ÀÚ¸®¼ýÀÚ°¡ 0À̸é "»ç¿ø" 1À̸é "´ë¸®" 2À̸é "°úÀå" =IF(MID(A3,5,1)="0","»ç¿ø",IF(MID(A3,5,1)="1","´ë¸®","°úÀå"))
¿ì¼± MID ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© A3¼¿ÀÇ 5¹øÂ°ºÎÅÍ 1ÀÚ¸¦ ÃßÃâÇÕ´Ï´Ù. IF ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© ÃßÃâµÈ À̰ªÀÌ "0"(»ç¿ø) ÀÎÁö ºñ±³ÇÕ´Ï´Ù.
¸¸ÀÏ "0"À̸é ÂüÀ̹ǷΠÂüÀÏ ¶§ °ª "»ç¿ø"À» ÃÖÁ¾¹ÝȯÇϰí ÇÔ¼ö¸¦ Á¾·áÇÕ´Ï´Ù. ¸¸ÀÏ °ÅÁþÀ̶ó¸é Çѹø´õ IFÇÔ¼ö¿Í MID ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© ¾ÕÀÇ °úÁ¤À» ¹Ýº¹ÇÕ´Ï´Ù.
»ç¿ø¹øÈ£ 5¹øÂ° 1ÀÚ¸® °ªÀÌ "1" À̸é "´ë¸®" ·Î ±×·¸Áö ¾ÊÀ¸¸é "0" µµ ¾Æ´Ï°í "1" µµ ¾Æ´Ï¹Ç·Î "2"À̰ÚÁö¿ä. °á±¹ µÎ¹øÀÇ Á¶°ÇÀ» ¸ðµÎ ¸¸Á·ÇÏÁö ¾Ê´Â´Ù¸é "°úÀå" À» ¹ÝȯÇÕ´Ï´Ù.
¿©±â¼ ¹®ÀÇÇϽŠºÎºÐÀÇ ÇÙ½ÉÀº ù ¹øÂ° ÃßÃâ°ªÀÎ »ç¿øÀ϶§, Âü°ú °ÅÁþÀ¸·Î ³ª´µ¾îÁø ÈÄ °ÅÁþÀÎ °æ¿ì ¶Ç Âü("1" ´ë¸®)°ú °ÅÁþ("2" °úÀå)À¸·Î ³ª´µ¾îÁ®¾ß ÇϹǷΠÇѹø ´õ È¥ÇÕÇÔ¼ö°¡ »ç¿ëµÇ¾îÁø °ÍÀÔ´Ï´Ù. ÀÌÇØ°¡ µÇ¼Ì³ª¿ä?
´Ù¸¥ ¹®ÀÇ»çÇ×ÀÌ ÀÖÀ¸½Ã¸é ¾ðÁ¦µçÁö Áú¹®Áֽñ⠹ٶø´Ï´Ù. ^^
½Ò½ÒÇØÁø ³¯¾¾¿¡ °Ç°°ü¸®¿¡ À¯ÀÇÇÏ½Ã°í ¿°øÇϽʽÿÀ. ÈÀÌÆÃ!! °¨»çÇÕ´Ï´Ù.
ÄÄȰ2±Þ ±âÃâÀ¯Çü A °è»êÀÛ¾÷1¹ø¿¡¼
»ç¿ø¹øÈ£ÀÇ 5¹øÂ° ÀÚ¸®¼ýÀÚ°¡ 0À̸é "»ç¿ø" 1À̸é "´ë¸®" 2À̸é "°úÀå" À϶§ ÇÔ¼ö½Ä ´äÀÌ
=IF(MID(A3,5,1)="0","»ç¿ø",IF(MID(A3,5,1)="1","´ë¸®","°úÀå")) À̰ǵ¥¿ä
=IF(MID(A3,5,1)="0","»ç¿ø","1","´ë¸®","2","°úÀå") ÀÌ ÇÔ¼ö½ÄÀº ¿Ö ¾ÈµÇÁÒ?
¿Ö IF ÇÔ¼ö¸¦ µÎ¹øÀ̳ª ¾²´ÂÁö ÀÌÇØ°¡ ¾È°¡³×¿ä |