²òÀâ Edit

¿ÇÃÇÉôʬÃæ´ÖÊó¹ð¤È»°ÀïÌÜ Edit

Ver.1
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4,1,5)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢Í¦¼Ô¤¬¸½¤ì¤¿¡ª[BR]ͦ¼Ô¤Î¥Ñ¡¼¥Æ¥£¤ÈÀ襤¤Ë¤Ê¤Ã¤¿¡ª,[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª),
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª))

=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,[LIST3_1][BR][LIST3_2][BR][LIST4_1-1],[LIST2_3-1]),[LIST2_3-1])
Ver.2
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4,1,5)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢,[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR]),
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª)[BR][BR])
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,[LIST4_1-1],[LIST2_3-1]),[LIST2_3-1])
¢¨²£¤ËŤ¯¤Ê¤ê¤¹¤®¤¿¤¿¤á¡¢ÀÞ¤êÊÖ¤·¤µ¤»¤Æ¤¤¤Þ¤¹
Ver.1¤È2¤Ç¤Ï¼ã´³¤Î°ã¤¤¤¬À¸¤¸¤Æ¤¤¤ë¡¢¤É¤Îͦ¼Ô¤¬½Ð¸½¤·¤¿¤Î¤«¤òÌÀ¼¨¤¹¤ë¤è¤¦¤Ë¤·¤¿°Ù
¤³¤¦¤·¤Æ¤ß¤ë¤È¤Þ¤À̵Â̤¬¤¢¤ë¤È¤ï¤«¤ë¤Î¤ÇºÆÅÙ½¤Àµ
Ver.3¡Ê²¾¡Ë
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4,1,5)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢[LIST4_1-1],[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR][LIST2_3-1]),
=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª)[BR][BR][LIST2_3-1])
ʬ¤«¤ê¤ä¤¹¤µ¤ò½Å»ë¤¹¤ë°Ù¡¢°Ê¹ß¤³¤ÎVer.3¡Ê²¾¡Ë¤òÍѤ¤¤Æ²òÀ⤷¤Þ¤¹
´ðËܥƥ­¥¹¥È[LIST2_1-1]

[LIST2_2-1]


