#navi(../)
*²òÀâ [#heda6261]
**»°ÀïÌÜ·ë²Ì [#qd6dade2]
#navi(../)
 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))Ëü¥´¡¼¥ë¥ÉÁý¤¨¤¿¤è¤¦¤À)
 
 ¢¨²£¤ËŤ¯¤Ê¤ê¤¹¤®¤¿¤¿¤á¡¢ÀÞ¤êÊÖ¤·¤µ¤»¤Æ¤¤¤Þ¤¹
**·®¾Ï¤È¾Î¹æ [#f7474d49]
 [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])