¾È³çÇϼ¼¿ä °í°´´Ô
ºñÁîÆû ¼½ÄÁö¿ø¼ºñ½º ´ã´çÀÚÀÔ´Ï´Ù.
ÇØ´ç ÇÁ·Î±×·¥Àº ÀÌ¹Ì ¼Ò¼öÀÚ¸®´Â °è»êÀÌ µÇÁö ¾Êµµ·Ï ´Ü°¡¿¡ ¼¿ Çü½ÄÀÌ ÁöÁ¤µÇ¾î ÀÖ½À´Ï´Ù.
°í°´´Ô²²¼ ¸»¾¸ÇϽŠºÎºÐÀº ÀÏÀÇ ÀÚ¸® µî¿¡¼ 0À¸·Î ³»¸²ÇÏ½Ã´Â°É ¸»¾¸ÇϽô°¡¿ä?
ºÎ°¡¼¼ºÎºÐ¿¡ RounddownÀ» Àû¿ëÇÏ¿© ÀÏÀÇ ÀÚ¸®¿¡¼ 0À¸·Î ³»¸²Çϵµ·Ï ¼³Á¤Çسõ¾Ò½À´Ï´Ù.
¼ö½Ä ºÎºÐ¿¡ ÀÏÀÇ ÀÚ¸®°¡ ¾Æ´Ñ ½ÊÀÇ ÀÚ¸®·Î ÇϽ÷Á¸é
=ROUNDDOWN(IF(DB!$K$2=1,(E10*F10)-((E10*F10)/1.1),IF(DB!$K$2=2,G10*10%,0)),-1)
Áß¿¡¼ °¡Àå µÚÀÇ -1À» -2·Î ¹Ù²Ù½Ã¸é µË´Ï´Ù.(ÀÏ, ½Ê, ¹éÀÇ ÀÚ¸®·Î ¹Ù²Ü¼ö·Ï -1, -2, -3¾¿ ¹Ù²Ù½Ã¸é µË´Ï´Ù.)
¸¶Âù°¡Áö·Î ÇÕ°è/ÀÜ¾× ºÎºÐµµ RounddownÀ» »ç¿ëÇϽ÷Á¸é
=ROUNDDOWN(G10+H10,-1)·Î ÇÕ°è ºÎºÐÀ» º¯°æÇÏ½Ã¸é µÇ°Ú½À´Ï´Ù.
´Ù¸¥ ¹®ÀÇ»çÇ×ÀÌ ÀÖÀ¸½Ã¸é [¼½ÄÁö¿ø¼ºñ½º]¸¦ ÅëÇØ
¹®ÀÇÇØ Áֽøé Á¤¼º²¯ ´äº¯ µå¸®°Ú½À´Ï´Ù.
¸ñ·Ïº¸±â>
|