ȸ¿ø ¹æ¹® ¼ö |
8,351,587 ¸í |
Á¢¼Ó Àοø ¼ö |
190 ¸í |
| |
|
Ȩ > ¹¯°í´äÇϱâ |
[Re]ÇÔ¼ö¿Í °ü·ÃÇÑ ±ÞÁú¹®µå¸³´Ï´Ù. |
¾È³çÇϼ¼¿ä.
´ÙÀ½°ú °°Àº ¼ö½ÄÀ» ÀÌ¿ëÇÏ½Ã¸é µË´Ï´Ù.
=IF((MID(Áֹεî·Ï¹øÈ£,8,1)=5) OR (MID(Áֹεî·Ï¹øÈ£,8,1)=6),0,±Þ¿©*0.45%)
ÀÌÇØÇϽðÚÁö¿ä.
Áֹεî·Ï¹øÈ£ÀÇ 8¹ø° ¼ýÀÚ°¡ 5 ¶Ç´Â 6ÀÏ °æ¿ì 0À» ¾Æ´Ï¸é ±Þ¿©¿¡ 0.45%¸¦ ±¸ÇÏ´Â °ÍÀÔ´Ï´Ù.
¹°·Ð ¼ö½Ä¿¡ ¡°Áֹεî·Ï¹øÈ£¡±·Î ÀÔ·ÂÇÏ½Ã¸é ¾ÈµÇ°í Áֹεî·Ï¹øÈ£°¡ ÀÔ·ÂµÈ ¼¿ ÁÖ¼Ò¸¦ ÀÔ·ÂÇÏ¼Å¾ß ÇÏ°í ¡°±Þ¿©¡±µµ ¸¶Âù°¡ÁöÀÔ´Ï´Ù.
±×·³ Àß µÇ½Ã±æ....
|
ÀÛ¼ºµÈ ÄÚ¸àÆ®°¡ ¾ø½À´Ï´Ù.
|
| |
|
|
|