²òÀâ †
¿ÇÃÇÉôʬÃæ´ÖÊó¹ð¤È»°ÀïÌÜ †
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()´Ø¿ô †
- ²Ã¸º¾è½ü¤¬½ÐÍè¤ë
- =IF(,,)´Ø¿ô¤Î¾ò·ï¤È¤·¤ÆÁȤ߹þ¤á¤ë
|