ȸ»ç¿¡ º¸¾ÈÀÌ °É·Á¼ ÆÄÀÏÀ» ´Ù½Ã º¸³»µå¸± ¼ö°¡ ¾ø³×¿ä..
154¶óÀÎÀÇ Á÷ºÒÄ«µå »ç¿ë¾×¿¡ ´ëÇÑ °è»ê»ê½ÄÀ»
=IF(ISERROR(IF(AF153<0,0,MIN(ROUNDDOWN(AF153*((M154/AF154)*25%),0),3000000,Ãѱ޿©¾×*20%))),0,IF(AF153<0,0,MIN(ROUNDDOWN(AF153*(M154/AF154*25%),0),3000000,Ãѱ޿©¾×*20%)))
·Î ¼öÁ¤Çغ¸¾Ò½À´Ï´Ù.
È®Àιٶø´Ï´Ù.
|