²òÀâ Edit

½øʸ·ó¥í¥±¡¼¥·¥ç¥ó Edit

Ver.1¤È2¤Ç°ã¤¤¤Ï̵¤·

[USER]¤ÎÉôÂâ¤Ï¿Í´Ö³¦¤Ë¿¯¹¶¤·¤¿¡ª
[LIST1_1-1][LIST1_2-2]=IF(=RAND_N(1,1,3)=1,,=IF(=RAND_N(1)=2,[LIST1_3-2],[LIST1_3-2][LIST1_4-3]))[LIST1_5-4]¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª
´ðËܥƥ­¥¹¥È[USER]¤ÎÉôÂâ¤Ï¿Í´Ö³¦¤Ë¿¯¹¶¤·¤¿¡ª
[LIST1_1-1][LIST1_2-2]=IF(=RAND_N(1,1,3)=1,,=IF(=RAND_N(1)=2,[LIST1_3-2],[LIST1_3-2][LIST1_4-3]))[LIST1_5-4]¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª
-1
1ʸ»úÌÜ
,-2
2¡¤3ʸ»úÌÜ
,-3
4ʸ»úÌÜ
,-4
¾ì½ê
LIST1¥¢,¥¡,¥¡,³¹Æ»
¥¤,¥¢,¥¢,³¹Æ»
¥¦,¥£,¥£,ºÖ
¥¨,¥¤,¥¤,ºÖ
¥ª,¥¥,¥¥,¹Á
¡¦
¡¦
¡¦
¥¶,¥·,¡¼,¾ë
  • 2¡Á4ʸ»ú¤Î¥«¥¿¥«¥Ê¤ò¥é¥ó¥À¥à¤Ëɽ¼¨¤µ¤»¡¢
    ³¹Æ»(2/7)¡¦ºÖ(2/7)¡¦¹Á(2/7)¡¦¾ë(1/7)¤ÎÆ⤫¤é°ì¤Ä¥é¥ó¥À¥à¤ËÁª¤Ð¤»¤ë¥Æ¥­¥¹¥È
  • 1ʸ»úÌܤËÍ褿¤éÉÔ¼«Á³¤Êʸ»ú¤òɽ¼¨¤µ¤»¤Ê¤¤¤è¤¦¤Ë
    ¤Þ¤¿¡¢¥é¥ó¥À¥à¤È¤Ï¤¤¤¨ÈÜàФÊʸ»úÎ󡢿ͤòÉÔÌû²÷¤Ë¤µ¤»¤«¤Í¤Ê¤¤Ê¸»úÎ󤬺î¤é¤ì¤Ê¤¤¤è¤¦¤ËÆÃÄê¤Îʸ»ú¤Ï¾Ã¤µ¤ì¤Æ¤¤¤ë¡£

[LIST¡»_¡ß-¿ô»ú] Edit

  • ¥ê¥¹¥ÈÆâ¤ÎÃͤò¡Ø,¡Ù¤Ç¶èÀÚ¤ë
    ¸Æ¤Ó½Ð¤¹ºÝ¤ËÎ㤨¤Ð[LIST1_1-1]¤È¤«[LIST1_1-2]¤È¤¤¤Ã¤¿É÷¤Ë¡Ø-¿ô»ú¡Ù¤òÆþ¤ì¤ë¤È¤½¤ì¤¾¤ì¤ËÂбþ¤·¤¿Ãͤò¸ÄÊ̤˸ƤӽФ»¤ë
    ÍøÅÀ¤ÏÆó¤Ä
    • 1¡¢¥ê¥¹¥È¤Î°µ½Ì
      • LIST¤Ï10¸Ä¤·¤«¤Ê¤¤¤Î¤Ç·ë¹½¤¹¤°¤ËËä¤Þ¤Ã¤Æ¤·¤Þ¤¦
        Ãͤοô¤ò·¤¨¤ëɬÍפ¬¤¢¤ë»ö¤È¥ê¥¹¥È¥ª¥×¥·¥ç¥ó¤ò¡Ø»Ä¤¹¡Ù¤Ë¤·¤Ê¤¤¤È·ë²Ì¤¬ÊФ꤬¤Á¤Ë¤Ê¤ë»ö¤¬ÆñÅÀ¤À¤¬¤«¤Ê¤êÍ­ÍÑ
    • 2¡¢È½Äê·ë²Ì¤Ë±þ¤¸¤¿¤ª¤Þ¤±¤Îɽ¼¨
      • [LIST1_1]¤Ç¡Ø[USER]¤ÏÊõÈ¢¤ò³«¤±¤¿¡ÄÂçÎ̤κâÊõ¤ò¼ê¤ËÆþ¤ì¤¿¡ª,ËÁ¸±¤Ç¼ê¤ËÆþ¤ì¤¿Êõ¤òÇä¤Ã¤Æ¤ß¤ë¤È¶â²ß3000Ëçʬ¤Ë¤Ê¤Ã¤¿¡ª¡Ù¤Èɽ¼¨¤µ¤ì¤ë»þ
        [LIST1_1-1]¤ÈÆþÎϤ¹¤ì¤Ð¡Ø[USER]¤ÏÊõÈ¢¤ò³«¤±¤¿¡ÄÂçÎ̤κâÊõ¤ò¼ê¤ËÆþ¤ì¤¿¡ª¡Ù¤Èɽ¼¨¤Ç¤­
        [LIST1_1-2]¤ÈÆþÎϤ¹¤ì¤Ð¡ØËÁ¸±¤Ç¼ê¤ËÆþ¤ì¤¿Êõ¤òÇä¤Ã¤Æ¤ß¤ë¤È¶â²ß3000Ëçʬ¤Ë¤Ê¤Ã¤¿¡ª¡Ù¤Èɽ¼¨¤Ç¤­¤ë
        ¤Ä¤Þ¤êȽÄê·ë²Ì¤Ë±þ¤¸¤¿¡Ö¤½¤Î¸å¡×¤òÉÁ¤±¤ë¡£
        ÃÍ°ì¤ÄÊÕ¤ê300»ú¤È¤¤¤¦À©¸Â¤ËÃí°Õ¤¹¤ë»ö

