|
|||||
- Link #1 : view.php?no=418151 |
À׿©·ÂÀ» ¹ßµ¿ÇÏ¿© ÇÑ °¡Áö ÇعýÀ» ã¾Æº¸¾Ò½À´Ï´Ù. excel¿¡ ÀÌ·¸°Ô ³Ö¾îº¸¼¼¿ä. A1¼¿: 820000000 C1¼¿: 75 B1¼¿: =MIN(((C1/20+84)*A1)/100,((C1/20-92)*A1)/(-100))+1
±×¸®°í, A1°ú C1¿¡ ¿øÇÏ´Â °ªÀ» ³ÖÀ¸½Ã¸é µË´Ï´Ù. ±×·¯¸é B1¼¿¿¡ ¼ö½Ä¿¡ ÀÇÇÏ¿© B1 °á°ú°ªÀÌ ¿øÇÏ´Â °ªÀÌ °è»êµÇ¾î ³ª¿Ã°Å¿¡¿ä.
´Ü ÷¿¡ Á¦½ÃÇϽŠ½Ä¿¡ 80-20* ¶ó´ø°¡ (88/100 - B/A)100 À̶ó´ø°¡ ¼ýÀÚ³ª ½ÄÀÌ ¹Ù²î¸é ¾ÈµË´Ï´Ù. ±×·¯¸é min( ) ¾È¿¡ µé¾î°¡´Â ¼ö½ÄÀÌ ¹Ù²î¾î¾ß ÇÕ´Ï´Ù. Ãßõ:roggy´ÔÀÌ °Ô½Ã¹°À» ÁÁ¾ÆÇÕ´Ï´Ù. Ãßõ:µµ¸®¼ø_ººÀ½Áö¸§½Å´ÔÀÌ °Ô½Ã¹°À» ÁÁ¾ÆÇÕ´Ï´Ù. Ãßõ:°ßÁö²Û |
| ||
| ||
| ||