=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4,1,5)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢[LIST4_1-1],[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR][LIST2_3-1]),=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª)[BR][BR][LIST2_3-1])
-1
¥Æ¥­¥¹¥È
,-2
¾¡ÇÔ
,-3
·ü¾Þ¶â³Û
,-4
·®¾Ï
,-5
¤½¤Î¾
LIST2
=LIST9+LIST10
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR]¤À¤¬[USER]¤Ï¤³¤ì¤òÆɤó¤Ç¤¤¤¿¡ª¤·¤Ã¤«¤êÂн褷¤ÆÈ¿·â¤Ëž¤º¤ë¡ª,1,80,,
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR]¤À¤¬[USER]¤Ï¤³¤ì¤òÆɤó¤Ç¤¤¤¿¡ªµÕ¤ËÍøÍѤ·¤ÆŨ¤ËÂçÂÇ·â¤òÍ¿¤¨¤¿¡ª,1,100,[BR][USER]¤ÎͦÌԤʤë³èÌö¤ò»¾¤¨¡¢¡ØËâ·³ÆÍ·â·®¾Ï¡Ù¤¬¼øÍ¿¤µ¤ì¤¿¡ª,
¡¦
¡¦
¡¦
¤Ê¤Ë¤ä¤éÁû¤¬¤·¤¤¡Ä¿Í´Ö¤¿¤Á¤Î°ìÉô¤¬ÆÍÇ¡ËⲤËÊÑËƤ·¡¢Ë½¤ì¤Þ¤ï¤Ã¤Æ¤¤¤ë¤é¤·¤¤[BR]¥µ¥É¥¦¥§¥¤¤ÎŹÊÞ¤«¤é½Ð¤Æ¤­¤¿°ìÃĤÈÁè¤Ã¤Æ¤¤¤¿¡ªÊü¤Ã¤Æ¤ª¤³¤¦¡Ä[USER]¤Ï¹½¤ï¤º¿Ê·³¤·¤¿¡ª,1,80,,
-1
¥Æ¥­¥¹¥È
,-2
¾¡ÇÔ
,-3
·ü¾Þ¶â³Û
,-4
·®¾Ï
,-5
¤½¤Î¾
LIST4ͦ¼Ô¤ò̾¾è¤ë¾¯Ç¯¤¬¼ÙËâ¤ò¤·¤Æ¤­¤¿¡ª[BR]¼ã¤­Í¦¼Ô¤Î¥Ñ¡¼¥Æ¥£¤ÈÀ襤¤Ë¤Ê¤Ã¤¿¡ª[BR][BR][LIST3_1-1][BR][LIST3_2-1][BR]¾¤Îͦ¼Ô¤ÈÈæ¤Ù¤ì¤Ð¤Þ¤ë¤Ç¼å¤¤¡ª[USER]¤¬»ß¤á¤ò»É¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢Í¦¼Ô¤¬³ÐÀä·¤¿¡ª[BR]³ÐÀä·¤¿Í¦¼Ô¤Î¹¶·â¡ª[USER]¤Ï½Å½ý¤òÉé¤Ã¤¿,0,80,,
ͦ¼Ô¤ò̾¾è¤ë¾¯Ç¯¤¬¼ÙËâ¤ò¤·¤Æ¤­¤¿¡ª[BR]¼ã¤­Í¦¼Ô¤Î¥Ñ¡¼¥Æ¥£¤ÈÀ襤¤Ë¤Ê¤Ã¤¿¡ª[BR][BR][LIST3_1-1][BR][LIST3_2-1][BR]¾¤Îͦ¼Ô¤ÈÈæ¤Ù¤ì¤Ð¤Þ¤ë¤Ç¼å¤¤¡ª[USER]¤¬»ß¤á¤ò»É¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢Í¦¼Ô¤¬³ÐÀä·¤¿¡ª[BR]³ÐÀä·¤¿Í¦¼Ô¤Î¹¶·â¡ª[USER]¤Ï½Å½ý¤òÉé¤Ã¤¿,0,80,,
¡¦
¡¦
¡¦
ͦ¼Ô¤ò̾¾è¤ë¾¯Ç¯¤¬¼ÙËâ¤ò¤·¤Æ¤­¤¿¡ª[BR]¼ã¤­Í¦¼Ô¤Î¥Ñ¡¼¥Æ¥£¤ÈÀ襤¤Ë¤Ê¤Ã¤¿¡ª[BR][BR][LIST3_1-1][BR][LIST3_2-1][BR]¾¤Îͦ¼Ô¤ÈÈæ¤Ù¤ì¤Ð¤Þ¤ë¤Ç¼å¤¤¡ªÍ¦¼Ô¤Ï²¿¤«¤ò¤·¤è¤¦¤È¤·¤Æ¤¤¤ë¤è¤¦¤À¤¬¡Ä̵Â̤ʻö¤À¡ª[BR][USER]¤Ïͦ¼Ô¤ËÂ礭¤Ê¥À¥á¡¼¥¸¤òÍ¿¤¨¤¿¡ª,1,200,[BR]ñÆȤÇͦ¼Ô¤òÂऱ¤¿¸ùÀÓ¤ò»¾¤¨¡¢¡ØËâ·³°Å¹õͦ¼Ô·®¾Ï¡Ù¤¬¼øÍ¿¤µ¤ì¤¿¡ª,