=IF(,,)´Ø¿ô Edit

  • ¾ò·ï¤òÉÕ¤±¤Æɽ¼¨¤òʬ´ô¤µ¤»¤ë°Ù¤Î´Ø¿ô =IF(¡Ú¾ò·ï¡Û,¡Ú¿¿¡Û,¡Úµ¶¡Û)¤Ç¹½À®¤µ¤ì¤ë
    ¡Ú¾ò·ï¡Û¤ÎÃæ¤Ë=AND( , )¤ä=OR( , )¤Ê¤É¤âÆþ¤ì¤ë»ö¤â½ÐÍè¤ë
  • [LIST1_1-1](1ʸ»úÌÜ)[LIST1_2-2](2ʸ»úÌÜ)=IF(=RAND_N(1,1,3)=1,,=IF(=RAND_N(1)=2,[LIST1_3-2](3ʸ»úÌÜ),[LIST1_3-2](3ʸ»úÌÜ)[LIST1_4-3](4ʸ»úÌÜ)))[LIST1_5-4](¥í¥±¡¼¥·¥ç¥ó)¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª
    • ³µÍ×
      • =RAND_N(1,1,3)¤òÍѤ¤¤Æ1¡Á3¤Î¿ô»ú¤òÆâÉô¤ÇȯÀ¸¤µ¤»
        1¤Ê¤é2ʸ»ú
        2¤Ê¤é3ʸ»ú
        3¤Ê¤é4ʸ»ú¤Î¥«¥¿¥«¥Ê¤òȯÀ¸¤µ¤»¤ë
    • =IF(=RAND_N(1,1,3)=1,,¡Ú¢¨1¡Û)
      • ¡Ú¾ò·ï¡Û¡§=RAND_N(1,1,3)=1Ž¥Ž¥Ž¥1¡Á3¤Î¿ô»ú¤ò¥é¥ó¥À¥à¤ÇȯÀ¸¤µ¤»¡¢¤½¤ì¤¬1¤À¤Ã¤¿»þ¡£¤Ä¤Þ¤ê1/3¤Î³ÎΨ¤Ç
        ¡Ú¿¿¡Û¡§¶õÇò¡£¤Ä¤Þ¤ê2ʸ»ú
        ¡Úµ¶¡Û¡§¡Ú¢¨1¡Û
    • ¡Ú¢¨1¡Û=IF(=RAND_N(1)=2,[LIST1_3-2](3ʸ»úÌÜ),[LIST1_3-2](3ʸ»úÌÜ)[LIST1_4-3](4ʸ»úÌÜ))
      • ¡Ú¾ò·ï¡Û¡§=RAND_N(1)=2Ž¥Ž¥Ž¥¾åµ­¤ÇȯÀ¸¤µ¤»¤¿¥é¥ó¥À¥à¿ô»ú¤¬2¤À¤Ã¤¿»þ¡£¤Ä¤Þ¤ê1/3¤Î³ÎΨ¤Ç
        ¡Ú¿¿¡Û¡§[LIST1_3-2](3ʸ»úÌÜ)¡£¤Ä¤Þ¤ê3ʸ»ú
        ¡Úµ¶¡Û¡§[LIST1_3-2](3ʸ»úÌÜ)[LIST1_4-3](4ʸ»úÌÜ)¡£¤Ä¤Þ¤ê4ʸ»ú

