EXCEL Tips 082 ¤Ë³¤­¡¢¼¡¤Î¤è¤¦¤Ê³Ê¹¥¤Î¤¤¤¤¡¢¤·¤«¤·¤Ê¤¬¤é¡¢¤ä¤Ã¤Ñ¤ê¤Á¤ç¤Ã¤ÈÉ¡¤Ë¤Ä¤¯¤è¤¦¤ÊÅɤê¤Ä¤Ö¤·¤ÎÊýË¡¤ò¾Ò²ð¤·¤Þ¤¹¡£
imageExcel083-1


ÊýË¡

­¡¡¡¥ê¥Ü¥ó¤«¤é¡ØÁÞÆþ¡Ù¢ª¡Ø¿Þ·Á¡Ù¤òÁªÂò¤·¡¢ÂʱߤΥ¢¥¤¥³¥ó¤òÁªÂò¤·¤ÆÂʱߤòÉÁ¤­¤Þ¤¹¡£


­¢¡¡ÉÁ¤¤¤¿Âʱߤò¥Þ¥¦¥¹¤Î±¦¥Ü¥¿¥ó¤Ç¥¯¥ê¥Ã¥¯¤·¡¢¡Ø¥Æ¥­¥¹¥È¤ÎÊÔ½¸(X)¡Ù¤òÁªÂò¤·¤Þ¤¹¡£

­£¡¡Å¬Åö¤Ëʸ»ú¤òÆþÎϤ·¤Þ¤¹¡£
imageExcel083-3


­¤¡¡Ê¸»ú¤ÎÂ礭¤µ¡¢¥Õ¥©¥ó¥È¡¢¥Õ¥©¥ó¥È¤Î¿§¤òŬÅö¤ËÊѹ¹¤·¤¿¸å¡¢ÉÁ¤¤¤¿Âʱߤò¥Þ¥¦¥¹¤Î±¦¥Ü¥¿¥ó¤Ç¥¯¥ê¥Ã¥¯¤·¡¢¡Ø¿Þ·Á¤Î½ñ¼°ÀßÄê(O)¡Ù¤Î¡Ö¿âľÊý¸þ¤ÎÇÛÃÖ(V)¡×¤Ê¤É¤ÇÇÛÃÖ¤òÀ°¤¨¤Þ¤¹¡£
imageExcel083-4

imageExcel083-5


­¥¡¡¤â¤¦°ìÅÙ¡¢ÉÁ¤¤¤¿Âʱߤò¥Þ¥¦¥¹¤Î±¦¥Ü¥¿¥ó¤Ç¥¯¥ê¥Ã¥¯¤·¡¢¡Ø¿Þ·Á¤Î½ñ¼°ÀßÄê(O)¡Ù¤òÁªÂò¤·¤Þ¤¹¡£

­¦¡¡¥Ð¥±¥Ä¤ò¤³¤Ü¤·¤¿¥¢¥¤¥³¥ó¥Þ¡¼¥¯ (Åɤê¤Ä¤Ö¤·¤ÈÀþ) ¤òÁªÂò¤·¡¢¡ÖÅɤê¤Ä¤Ö¤·¡×¤ÎÃæ¤Î¡ÖÅɤê¤Ä¤Ö¤·(N)¡×¤òÁªÂò¤·¡¢¡ÖÀþ¡×¤ÎÃæ¤Î¡ÖÀþ¤Ê¤·(N)¡×¤òÁªÂò¤·¤Þ¤¹¡£
imageExcel083-6


¤³¤³¤Þ¤Ç¤Ç¡¢Á°È¾½ªÎ»¤Ç¤¹¡£¼¡¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤«¡©
imageExcel083-7


­§¡¡¼¡¤«¤é¤Ï¥°¥é¥Ç¡¼¥·¥ç¥ó¤ÎÉôʬ¤òºîÀ®¤·¤Þ¤¹¡£
¤Þ¤º¡¢¥ê¥Ü¥ó¤«¤é¡ØÁÞÆþ¡Ù¢ª¡Ø¿Þ·Á¡Ù¤òÁªÂò¤·¡¢ÂʱߤΥ¢¥¤¥³¥ó¤òÁªÂò¤·¤ÆÂʱߤòÉÁ¤­¤Þ¤¹¡£ (­¡)¤ÈƱ¤¸¡£

