£±¡¢¤½¤â¤½¤âExcel¤Ë¤¢¤ë”´Ø¿ô”¤È¤Ï°ìÂΤʤˤ«
”´Ø¿ô”¤È¸«Ê¹¤¤·¤Æ¡¢”¿ô³Ø”¤ÈÏ¢ÁÛ¤µ¤ì¤¿Êý¤â¤¤¤é¤Ã¤·¤ã¤ë¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
³Î¤«¤Ë´Ø¿ô¤ÏExcel¤Ç»È¤¨¤ë·×»»¼°¤Ë°ã¤¤¤Ï¤¢¤ê¤Þ¤»¤ó¤¬¡¢¿ô³Ø¤Ç°·¤ï¤ì¤ëÈùʬ¡¦ÀÑʬ¤Î¤è¤¦¤Ë¤ä¤ä¤³¤·¤¯Æñ¤·¤¤¤â¤Î¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
Excel¤Ë¤ª¤±¤ë´Ø¿ô¤È¤Ï¾®Æñ¤·¤¯¸À¤¨¤Ð¡¢¡ÖExcel¤Ç¤¢¤é¤«¤¸¤áÄêµÁ¤µ¤ì¤Æ¤¤¤ë¿ô¼°¡×¤È¤Ê¤ê¤Þ¤¹¡£
¤·¤«¤·¤³¤ì¤Ç¤Ï;·×¤Ë¶ì¼ê°Õ¼±¤¬¶¯¤Þ¤ê¤Þ¤¹¤Î¤Ç¡¢¤³¤³¤Ï´Êñ¤Ëɽ¤·¤Þ¤¹¡£
¡Ö¡¡Excel¤Î´Ø¿ô¤Ï¡¢Ê£»¨¤Ê·×»»¤ò´Êñ¤Ë¤Ç¤¤ë¤â¤Î¡¡¡×
°ìȯ¤ÇÁí¹ç·×¤ò½Ð¤·¤¿¤ê¡¢²¿É´¤È¤¢¤ëÇä¤ê¾å¤²¿ôÃͤÎÃ椫¤éºÇÂç¤ÎÇä¤ê¾å¤²¿ôÃͤÀ¤±¤ò½Ð¤·¤¿¤ê¤È¡¢¼êÆ°¤ËÍê¤ë¤Ë¤ÏÈó¸úΨŪ¤Ê·×»»½èÍý¤ò¼êÁ᤯´Êñ¤Ë¹Ô¤¨¤Þ¤¹¡£
¤Þ¤¿°ìÅÙºî¤Ã¤¿´Ø¿ô¤Ï·«¤êÊÖ¤·ÍøÍѤ¬²Äǽ¤Ç¤¹¡£
Excel¡¡2013¤È¤¤¤¦¥Ð¡¼¥¸¥ç¥ó¤Ç¤Ï¤³¤Î´Ø¿ô¡¢¤Ê¤ó¤È450¸Ä°Ê¾å¤âÍÑ°Õ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¤½¤ì¤Û¤É¿ô¿¤¯ÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë´Ø¿ô¤Ç¤¹¤¬¡¢´ðËܤκî¤ê¤Ï¤³¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¡¡¡ÀèƬ¤Ë¡Ö¡á¡Ê¥¤¥³¡¼¥ë¡Ë¡×¤¬¤¢¤ë¤³¤È¤Ë¤è¤Ã¤ÆExcel¤Ë”¤³¤ì¤Ï·×»»¼°¤Ç¤¢¤ë”¤Èǧ¼±¤µ¤»¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹
¢¡¡·è¤Þ¤Ã¤¿·×»»½èÍý¤ò¹Ô¤¦¤¿¤á¤Ë¤Ä¤±¤é¤ì¤¿Ì¾Á°¤Ç¤¹¡£¹ç·×¤Ê¤é¡ÖSUM¡Ê¥µ¥à¡Ë¡×¡¢Ê¿¶Ñ¤Ê¤é¡ÖAVERAGE¡Ê¥¢¥Ù¥ì¡¼¥¸¡Ë¡×¤È¤¢¤é¤«¤¸¤á·è¤Þ¤Ã¤¿Ì¾Á°¤¬¤¢¤ê¤Þ¤¹
£¡¡¤«¤Ã¤³¤ÎÆâÉô¤Ï¤½¤ì¤¾¤ì¤Î´Ø¿ô¤¬·×»»½èÍý¤ËɬÍפʾðÊó¤òÁª¤ó¤À¤ê¡¢ÆþÎϤ·¤¿¤ê¤¹¤ë¸Ä½ê¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹
ÀèƬ¤Ë¡Ö¡á¡Ê¥¤¥³¡¼¥ë¡Ë¡×¤¬¤¢¤ê¡¢´Ø¿ô̾¤¬Íè¤ë¤Î¤Ï¶¦Ä̤Ǥ¹¡£
¤µ¤¹¤¬¤Ë¤¹¤Ù¤Æ¤Î´Ø¿ô¤ò»È¤¤¤³¤Ê¤¹¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¤¬¡¢¤½¤ÎÃæ¤Ç¤â½ñÎàºîÀ®»þ¤Ë³èÌö¤·¤Æ¤¯¤ì¤ë´Ø¿ô¤¬¤¢¤ê¤Þ¤¹¡£
¤½¤Î¤¦¤Á¤Î£±¤Ä¤¬¡¢º£²ó¼è¤ê¾å¤²¤Þ¤¹¡Ú¡¡IF´Ø¿ô¡¡¡Û¤Ç¤¹¡£
£²¡¢¡Ú¡¡IF´Ø¿ô¡¡¡Û¤È¤Ï¤É¤¦¤¤¤Ã¤¿´Ø¿ô¤Ê¤Î¤«
IF´Ø¿ô¤È¤Ï¤É¤¦¤¤¤Ã¤¿½èÍý¤ò¤·¤Æ¤¯¤ì¤ë¤Î¤«¡£
¤³¤Î´Ø¿ô¤Ç¤Ï¡Ú¡¡¤â¤·¤â¡Á¤Ê¤é¡¢¡ü¡ü¤ò¤·¤Ê¤µ¤¤¡£¤â¤·°ã¤Ã¤¿¤é¡¢×פò¤·¤Ê¤µ¤¤¡£¡¡¡Û¤È¤¤¤Ã¤¿¡¢¾ò·ï¤Ë´ð¤Å¤¯½èÍý¤ò¹Ô¤ï¤»¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
»ÈÍѾìÌ̤ʤɤϡÖ
£³¡¢¤³¤ó¤Ê¾ìÌ̤dzèÌö¡ª¡Ú¡¡IF´Ø¿ô¡¡¡Û¤Ç²÷Ŭ½ñÎàºîÀ®¡×¤Çµ½Ò¤·¤Þ¤¹¤¬¡¢´ðËܹ½À®¤Ï¤³¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¡…´Ø¿ô̾¡Ö£É£Æ¡×¤òɽ¼¨¤·¤Æ¤¤¤Þ¤¹¡£
¢…¡Ö¤â¤·¤â¡Á¤Ê¤é¡×¤È¤¤¤Ã¤¿¾ò·ï¼°¤òÆþÎϤ·¤Þ¤¹¡£
£…¢¤Ç»ØÄꤷ¤¿¼°¤¬”¤½¤ÎÄ̤ê¤Ç¤¢¤ë”¾ì¹ç¤Ëɽ¼¨¤¹¤ë·ë²Ì¤òÆþÎϤ·¤Þ¤¹¡£
¤…¢¤Ç»ØÄꤷ¤¿¼°¤¬”¤â¤·°ã¤Ã¤Æ¤¤¤¿”¾ì¹ç¤Ëɽ¼¨¤¹¤ë·ë²Ì¤òÆþÎϤ·¤Þ¤¹¡£
º£²ó¤ÎIF´Ø¿ô¤Î¤è¤¦¤Ë¡¢Ê£¿ô¸Ä½ê¤Ç¡Ö,¡ÊȾ³Ñ¥«¥ó¥Þ¡Ë¡×¤Ç¶èÀÚ¤é¤ì¤ë¤è¤¦¤Ê´Ø¿ô¤Ïfx¥Ü¥¿¥ó¤«¤éɽ¼¨¤µ¤ì¤ë¥¦¥£¥ó¥É¥¦¤ò»ÈÍѤ¹¤ë¤È¤¦¤Þ¤¯ÆþÎϤǤ¤Þ¤¹¡£
IF´Ø¿ô¤ÎÁÞÆþ¤Î»ÅÊý¤Ï¼¡¤ÎÄ̤ê¤Ç¤¹¡£
£±¡Ëfx¥Ü¥¿¥ó¤ò²¡¤·¡¢¡Ö´Ø¿ô¤Î¸¡º÷¡×Íó¤Ë¡ÖÏÀÍý¡×¤ÈÆþÎϤ·¸¡º÷³«»Ï¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¤Þ¤¹
¢¨¡ÖÏÀÍý¡×¤È¤Ï¤¿¤¯¤µ¤ó¤¢¤ë´Ø¿ô¤ò¥«¥Æ¥´¥ê¤·¤Æ¤¢¤ëÃæ¤Ç¡¢IF´Ø¿ô¤¬¤¢¤ë¥«¥Æ¥´¥ê̾¤Ç¤¹¡£
£²¡Ë¡Ö´Ø¿ô̾¡×Íó¤Ë¡ÖIF¡×¤Èɽ¼¨¤µ¤ì¤ë¤Î¤Ç¡¢¡ÖIF¡×¤ò¥¯¥ê¥Ã¥¯¸å¡¢OK¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¤Þ¤¹
£³¡Ë¡Ö´Ø¿ô¤Î°ú¿ô¡×¤È¤¤¤¦¥¦¥£¥ó¥É¥¦¤ËÀÚ¤êÂؤï¤ê¤Þ¤¹¤Î¤Ç¡¢ÏÀÍý¼°¡¢¿¿¤Î¾ì¹ç¡¢µ¶¤Î¾ì¹ç¤È¤½¤ì¤¾¤ìÆþÎϤ·OK¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¤Þ¤¹
¡Ú¡¡´Ø¿ô¤Î°ú¿ô¥¦¥£¥ó¥É¥¦¡¡¡Û
£³¡¢¤³¤ó¤Ê¾ìÌ̤dzèÌö¡ª¡Ú¡¡IF´Ø¿ô¡¡¡Û¤Ç²÷Ŭ½ñÎàºîÀ®
´ðËܹ½À®¤¬¤ï¤«¤Ã¤¿¤È¤³¤í¤Ç¡¢IF´Ø¿ô¤ò»ÈÍѤ·¤¿²÷Ŭ½ñÎàºîÀ®µ»¤ò²òÀ⤷¤Þ¤¹¡ª
º£²ó¼¡¤Î¥â¥Ç¥ë¤ò»ÈÍѤ·¤Æ¡¢¥µ¥ó¥×¥ë¼°¤Çµ»¤ò²òÀ⤷¤Æ¤¤¤¤Þ¤¹¡£
¤³¤Î¥â¥Ç¥ë¤Î¤¦¤Á¡¢¡ÖNo.¡×Íó¤Ë¼«Æ°Åª¤ËÏ¢ÈÖ¤¬¿¶¤é¤ì¤ëIF´Ø¿ô¼°¤Ï¡Ö
²÷Ŭµ»£±¡Ã¼«Æ°¤ÇÏ¢ÈÖ¤ò¿¶¤ë¤è¤¦¤Ë¤¹¤ë¡×¤Ç²òÀ⤷¤Þ¤¹¡£
¡Ö¹ç·×¡×Íó¤Ç¤Ï¡¢Ã±²Á¤ä¸Ä¿ô¤¬Ì¤ÆþÎϤξì¹ç¥¼¥í¤òɽ¼¨¤·¤Ê¤¤¤è¤¦¤Ë¤¹¤ëIF´Ø¿ô¼°¤ò¡Ö
²÷Ŭµ»£²¡Ã¥¨¥é¡¼¤Ê¤É¤ÎÈóɽ¼¨¤Ç¸«¤¿ÌܤòÈþ¤·¤¯¤¹¤ë¡×¤Ç²òÀ⤷¤Þ¤¹¡£
²÷Ŭµ»£±¡Ã¼«Æ°¤ÇÏ¢ÈÖ¤ò¿¶¤ë¤è¤¦¤Ë¤¹¤ë
¡Ö£±¡¢£²¡¢£³…¡×¤È¤¤¤Ã¤¿Ï¢ÈÖ¤¬É¬ÍפˤʤëºÝ¡¢¥ª¡¼¥È¥Õ¥£¥ëµ¡Ç½¤Ê¤É¤ò»ÈÍѤ¹¤ì¤Ð¼êÁ᤯ÆþÎϤ¹¤ë¤³¤È¤Ï²Äǽ¤Ç¤¹¡£
¼êÁᤤ¤Î¤Ç¤¹¤¬¡¢¤è¤êÀµ³Î¤Ë³Ú¤ËÆþÎϤò¤¹¤ë¤Ë¤ÏIF´Ø¿ô¤ò»È¤¦¤ÈÊØÍø¤Ç¤¹¡£
¼«Æ°¤ÇÏ¢ÈÖ¤ò¿¶¤ë¤è¤¦¤Ë¤¹¤ë¾ì¹ç¡¢°Ê²¼¤Î¥µ¥ó¥×¥ë¤Î¤è¤¦¤ÊIF´Ø¿ô¼°¤òÁȤßΩ¤Æ¤Þ¤¹¡£
¡Ú¡¡Excel²èÌÌ¡¡¡Û¢¨²èÌ̤ÏExcel¡¡2010¤Ç¤¹
¤³¤ÎIF´Ø¿ô¼°¤òɬÍפʸĽê¤Ë¥³¥Ô¡¼¤·¤ÆŽ¤êÉÕ¤±¤Æ¤ª¤±¤Ð¡¢¼¡¤Î»þ¤Ë¤ÏºÇ½é¤Î¥»¥ë¤Ë¿ô»ú¤òÆþÎϤ¹¤ë¤À¤±¤Ç¼«Æ°Åª¤ËÏ¢ÈÖ¤¬É½¼¨¤µ¤ì¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£
¤³¤ì¤Ë¤è¤ê¡¢¼êÆ°¤ÇÏ¢ÈÖ¤ò¿¶¤Ã¤¿¤ê¡¢Ç¤°Õ¤Î¿ô»ú¤«¤é¤ÎÏ¢È֤Τ¿¤á¤ÎÄ´À°¤È¤¤¤Ã¤¿¼ê´Ö¤¬¾Ê¤±¤Þ¤¹¡£
¡¦ËèÅ٤Υª¡¼¥È¥Õ¥£¥ë¤Ê¤É¤Ë¤è¤ë¼êÆ°Ï¢ÈÖ
¡¦Ç¤°Õ¤Î¿ô»ú¤«¤é¤ÎÏ¢ÈÖÄ´À°
²÷Ŭµ»£²¡Ã¥¨¥é¡¼¤Ê¤É¤ÎÈóɽ¼¨¤Ç¸«¤¿ÌܤòÈþ¤·¤¯¤¹¤ë
¤¢¤é¤«¤¸¤á¹ç·×¤ò½Ð¤¹¤È¤¤¤Ã¤¿·×»»¼°¤òÆþÎϤ·¤Æ¤¤¤ë¥»¥ë¤Ï¡¢É¬ÍפʿôÃͤʤɤ¬ÆþÎϤµ¤ì¤Æ¤¤¤Ê¤¤¤È£°¡Ê¥¼¥í¡Ë¤òɽ¼¨¤·¤Þ¤¹¡£
¾¤Ë¤â¥¨¥é¡¼¡Ê¡ôDIV/0!¤Ê¤É¡Ë¤¬É½¼¨¤µ¤ì¤ë¤³¤È¤â¤¢¤ë¤Ç¤·¤ç¤¦¡£
¤½¤¦¤¤¤Ã¤¿¥¨¥é¡¼¤Ê¤É¤Îɽ¼¨¤ò¡¢IF´Ø¿ô¤ò»ÈÍѤ¹¤ë¤ÈÈóɽ¼¨¤Ë¤·¸«¤¿ÌܤòÈþ¤·¤¯¤Ç¤¤Þ¤¹¡£
¥¨¥é¡¼¤Ê¤É¤òÈóɽ¼¨¤Ë¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢°Ê²¼¤Î¥µ¥ó¥×¥ë¤Î¤è¤¦¤ÊIF´Ø¿ô¼°¤òÁȤßΩ¤Æ¤Þ¤¹¡£
¡Ú¡¡Excel²èÌÌ¡¡¡Û
¤â¤È¤â¤È¤Î·×»»¼°¤Ïºï½ü¤µ¤ì¤Þ¤»¤ó¤Î¤Ç¡¢É¬ÍפʿôÃͤʤɤòÆþÎϤ¹¤ì¤Ð·ë²Ì¤Ï¤Ð¤Ã¤Á¤êɽ¼¨¤µ¤ì¤Þ¤¹¡£
¤³¤ì¤Ë¤è¤ê¡¢É½¼¨¤·¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¤¿¤á¤Î¶ìÏ«¤ò¤·¤Ê¤¯¤ÆºÑ¤ß¤Þ¤¹¡£
¡¦¥¨¥é¡¼¤Ê¤É¤Îɽ¼¨¤ò±£¤¹¤¿¤á¤Î¶ìÏ«
¡¦ËèÅÙ¿ô¼°¤Ê¤É¤ò¥³¥Ô¡¼¤·¤ÆŽ¤êÉÕ¤±
°Ê¾å¡¢£³¤Ä¤Î¥Ñ¡¼¥È¤Ç´ðËÜŪ¤Ê»È¤¤Êý¤«¤é³èÍÑË¡¤Þ¤Ç¤ò²òÀ⤷¤Þ¤·¤¿¡£
º£¸åIF´Ø¿ô¤ò»ÈÍѤ¹¤ë¾ìÌ̤¬¤¢¤ê¤Þ¤·¤¿¤é¡¢¤¼¤ÒÀѶËŪ¤Ë»ÈÍѤ·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£