²òÀâ Edit

»°ÀïÌÜ·ë²Ì Edit


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]¤ÎÉôÂâ¤Ï¿¯Î¬¤Ë¼ºÇÔ¡¢Å±Âष¤¿¡Ä

·®¾Ï¤È¾Î¹æ Edit

[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])

Last-modified: 2021-02-28 Sun 18:54:31 JST (1125d)