½Å¿ëÄ«µå °¡°èºÎ ¸¸µé°í ÀÖ½À´Ï´Ù.
±Ùµ¥ ¿¢¼¿ ÇÔ¼ö¸¦ ±âº»ÀûÀΰ͹ۿ¡´Â »ç¿ëÇÏÁö ¸øÇØ ¾î·Á¿òÀÌ ÀÖ³×¿ä ¤Ð¤Ð
ÀÌ·± °æ¿ì ¾î¶² ÇÔ¼ö¸¦ »ç¿ëÇØ¾ß ÇÒÁö ¹®Àǵ帳´Ï´Ù
Ä«µå »ç¿ë±Ý¾×ÀÇ 10%¸¦ Æ÷ÀÎÆ®·Î Àû¸³ÇØÁÖ´Â°É ¿¢¼¿·Î Á¤¸®ÇÏ·Á°í ÇÕ´Ï´Ù.
10¸¸¿øÀ» ¾²¸é 1¸¸¿øÀÔ´Ï´Ù. ´Ù¸¸ Æ÷ÀÎÆ® Àû¸³ Çѵµ°¡ 10%, µü 1¸¸¿ø ÀÔ´Ï´Ù.
°áÁ¦±Ý¾× ¼¿¿¡ 10¸¸¿øÀ» ±âÀÔÇϸé Æ÷ÀÎÆ®Àû¸³ ¼¿¿¡ 1¸¸Á¡ÀÌ µü ³ª¿À´Âµ¥ ¹®Á¦´Â 20¸¸¿øÀ» ±âÀÔÇϸé 2Á¡ 30¸¸¿øÀ̸é 3¸¸Á¡ ÀÌ·¸°Ô ³ª¿É´Ï´Ù
(´ç¿¬ÇÑ°ÅÁÒ ..)
±×·¡¼ Àû¸³Çѵµ¸¦ 1¸¸¿øÀ» Çѵµ·Î ÁöÁ¤ÇÏ°í ½ÍÀºµ¥ ±×¶§ ÇÊ¿äÇÑ ÇÔ¼ö°¡ ¾î¶²°Ô ÀÖÀ»±î¿ä ...?
20¸¸¿ø 30¸¸¿øÀ» ±âÀÔÇصµ 1¸¸¿ø¾Æ·¡·Î¸¸ ³ª¿À°Ô ÇÏ°í ½Í¾î¿ä |
A1¿¡ »ç¿ë±Ý¾×À» ³Ö´Â´Ù¸é
=IF(A1*0.1<10000,A1*0.1,10000)
»ç¿ë±Ý¾×ÀÇ 10%°¡ ¸¸¿ø ÀÌÇϸé 10%, ¸¸¿ø ÀÌ»óÀÌ¸é ¸¸¿ø
Çغ¸´Ï IF ÇÔ¼öµµ µÇ°í MIN°ú sustitute ÇÔ¼ö¸¦ ½á¼ Ç¥Çöµµ µÇ³×¿ä ...