²á¤´¤·¤ä¤¹¤¤Æü¤¬Â³¤¤¤Æ¤¤¤Þ¤¹¤Í¡£
¤·¤«¤·º£Ç¯¤ÏÇß±«Æþ¤ê¤¬Áá¤Þ¤Ã¤Æ¤¤¤ë´¶¤¸¤Ç¤·¤ç¤¦¤«¤Í¡©
Åìµþ¤â´Ö¤â¤Ê¤¯Çß±«Æþ¤ê¤¹¤ë¤Î¤«¤âÃΤì¤Þ¤»¤ó¤Í¡£
¤µ¤Æ¡¢ÅÐÏ¿ÌȵöÀǤÎǼÉդ˴ؤ·¤Æ¤Ç¤¹¤¬¡¢»ä¤Î¾ì¹ç¡¢ÅеÈñÍѤò¶ä¹Ô¿¶¹þ¤Ç¼õ¤±¼è¤Ã¤¿¾ì¹ç¤ÏÅÅ»ÒǼÉդǡ¢¸½¶â¤Ç¼õ¤±¼è¤Ã¤¿¾ì¹ç¤Ï°õ»æ¤ÇǼÉÕ¤¹¤ë¤Î¤ò´ðËܤȤ·¤Æ¤¤¤Þ¤¹¡£
¤½¤·¤Æ°õ»æ¤Ë´Ø¤·¤Æ¤Ï¡¢Í¹ÊضɤǹØÆþ¤ò¤·¤Æ¤¤¤Þ¤¹¡£
°õ»æ¤ò¹ØÆþ¤¹¤ëºÝ¤Ç¤¹¤¬¡¢Í¹ÊضɤÎÁë¸ý¤Ë¼«ºî¤Î°õ»æ¤Î¶â¼ï¤ÈËç¿ô¤òµºÜ¤·¤¿ÍÑ»æ¤ò½Ð¤·¤Æ¹ØÆþ¤·¤Æ¤¤¤Þ¤¹¡£
ÍÑ»æ¤ÏExcel¤ÇºîÀ®¤·¤¿B6¤ÎÍÑ»æ¤Ç¤¹¡£
¤³¤ó¤Ê´¶¤¸¡£
Ëç¿ôÍó¤ËËç¿ô¤òÆþÎϤ¹¤ë¤È¶â³Û¤¬¼«Æ°·×»»¤µ¤ì¤ë¤è¤¦¤Ë¤·¤Æ¤¢¤ë¤Î¤Ç¡¢´Ö°ã¤¤¤â¤¢¤ê¤Þ¤»¤ó¡£
¥Á¥ç¥Ã¥È¤³¤À¤ï¤Ã¤Æ¤¤¤ëÉôʬ¤¬¤¢¤ê¤Þ¤·¤Æ¡£
ºÇ½é¤Î²èÁü¤ò¸«¤Æ¤¤¤¿¤À¤¯¤Èʬ¤«¤ê¤Þ¤¹¤¬¡¢¾®·×Íó¤ä¹ç·×Íó¤Ë;·×¤Ê¡Ö¡ï£°¡×¤¬µºÜ¤µ¤ì¤Ê¤¤¤è¤¦¤Ë¤·¤Æ¤¢¤ê¤Þ¤¹¡£
E5¤Î¥»¥ë¤Ëñ½ã¤Ê°Ê²¼¤Î¤è¤¦¤Ê¼°¤òÆþ¤ì¤Æ¤ß¤ë¤È¡¢
¡Ö¡ï£°¡×¤¬µºÜ¤µ¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤½¤³¤Ç¡ÖIF´Ø¿ô¡×¤ò»È¤¤¡¢°Ê²¼¤Î¤è¤¦¤Ê¼°¤òÆþ¤ì¤Æ¤ß¤Þ¤¹¡£
¤½¤¦¤¹¤ë¤È¡¢ºÇ½é¤Î²èÁü¤Î¤è¤¦¤Ë¡Ö¡ï£°¡×¤¬µºÜ¤µ¤ì¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£
¤³¤ÎE5¤Î¥»¥ë¤ËÆþÎϤò¤·¤¿¼°¤Î°ÕÌ£¤Ç¤¹¤¬¡¢¡Ö¤â¤·D5¤Î¥»¥ë¤¬¶õÇò¤À¤Ã¤¿¤é¶õÇò¤È¤·¡¢¤½¤¦¤Ç¤Ï¤Ê¤«¤Ã¤¿¤éC5¡ßD5¤Î·ë²Ì¤òɽ¼¨¤¹¤ë¡×¤È¸À¤¦ÆâÍƤˤʤäƤ¤¤Þ¤¹¡£
¤Ä¤Þ¤ê¡¢Ëç¿ôÍ󤬶õÍó¤Î¾ì¹ç¤Ï¾®·×Íó¤â¶õÍó¤Ë¤Ê¤ê¡¢Ëç¿ô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ì¤Ð¾®·×Íó¤Ë·×»»·ë²Ì¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£
Excel¤â´Ø¿ô¤¬»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ë¤À¤±¤Ç¡¢ºîÀ®¤Ç¤¤ë¥·¡¼¥È¤ÎÉý¤¬¹¤¬¤ê¤Þ¤¹¤è¤Í¡£
¤·¤«¤·º£Ç¯¤ÏÇß±«Æþ¤ê¤¬Áá¤Þ¤Ã¤Æ¤¤¤ë´¶¤¸¤Ç¤·¤ç¤¦¤«¤Í¡©
Åìµþ¤â´Ö¤â¤Ê¤¯Çß±«Æþ¤ê¤¹¤ë¤Î¤«¤âÃΤì¤Þ¤»¤ó¤Í¡£
¤µ¤Æ¡¢ÅÐÏ¿ÌȵöÀǤÎǼÉդ˴ؤ·¤Æ¤Ç¤¹¤¬¡¢»ä¤Î¾ì¹ç¡¢ÅеÈñÍѤò¶ä¹Ô¿¶¹þ¤Ç¼õ¤±¼è¤Ã¤¿¾ì¹ç¤ÏÅÅ»ÒǼÉդǡ¢¸½¶â¤Ç¼õ¤±¼è¤Ã¤¿¾ì¹ç¤Ï°õ»æ¤ÇǼÉÕ¤¹¤ë¤Î¤ò´ðËܤȤ·¤Æ¤¤¤Þ¤¹¡£
¤½¤·¤Æ°õ»æ¤Ë´Ø¤·¤Æ¤Ï¡¢Í¹ÊضɤǹØÆþ¤ò¤·¤Æ¤¤¤Þ¤¹¡£
°õ»æ¤ò¹ØÆþ¤¹¤ëºÝ¤Ç¤¹¤¬¡¢Í¹ÊضɤÎÁë¸ý¤Ë¼«ºî¤Î°õ»æ¤Î¶â¼ï¤ÈËç¿ô¤òµºÜ¤·¤¿ÍÑ»æ¤ò½Ð¤·¤Æ¹ØÆþ¤·¤Æ¤¤¤Þ¤¹¡£
ÍÑ»æ¤ÏExcel¤ÇºîÀ®¤·¤¿B6¤ÎÍÑ»æ¤Ç¤¹¡£
¤³¤ó¤Ê´¶¤¸¡£
Ëç¿ôÍó¤ËËç¿ô¤òÆþÎϤ¹¤ë¤È¶â³Û¤¬¼«Æ°·×»»¤µ¤ì¤ë¤è¤¦¤Ë¤·¤Æ¤¢¤ë¤Î¤Ç¡¢´Ö°ã¤¤¤â¤¢¤ê¤Þ¤»¤ó¡£
¥Á¥ç¥Ã¥È¤³¤À¤ï¤Ã¤Æ¤¤¤ëÉôʬ¤¬¤¢¤ê¤Þ¤·¤Æ¡£
ºÇ½é¤Î²èÁü¤ò¸«¤Æ¤¤¤¿¤À¤¯¤Èʬ¤«¤ê¤Þ¤¹¤¬¡¢¾®·×Íó¤ä¹ç·×Íó¤Ë;·×¤Ê¡Ö¡ï£°¡×¤¬µºÜ¤µ¤ì¤Ê¤¤¤è¤¦¤Ë¤·¤Æ¤¢¤ê¤Þ¤¹¡£
E5¤Î¥»¥ë¤Ëñ½ã¤Ê°Ê²¼¤Î¤è¤¦¤Ê¼°¤òÆþ¤ì¤Æ¤ß¤ë¤È¡¢
¡Ö¡ï£°¡×¤¬µºÜ¤µ¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤½¤³¤Ç¡ÖIF´Ø¿ô¡×¤ò»È¤¤¡¢°Ê²¼¤Î¤è¤¦¤Ê¼°¤òÆþ¤ì¤Æ¤ß¤Þ¤¹¡£
¤½¤¦¤¹¤ë¤È¡¢ºÇ½é¤Î²èÁü¤Î¤è¤¦¤Ë¡Ö¡ï£°¡×¤¬µºÜ¤µ¤ì¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£
¤³¤ÎE5¤Î¥»¥ë¤ËÆþÎϤò¤·¤¿¼°¤Î°ÕÌ£¤Ç¤¹¤¬¡¢¡Ö¤â¤·D5¤Î¥»¥ë¤¬¶õÇò¤À¤Ã¤¿¤é¶õÇò¤È¤·¡¢¤½¤¦¤Ç¤Ï¤Ê¤«¤Ã¤¿¤éC5¡ßD5¤Î·ë²Ì¤òɽ¼¨¤¹¤ë¡×¤È¸À¤¦ÆâÍƤˤʤäƤ¤¤Þ¤¹¡£
¤Ä¤Þ¤ê¡¢Ëç¿ôÍ󤬶õÍó¤Î¾ì¹ç¤Ï¾®·×Íó¤â¶õÍó¤Ë¤Ê¤ê¡¢Ëç¿ô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ì¤Ð¾®·×Íó¤Ë·×»»·ë²Ì¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£
Excel¤â´Ø¿ô¤¬»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ë¤À¤±¤Ç¡¢ºîÀ®¤Ç¤¤ë¥·¡¼¥È¤ÎÉý¤¬¹¤¬¤ê¤Þ¤¹¤è¤Í¡£