å¨B1è¾å
¥å
¬å¼ï¼
=RANDBETWEEN(1,$A$1/14) ï¼ä¸æB1å°B14ï¼
è§å¾ä¸
ç±äºA1为350ï¼B1:B14æ¯ä¸ªåå
æ ¼é½éå¶å¨25ï¼ä¹å°±æ¯350/14çå¼ï¼æ以æ¯åå
æ ¼é½æ¯25çè¯ï¼æ»åä¹ä¸ä¼è¶
è¿350ã
说æï¼B1ï¼B14åå
æ ¼çå¼å°ä¼éæºååï¼å½æä¸F9é®ï¼å°±ä¼å·æ°æ°æ®ï¼å¨è¡¨æ ¼å
¶ä»é¨ä½è¾å
¥æ°æ®åä¹ä¼ååï¼å¦éè¦åºå®ï¼å¯å¤å¶B1:B14,éæ©æ§ç²è´´ä¸ºï¼å¼
追é®æéè¦æ3784éæºåé
å¨è¿ä¸åä¸æä¹å¼