ÇÔ¼ö ³Ê¹« ¾î·Á¿ö¿ä... IFÇÔ¼ö´Â ½ÃÇè¿¡ ¾È³ª¿À³ª¿ä??
ÇÔ¼öµéÁß¿¡¼ ½ÃÇè¿¡ ³ª¿À´Â ÇÔ¼öµéÁ» ¾Ë·ÁÁÖ¼¼¿ä... ¾î¶²ÇÔ¼öµéÀ» ÀÌÇØÇϰí ÀÖÀ¸¸é µÇ³ª¿ä??±Û°í ½ÃÇè¿¡ ÇÔ¼ö¸î¹®Á¦ ³ª¿À´ÂÁö??¾Ë·ÁÁÖ¼¼¿ä..
------------------------------>>>>>>>
³×^^
¿¢¼¿¿¡¼ ÇÔ¼ö°¡ °¡Àå ¾î·Æ´Ù°íµé ÇÕ´Ï´Ù~
ÇÏÁö¸¸ ÇÔ¼ö¸¦ ¼÷ÁöÇÏÁö ¾Ê°í¼´Â ÇÕ°ÝÀÌ ¾î·Æ½À´Ï´Ù.
ifÇÔ¼ö ³ª¿É´Ï´Ù^^
Çʼö·Î
IF, SUMIF, AVERAGEIF, COUNTIF, COUNTA, VLOOKUP, HLOOKUP
²À ÇÏ½Ã°í ³ª¸ÓÁö ÇÔ¼öµéµµ °øºÎ¸¦ ÇϽñ⠹ٶø´Ï´Ù.±×¸®°í
ÇöÀç ÃâÁ¦µÇ°í ÀÖ´Â ÇÔ¼öÀÇ ¹®Ç×Àº 4~6¹®Á¦ Á¤µµÀÔ´Ï´Ù.
°¨»çÇÕ´Ï´Ù~¿°øÇϼ¼¿ä^^*
|