­¨¡¡ÉÁ¤¤¤¿Âʱߤò¥Þ¥¦¥¹¤Î±¦¥Ü¥¿¥ó¤Ç¥¯¥ê¥Ã¥¯¤·¡¢¡Ø¿Þ·Á¤Î½ñ¼°ÀßÄê(O)¡Ù¤òÁªÂò¤·¤Þ¤¹¡£

­©¡¡¥Ð¥±¥Ä¤ò¤³¤Ü¤·¤¿¥¢¥¤¥³¥ó¥Þ¡¼¥¯ (Åɤê¤Ä¤Ö¤·¤ÈÀþ) ¤òÁªÂò¤·¡¢¡ÖÀþ¡×¤ÎÃæ¤Î¡ÖÀþ¤Ê¤·(N)¡×¤òÁªÂò¤·¤Þ¤¹¡£

­ª¡¡Â³¤¤¤Æ¡ÖÅɤê¤Ä¤Ö¤·¡×¤ÎÃæ¤Î¡ÖÅɤê¤Ä¤Ö¤·(¥°¥é¥Ç¡¼¥·¥ç¥ó)(G)¡×¤òÁªÂò¤·¤Þ¤¹¡£
imageExcel083-8


­«¡¡¤µ¤é¤Ë¡¢¡Ö¼ïÎà(Y)¡×¤«¤é¡Ö¥Ñ¥¹¡×¤òÁªÂò¤·¡¢¡Ö¥°¥é¥Ç¡¼¥·¥ç¥ó¤Îʬ´ôÅÀ¡×¤Îº¸Ã¼¤Îʬ´ôÅÀ¤òÁª¤ó¤Ç¡¢¡Ö¿§(C)¡×¤«¤éŬÅö¤Ê¿§¤òÁªÂò¤·¤Þ¤¹¡£
imageExcel083-9

­¬¡¡Î¾Ã¼°Ê³°¤Î¥°¥é¥Ç¡¼¥·¥ç¥ó¤Îʬ´ô¤òºï½ü¤·¤Þ¤¹¡£
imageExcel083-10

­­¡¡±¦Ã¼¤Îʬ´ôÅÀ¤òÁª¤ó¤Ç¡¢¡Ö¿§(C)¡×¤«¤éÇò¿§¤òÁªÂò¤·¤Þ¤¹¡£
imageExcel083-11


¼¡¤Î¤è¤¦¤Ë¡¢¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤«¡©
¤³¤³¤«¤é¤¤¤è¤¤¤è¡¢»Å¾å¤²¤Ë¤Ê¤ê¤Þ¤¹¡£
imageExcel083-12

­®¡¡Çö¤¤¥Ô¥ó¥¯¤Î¿§¤ò¤Ä¤±¤¿Âʱߤò¥Æ¥­¥¹¥È¤ÎÆþ¤Ã¤¿Âʱߤˡ¢¿Þ¤Î¤è¤¦¤Ë¡¢¤º¤é¤·¤Æ½Å¤Í¤Þ¤¹¡£(½Å¤Ê¤Ã¤¿Éôʬ¤Îʸ»ú¤¬¾Ã¤¨¤Þ¤¹¡£)
imageExcel083-13

­¯¡¡Çö¤¤¥Ô¥ó¥¯¤Î¿§¤ò¤Ä¤±¤¿Âʱߤò¥Þ¥¦¥¹¤Î±¦¥Ü¥¿¥ó¤Ç¥¯¥ê¥Ã¥¯¤·¡¢¡ÖºÇÇØÌ̤ذÜÆ°(K)¡×¤òÁªÂò¤·¤Þ¤¹¡£
imageExcel083-14


­°¡¡Çö¤¤¥Ô¥ó¥¯¤Î¿§¤ò¤Ä¤±¤¿ÂʱߤηÁ¤òÊÑ·Á¤µ¤»¤Æ¡¢¥Ð¥é¥ó¥¹¤è¤¯ÇÛÃÖ¤¹¤ì¤Ð¤Ç¤­¤¢¤¬¤ê¤Ç¤¹¡£