÷ºÎµÈ »çÁø ó·³..
µî±Þ(B2)À» µå·Ó¹Ú½º·Î ±¸¼ºÇҰǵ¥¿ä..
Æ÷ÀÎÆ®(B4)°¡ µî±Þ(B2)°ú ¿¬µµ(B3)¿¡ µû¶ó Áõ°¡ÇϵÇ, ÇÑ°èÄ¡¸¦ µÎ´Â °æ¿ì(¿¬µµ°¡ ¹«ÇÑÁ¤ Áõ°¡ÇÏ´õ¶óµµ ÇÑ°èÄ¡¸¦ ÃÊ°úÇÏÁö ¾Ê°í ÇÑ°èÄ¡·Î ÀԷµǵµ·Ï)¸¦ ÇÔ¼ö·Î ±¸¼ºÇÏ·Á°í Çϴµ¥¿ä.. ³Ê¹« ¾î·Æ³×¿ä ¤Ð_¤Ð
À§ Á¶°Ç¿¡ ¸Âµµ·Ï C4¿¡ ¸Â´Â ÇÔ¼ö°ªÀ» ¾Ë·ÁÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù~!!! | |
|
c4¿¡ =IF(C2=\"a\",800+2000+C3,IF(C2=\"B\",1000+2000+C3,0)) ÀÌ·¸°Ô ¾²½Ã°í
c5¿¡ =IF(AND(C2=\"a\",C4>1000),1000,IF(AND(C2=\"b\",C4>1200),1200,0))
Á¦¸Ó¸®ÀÇ ÇÑ°è³×¿ä ¤Ð¤Ð¤»
¼öÁ¤ ÀÌ·¸°Ô ÇÏ¸é ¾ÈµÇ°Ú³×¿ä ¤Ð¤Ð
c4¿¡ =IF(C2=\"a\",800+2000+C3,IF(C2=\"B\",1000+2000+C3,0)) ÀÌ·¸°Ô ¾²½Ã°í
c5¿¡ =IF(AND(C2=\"a\",C4>=1000),1000,IF(AND(C2=\"a\",C4<1000),c4,IF(AND(C2=\"b\",C4>=1200),1200,if(c2=\"b\",c4<1200),c4,0))))
¸¹Àº ÆÁÀÌ µÇ¾ú½À´Ï´Ù!!