³µÍ×

  • [LIST2-2]¤Ï¾¡¤Æ¤Ð¡Ø1¡Ù¡¢É餱¤ì¤Ð¡Ø0¡Ù¤È½ÐÎϤµ¤ì¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤ë
    • [LIST2_1-1]¤È[LIST2_2-1]¤Ç½Ð¤¿·ë²Ì¤ËÂФ·
      [LIST2_1-2]¤È[LIST2_2-2]¤¬Âбþ¤·¤Æ¤¤¤ë°Ù¡¢¤³¤ì¤ò¹ç·×¤¹¤ë
      • ÆóÏ¢¾¡¤Ê¤é¹ç·×ÃͤϡØ2¡Ù¤Ë¤Ê¤ë
        ¡¡¢ªÍ¦¼Ô½Ð¸½¡Ê»°²óÌܤÎȽÄê¤ò[LIST4_1-1]¤Ç¹Ô¤¦¡Ëor¡Ø[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª¡Ù¡Ê»°²óÌܤÎȽÄê¤ò[LIST2_3-1]¤Ç¹Ô¤¦¡Ë
      • °ì¾¡°ìÇԤʤé¹ç·×ÃͤϡØ1¡Ù¤Ë¤Ê¤ë
        ¡¡¢ª¡ØÃ桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª¡Ù¡Ê»°²óÌܤÎȽÄê¤ò[LIST2_3-1]¤Ç¹Ô¤¦¡Ë
      • ÆóÇԤʤé¹ç·×ÃͤϡØ0¡Ù¤Ë¤Ê¤ë
        ¡¡¢ª¡ØŨ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª¡Ù¡Ê»°²óÌܤÎȽÄê¤ò[LIST2_3-1]¤Ç¹Ô¤¦¡Ë

IF´Ø¿ô

  • =IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4,1,5)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢[LIST4_1-1],[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR][LIST2_3-1]),=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª)[BR][BR][LIST2_3-1])
    • =IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,¡Ú¢¨1¡Û,¡Ú¢¨2¡Û[BR][BR][LIST2_3-1])
      • ¡Ú¾ò·ï¡Û¡§=CALC([LIST2_1-2]+[LIST2_2-2])=2Ž¥Ž¥Ž¥[LIST2_1-2]¤È[LIST2_2-2]¤Î¹ç·×Ãͤ¬2¤Î»þ¡£¤Ä¤Þ¤êÆóÏ¢¾¡¤Ç
        ¡Ú¿¿¡Û¡§¡Ú¢¨1¡Û
        ¡Úµ¶¡Û¡§¡Ú¢¨2¡Û[BR][BR][LIST2_3-1]
    • ¡Ú¢¨1¡Û=IF(=RAND_N(4,1,5)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢[LIST4_1-1],[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR][LIST2_3-1])
      • ¡Ú¾ò·ï¡Û¡§=RAND_N(4,1,5)=1Ž¥Ž¥Ž¥1¡Á5¤Î¥é¥ó¥À¥à¿ô»ú¤òÆâÉô¤ÇȯÀ¸¤µ¤»¡¢¤½¤ì¤¬1¤À¤Ã¤¿»þ¡£¤Ä¤Þ¤ê1/5¤Î³ÎΨ¤Ç
        ¡Ú¿¿¡Û¡§¡Ø¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢[LIST4_1-1]¡Ù¡Êͦ¼Ô½Ð¸½¡Ë
        ¡Úµ¶¡Û¡§¡Ø[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR][LIST2_3-1]¡Ù¡ÊÄ̾ïȽÄê¡Ë
    • ¡Ú¢¨2¡Û=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª)
      • ¡Ú¾ò·ï¡Û¡§=CALC([LIST2_1-2]+[LIST2_2-2])=1Ž¥Ž¥Ž¥[LIST2_1-2]¤È[LIST2_2-2]¤Î¹ç·×Ãͤ¬2¤Î»þ¡£¤Ä¤Þ¤ê°ì¾¡°ìÇÔ¤Ç
        ¡Ú¿¿¡Û¡§¡ØÃ桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª¡Ù
        ¡Úµ¶¡Û¡§¡ØŨ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª¡Ù

=CALC()´Ø¿ô Edit


Last-modified: 2021-02-24 Wed 23:23:59 JST (1128d)