¿ÇÃÇÉôʬ°ì¡¢ÆóÀïÌÜ Edit

Ver.1¤È2¤Ï´ðÁåƥ­¥¹¥È¤ÏƱ¤¸¤À¤¬»²¾È¤¹¤ëÉôʬ¤Ë¾¯¡¹°ã¤¤¤¬¤¢¤ë
[LIST2_1-1]

[LIST2_2-1]
´ÉÍý¤·¤ä¤¹¤¯¤¹¤ë°Ù¤Ë¥ê¥¹¥È¤Ï¡Ö_1¡×¤«¤é»ÈÍÑ
´ðÁåƥ­¥¹¥È[LIST2_1-1]

[LIST2_2-1]
Ver.1-1
¥Æ¥­¥¹¥È
,-2
¾¡ÇÔ
,-3
·ü¾Þ¶â³Û
,-4
·®¾Ï
,-5
¤½¤Î¾
LIST2°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR]¤À¤¬[USER]¤Ï¤³¤ì¤òÆɤó¤Ç¤¤¤¿¡ª¤·¤Ã¤«¤êÂн褷¤ÆÈ¿·â¤Ëž¤º¤ë¡ª,1,80,,
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR]¤À¤¬[USER]¤Ï¤³¤ì¤òÆɤó¤Ç¤¤¤¿¡ªµÕ¤ËÍøÍѤ·¤ÆŨ¤ËÂçÂÇ·â¤òÍ¿¤¨¤¿¡ª,1,100,[BR][USER]¤ÎͦÌԤʤë³èÌö¤ò»¾¤¨¡¢¡ØËâ·³ÆÍ·â·®¾Ï¡Ù¤¬¼øÍ¿¤µ¤ì¤¿¡ª,
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR][USER]¤ÎÉôÂâ¤ÏÂ礭¤ÊÈï³²¤ò¼õ¤±¤¿,0,40,,[BR]µ¢´Ô¤ÎºÝ¡¢¿Í´Ö¤ÎĵÊóÉôÂâ¤òÊá¤é¤¨¤¿¡ªËâʪ¤Ë²½¤±¤Æʶ¤ì¹þ¤ó¤Ç¤¤¤ë¤è¤¦¤À¡£
¡¦
¡¦
¡¦
ËⲸ¦µæ½ê¤òȯ¸«¤·¤¿¡¢[USER]¤¬Ãæ¤ò¤¢¤é¤¿¤á¤ë¡ª[BR]Ʊ²¤Î¤Ê¤­¤¬¤é¤ò²ó¼ý¤·¤¿[BR]¡ØËⲦ·³¤ÎÇÛÃֵڤӻؼ¨Ì¿Îá·ÏÅý¤Ë´Ø¤¹¤ë»ñÎÁ¡Ù¤ò²ó¼ý¤·¤¿¡ª,0,40,,

¡¡

Ver.2-1,-2,-3,-4,-5
LIST2[LIST9_1-1],[LIST9_1-2],[LIST9_1-3],[LIST9_1-4],[LIST9_1-5]
[LIST9_2-1],[LIST9_2-2],[LIST9_2-3],[LIST9_2-4],[LIST9_2-5]
[LIST9_3-1],[LIST9_3-2],[LIST9_3-3],[LIST9_3-4],[LIST9_3-5]
¡¦
¡¦
¡¦
[LIST10_48-1],[LIST10_48-2],[LIST10_48-3],[LIST10_48-4],[LIST10_48-5]
[LIST10_49-1],[LIST10_49-2],[LIST10_49-3],[LIST10_49-4],[LIST10_49-5]
[LIST10_50-1],[LIST10_50-2],[LIST10_50-3],[LIST10_50-4],[LIST10_50-5]
exp027227.png
+  
LIST9
+  
LIST10
  • Ver.1¤ÎÊý¤¬ÁÇľ¤Ç¤ï¤«¤ê¤ä¤¹¤¤
    • Ver.2¤Ï¹àÌÜ¿ô¤¬Áý¤¨¤¿´Ø·¸¤Ç
      ´ðÁåƥ­¥¹¥È¤«¤éLIST2¤ò»²¾È
      ¡¡¡¡¡¡¢­
      LIST2¤«¤éLIST9¡¢10¤ò»²¾È¤ÈÆó½Å»²¾È¤ò¹Ô¤Ã¤Æ¤¤¤ë¡£
  • ¡Ø-2¡Á5¡Ù¤Ë¤Ä¤¤¤Æ¤Ï¸å½Ò


Last-modified: 2021-02-25 Thu 21:00:44 JST (1149d)