²òÀâ †
»°ÀïÌÜ·ë²Ì †
Ver.2
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,=IF([LIST4_1-2]=1,ͦ¼Ô¤Î·âÂà¤ËÀ®¸ù¡ª[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)
[LIST6_2-3][BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª,[USER]¤ÎÉôÂâ¤Ïͦ¼Ô¤ÎÎϤˤè¤êűÂà¤ò;µ·¤Ê¤¯¤µ¤ì¤¿¡Ä) [BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST4_1-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À¡£,
=IF([LIST2_3-2]=1,¿Í´Ö¤É¤â¤Ï²õÌÇ¡¢[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª[BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª,
»×¤ï¤ÌÄñ¹³¤Ë¤¢¤¤¼è¤êƨ¤¬¤·¤Æ¤·¤Þ¤Ã¤¿¡Ä¤À¤¬º³ºÙ¤Ê»ö¡¢[USER]¤ÎÉôÂâ¤Î¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¡¢Â¿¾¯¤ÎÄñ¹³¤Ï¤¢¤Ã¤¿¤¬¼þÊÕ°ìÂӤο¤¯¤ÎÄ®¤ä¼¤òËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª)
=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3][BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST2_3-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À¡£),
=IF([LIST2_3-2]=1,¾¡¤Ã¤¿¡ª¿Í´Ö¤É¤â¤¬¤É¤ó¤Ê¤Ë¹³¤ª¤¦¤È¡¢ºÇ¸å¤Ë¾Ð¤¦¤Î¤Ï¤³¤Î[USER]¤Ê¤Î¤À¡ª[BR][BR]¤½¤Î¸å¡¢¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤Ëʼ¤òÇɸ¯¤·¤¿¤¬¡ÄÄü¤á¤Î°¤¤Åۤ餬¤Þ¤À¤¤¤ë¤è¤¦¤À¡¢Äñ¹³¤¬·ã¤·¤¤¡£
=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3],[USER]¤ÎÉôÂâ¤Ï¿¯Î¬¤Ë¼ºÇÔ¡¢Å±Âष¤¿¡Ä)[BR] [BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST2_3-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À)
¢¨²£¤ËŤ¯¤Ê¤ê¤¹¤®¤¿¤¿¤á¡¢ÀÞ¤êÊÖ¤·¤µ¤»¤Æ¤¤¤Þ¤¹
´ðËܥƥ¥¹¥È | =IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,=IF([LIST4_1-2]=1,ͦ¼Ô¤Î·âÂà¤ËÀ®¸ù¡ª[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3][BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª,[USER]¤ÎÉôÂâ¤Ïͦ¼Ô¤ÎÎϤˤè¤êűÂà¤ò;µ·¤Ê¤¯¤µ¤ì¤¿¡Ä)[BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST4_1-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À¡£,=IF([LIST2_3-2]=1,¿Í´Ö¤É¤â¤Ï²õÌÇ¡¢[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª[BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª,»×¤ï¤ÌÄñ¹³¤Ë¤¢¤¤¼è¤êƨ¤¬¤·¤Æ¤·¤Þ¤Ã¤¿¡Ä¤À¤¬º³ºÙ¤Ê»ö¡¢[USER]¤ÎÉôÂâ¤Î¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¡¢Â¿¾¯¤ÎÄñ¹³¤Ï¤¢¤Ã¤¿¤¬¼þÊÕ°ìÂӤο¤¯¤ÎÄ®¤ä¼¤òËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª)=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3][BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST2_3-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À¡£),=IF([LIST2_3-2]=1,¾¡¤Ã¤¿¡ª¿Í´Ö¤É¤â¤¬¤É¤ó¤Ê¤Ë¹³¤ª¤¦¤È¡¢ºÇ¸å¤Ë¾Ð¤¦¤Î¤Ï¤³¤Î[USER]¤Ê¤Î¤À¡ª[BR][BR]¤½¤Î¸å¡¢¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤Ëʼ¤òÇɸ¯¤·¤¿¤¬¡ÄÄü¤á¤Î°¤¤Åۤ餬¤Þ¤À¤¤¤ë¤è¤¦¤À¡¢Äñ¹³¤¬·ã¤·¤¤¡£=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3],[USER]¤ÎÉôÂâ¤Ï¿¯Î¬¤Ë¼ºÇÔ¡¢Å±Âष¤¿¡Ä)[BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST2_3-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À) |
Âè°ì¡¢ÂèÆóÀï¤ÎξÊý¤Ç¾¡Íø¤·¤¿¤«¤ò³Îǧ¤¹¤ë | ¡Ú¿¿¡Û | ͦ¼Ô¤¬½Ð¸½¤·¤¿¤«¤Î³Îǧ | ¡Ú¿¿¡Û | ͦ¼Ô¤Ë¾¡Íø¤·¤¿¤«¤ò³Îǧ ¾¡ÇԤ˴ؤï¤é¤ºÍ¦¼Ô¤ÈÁø¶ø¤·¤¿»þÅÀ¤Ç·ü¾Þ¶â¤Ïͦ¼ÔÁø¶øVer.¤È¤Ê¤ë | ¡Ú¿¿¡Û | ͦ¼Ô¤Ë¾¡Íø¤¹¤ë¤È´°Á´¾¡Íø¤È¤Ê¤ë | | | =IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,¡Ú¿¿¡Û,¡Úµ¶¡Û) | ¢ª | =IF(=RAND_N(4)=1,¡Ú¿¿¡Û,¡Úµ¶¡Û) | ¢ª | =IF([LIST4_1-2]=1,¡Ú¿¿¡Û,¡Úµ¶¡Û)[BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST4_1-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À¡£ | ¢ª | ͦ¼Ô¤Î·âÂà¤ËÀ®¸ù¡ª[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3][BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª | | | | | | | | | Áí¹ç¤Ç¾¡Íø¤·¤¿¾ì¹ç¡¢¥í¥±¡¼¥·¥ç¥ó¤¬¾ë¤Ç¤¢¤ë¤«³Îǧ¤¬Æþ¤ë ¥í¥±¡¼¥·¥ç¥ó¤¬²¿½è¤Ç¤¢¤ì¿Í´Ö¤ÎµòÅÀ¤òµù¤ë»ö¤Ë¤Ê¤ë | ¡Ú¿¿¡Û | ¾ëµù¤ê | | | | | | | =IF([LIST1_5-4]=¾ë,¡Ú¿¿¡Û,¡Úµ¶¡Û)[LIST6_2-3] | ¢ª | [LIST6_1-1] | | | | | | | | ¡Úµ¶¡Û | ¥í¥±¡¼¥·¥ç¥ó¤¬¾ë¤Ç¤Ê¤¤¤Î¤Ê¤é¶õÇò | | | | | | | | ¢ª | ¶õÇò | | | | | | ¡Úµ¶¡Û | ͦ¼Ô¤ËÇÔË̤¹¤ë¤ÈűÂह¤ë | | | | | | | | ¢ª | [USER]¤ÎÉôÂâ¤Ïͦ¼Ô¤ÎÎϤˤè¤êűÂà¤ò;µ·¤Ê¤¯¤µ¤ì¤¿¡Ä | | | | | | ¡Úµ¶¡Û | ͦ¼Ô¤ÈÁø¶ø¤»¤º¤ËºÇ½ªÀï¤ËÎפó¤À¥Ñ¥¿¡¼¥ó¡¢ºÇ½ªÀï¤Ë¾¡Íø¤·¤¿¤«¤ò³Îǧ¤¹¤ë ¿Í´Ö¤ÎµòÅÀ¤òµù¤ê¡¢Ä̾ïVer.¤Î·ü¾Þ¶â¥¢¥Ã¥×¤¬Æþ¤ë | ¡Ú¿¿¡Û | »°ÀïÁ´¾¡¤Î´°Á´¾¡Íø¤È¤Ê¤ë | | | | | | ¢ª | =IF([LIST2_3-2]=1,¡Ú¿¿¡Û,¡Úµ¶¡Û)=IF([LIST1_5-4]=¾ë,¡Ú¿¿¡Û,¡Úµ¶¡Û)[LIST6_2-3][BR][BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST2_3-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À¡£) | ¢ª | ¿Í´Ö¤É¤â¤Ï²õÌÇ¡¢[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª[BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª | | | | | | | | ¡Úµ¶¡Û | Âè°ì¡¢ÂèÆóÀï¤Ç¾¡Íø¤·¤Æ¤¤¤ì¤ÐºÇ½ªÀï¤ÇÉ餱¤Æ¤â¾¡Íø¤È¤Ê¤ë | | | | | | | | ¢ª | »×¤ï¤ÌÄñ¹³¤Ë¤¢¤¤¼è¤êƨ¤¬¤·¤Æ¤·¤Þ¤Ã¤¿¡Ä¤À¤¬º³ºÙ¤Ê»ö¡¢[USER]¤ÎÉôÂâ¤Î¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¡¢Â¿¾¯¤ÎÄñ¹³¤Ï¤¢¤Ã¤¿¤¬¼þÊÕ°ìÂӤο¤¯¤ÎÄ®¤ä¼¤òËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª | | | | | | | ¤³¤Î¥ë¡¼¥È¤Ïɬ¤ºÁí¹ç¤Ç¾¡Íø¤¹¤ë¤Î¤Ç¡¢¥í¥±¡¼¥·¥ç¥ó¤¬¾ë¤Ç¤¢¤ë¤«³Îǧ¤¬Æþ¤ë ¥í¥±¡¼¥·¥ç¥ó¤¬²¿½è¤Ç¤¢¤ì¿Í´Ö¤ÎµòÅÀ¤òµù¤ë»ö¤Ë¤Ê¤ë | ¡Ú¿¿¡Û | ¾ëµù¤ê | | | | | | | =IF([LIST1_5-4]=¾ë,¡Ú¿¿¡Û,¡Úµ¶¡Û)[LIST6_2-3] | ¢ª | [LIST6_1-1] | | | | | | | | ¡Úµ¶¡Û | ¥í¥±¡¼¥·¥ç¥ó¤¬¾ë¤Ç¤Ê¤¤¤Î¤Ê¤é¶õÇò | | | | | | | | ¢ª | ¶õÇò | | | | ¡Úµ¶¡Û | Âè°ì¡¢ÂèÆóÀï¤ÇÏ¢¾¡¤·¤Æ¤Ê¤¤¥Ñ¥¿¡¼¥ó¡¢ºÇ½ªÀï¤Ç¾¡Íø¤·¤¿¤«¤ò³Îǧ¤¹¤ë ¾¡ÇԤ˴ؤï¤é¤ºÄ̾ïVer.¤Î·ü¾Þ¶â¥¢¥Ã¥×¤¬Æþ¤ë | ¡Ú¿¿¡Û | Âè°ì¡¢ÂèÆóÀï¤Î¾¡ÇԤ˴ؤï¤é¤ººÇ½ªÀï¤Ç¾¡¤Æ¤ÐÁí¹ç¾¡Íø¤¬½ÐÍè¤ë | | | | | | ¢ª | =IF([LIST2_3-2]=1,¡Ú¿¿¡Û,¡Úµ¶¡Û)[BR] [BR][USER]¤Î¼ó¤Ë¤«¤±¤é¤ì¤¿·ü¾Þ¶â¤¬=CALC([LIST2_1-3]+[LIST2_2-3]+[LIST2_3-3]+=RAND_N(5,10,30))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À | ¢ª | ¾¡¤Ã¤¿¡ª¿Í´Ö¤É¤â¤¬¤É¤ó¤Ê¤Ë¹³¤ª¤¦¤È¡¢ºÇ¸å¤Ë¾Ð¤¦¤Î¤Ï¤³¤Î[USER]¤Ê¤Î¤À¡ª[BR][BR]¤½¤Î¸å¡¢¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤Ëʼ¤òÇɸ¯¤·¤¿¤¬¡ÄÄü¤á¤Î°¤¤Åۤ餬¤Þ¤À¤¤¤ë¤è¤¦¤À¡¢Äñ¹³¤¬·ã¤·¤¤¡£=IF([LIST1_5-4]=¾ë,¡Ú¿¿¡Û,¡Úµ¶¡Û)[LIST6_2-3] | | | | | | | | | Áí¹ç¤Ç¾¡Íø¤·¤¿¾ì¹ç¡¢¥í¥±¡¼¥·¥ç¥ó¤¬¾ë¤Ç¤¢¤ë¤«³Îǧ¤¬Æþ¤ë ¥í¥±¡¼¥·¥ç¥ó¤¬²¿½è¤Ç¤¢¤ì¿Í´Ö¤ÎµòÅÀ¤òµù¤ë»ö¤Ë¤Ê¤ë | ¡Ú¿¿¡Û | ¾ëµù¤ê | | | | | | | =IF([LIST1_5-4]=¾ë,¡Ú¿¿¡Û,¡Úµ¶¡Û)[LIST6_2-3] | ¢ª | [LIST6_1-1] | | | | | | | | ¡Úµ¶¡Û | ¥í¥±¡¼¥·¥ç¥ó¤¬¾ë¤Ç¤Ê¤¤¤Î¤Ê¤é¶õÇò | | | | | | | | ¢ª | ¶õÇò | | | | | | ¡Úµ¶¡Û | Âè°ì¡¢ÂèÆóÀï¤ÇÏ¢¾¡½ÐÍ褺¡¢ºÇ½ªÀï¤ÇÉ餱¤Æ¤·¤Þ¤¦¤ÈÁí¹çÇÔË̤Ȥʤë | | | | | | | | ¢ª | [USER]¤ÎÉôÂâ¤Ï¿¯Î¬¤Ë¼ºÇÔ¡¢Å±Âष¤¿¡Ä | | | | |
·®¾Ï¤È¾Î¹æ †
[LIST2_1-4][LIST2_2-4]=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,=IF([LIST4_1-2]=1,=IF([LIST1_5-4]=¾ë,[LIST6_1-2],)[LIST4_1-4],),=IF([LIST2_3-2]=1,=IF([LIST1_5-4]=¾ë,[LIST6_1-2],),)[LIST2_3-4]),[LIST2_3-4])
[LIST2_1-5][LIST2_2-5]=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,[LIST4_1-5],[LIST2_3-5]),[LIST2_3-5])
|