想每天生成总和为100的5个随机数,同时这5个随机数要在5-40这个范围内,如
5、13、19、24、39 ;
12、25、33、8、22
非常感谢
ç¨RAND()å½æ°/RANDBETWEEN()å½æ°åç®åå ¬å¼æ¥çæè¿5个éæºæ°å³å¯ãå ·ä½åæ³ï¼
ä¸ãçæçéæºæ°å«å°æ°
1. å¨åå æ ¼ä¸è¾å ¥=RAND()ï¼å车ååå æ ¼å³å¯è¿åä¸ä¸ªéæºæ°åï¼å ¶èå´å¤§äº0å°äº1ãè¿æ¯çæç»å®èå´å çéæºæ°åçåºç¡ã
2. çæå¶å®èå´çéæºæ°çå ¬å¼æ¯ï¼=A+RAND()*(B-A)ï¼å ¶ä¸A为ç»å®æ°åæå°èå´ï¼Bæ¯ç»å®çæ大èå´ãè¦çæ大äº5å°äº40çéæºæ°åï¼å 为(40-5)*RAND()è¿åç»ææ¯0å°35ä¹é´ï¼å ä¸èå´çä¸é5å°±è¿åäº5å°40ä¹é´çæ°åã
3. ç¨ä¸æ°å ¬å¼çæå2个æ°ï¼ç¬¬3个æ°çä¸éåè¦è®¡ç®åç¡®å®ï¼å³ä¸º40ä¸ï¼100âéæºæ°1-éæºæ°2ï¼ä¸çå°è ã第4个æ°çä¸éåæ ·è¦è®¡ç®åç¡®å®ï¼å³ä¸º40ä¸ï¼100âéæºæ°1-éæºæ°2-éæºæ°3ï¼ä¸çå°è ã第5个æ°çäº100ä¸å ¶ä½å个éæºæ°çå·®ã
äºãçæéæºæ´æ°ï¼ç¨RANDBETWEEN()å½æ°ï¼è¯¥å½æ°çæ大äºçäº1å°äºçäº100çéæºæ´æ°ãè¯æ³ï¼=RANDBETWEEN(èå´ä¸éæ´æ°ï¼èå´ä¸éæ´æ°)ï¼ç»æè¿åå å«ä¸ä¸éå¨å çæ´æ°ã第1ã2个éæºæ°ç´æ¥çæï¼å ¶ä½éæºæ°ççæä¸éå¦ä¸ä¹3ã
A1=randbetweenï¼5ï¼40ï¼
B1=randbetweenï¼5ï¼40ï¼
C1=randbetweenï¼5ï¼min(40,(100-sum(a1:b1ï¼ï¼ï¼ï¼
D1=randbetweenï¼5ï¼min(40,(100-sum(a1:c1ï¼ï¼ï¼ï¼
E1=100-sum(a1:d1ï¼
å
¶å®å®æ´çç®æ³ä¸è¿è¦èèåä¸ä¸ªæ°çåå°äºçäº20ï¼å两个æ°å¿
é¡»å为40ææä¸ä¸ªè¦å¤§äº40ï¼ãåå个æ°å°äº60è第5个æ°è¦å¤§äº40çé®é¢ãä¸¥æ ¼çåæ³æ¯è¦å å
¥ifå¤æåæ¡ä»¶è°æ´ã太å¤æäºï¼