¥H¶Ã¼Æ²£¥Í¼ÒÀÀ¥Î¸ê®Æ¡Xµ¹¤©¯S©wªº±¡¹Ò«¬ºA¡A§Y¥i¦Û°Ê²£¥Í¼ÒÀÀ¸ê®Æ¡C
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
¥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ªºÁ½¸¡An¥Î¶Ã¼Æ 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)
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
«Ø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
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
ì¨Ò¤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 |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
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 |
|
|
|
|
|
|