ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¥H¶Ã¼Æ²£¥Í¼ÒÀÀ¥Î¸ê®Æ¡Xµ¹¤©¯S©wªº±¡¹Ò«¬ºA¡A§Y¥i¦Û°Ê²£¥Í¼ÒÀÀ¸ê®Æ¡C

¥H¶Ã¼Æ²£¥Í¼ÒÀÀ¥Î¸ê®Æ¡Xµ¹¤©¯S©wªº±¡¹Ò«¬ºA¡A§Y¥i¦Û°Ê²£¥Í¼ÒÀÀ¸ê®Æ¡C

´ú¸Õ5ºØÁ­½¸¹ï¥úªº¤ÏÀ³

°ò¥»¸ê®Æ¦b¡u°ò¥»¸ê®Æ¡v¡A¤º¦³µo²{ ¤£¦PÁ­½¸ ªº¥i¯à©Ê»P  ¤£¦PÃþ«¬ªºÁ­½¸¹ï¥ú½uªº¤ÏÀ³
­n°µ¥X¨Óªºªí¬O¡u¸ê®Æ²£¥Í¡v

Á­½¸µo²{ªº¥i¯à©Ê¥i¥H¥Î Rand ¶]¶Ã¼Æ¡C
¹ï¥ú½uªº¤ÏÀ³«¬ºA¡A¥i¥H¥Î Vlookup ¬d§ä
¦ý¬O°w¹ï¤£¦PªºÁ­½¸¡A­n¥Î¶Ã¼Æ Rand ¦A¶]¤ÏÀ³«¬ºA®É¡A¤£¦Pªº¤ÏÀ³«¬ºA¦³¤£¦Pªº¾÷²v¡A½Ð°Ý¦³µL¤èªk°µ¡C

Á|¨Ò¡G¤w¶]¥XÁ­½¸¥N¸¹¬O 4¡A¦ý¬O¹ï¥ú½uªº¤ÏÀ³«¬ºA¡A¦³70%·|°k¨«¡A¦ý¦³30%¤£°Ê¡C

Simula.zip (4.77 KB)

«Øij
c2=INDEX({1,2,3,4,5},MATCH(B2,{0,0.3,0.56,0.76,0.9},1))
¥ú½u¤ÏÀ³¤£©ú¥Õ»Ý¨D±ø¥ó
¥i¥Hµ¹­Ó½d¨Ò¶Ü
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

­ì¨Ò¤l¤¤
¤w¶]¥XÁ­½¸¥N¸¹¬O 4(¦b¡u°ò¥»¸ê®Æ¡v¤¤ D5 ª¾¹D¥¦ªº¥ú½u¤ÏÀ³«¬ºA¬O3)¡A¦b¡u°ò¥»¸ê®Æ¡v¨Ì¥ú½uªº¤ÏÀ³«¬ºA(F1:H5)¡A¦³70%·|°k¨«¡A¦ý¦³30%¤£°Ê¡C
¦P²z
¤w¶]¥XÁ­½¸¥N¸¹¬O 5(¦b¡u°ò¥»¸ê®Æ¡v¤¤ D6 ª¾¹D¥¦ªº¥ú½u¤ÏÀ³«¬ºA¬O4)¡A¦b¡u°ò¥»¸ê®Æ¡v¨Ì¥ú½uªº¤ÏÀ³«¬ºA(F1:H5)¡A¦³20%·|°k¨«¡A¦ý¦³80%¤£°Ê¡C

TOP

c2=INDEX({1,2,3,4,5},MATCH(B2,{0,0.3,0.56,0.76,0.9},1))
³o­Ó¤£¿ù¡A§Ú·|¦A°µ¤@¨Ç­×¥¿¡A¥H¨¾¤î«á¤èªº ±Ú¸s¤ñ²v 0,0.3,0.56,0.76,0.9 ¦³©ÒÅÜ°Ê¡C

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD