比如说A1中的数值是12, 让其随机分配到B1:F1 也就是说B1:F1相加的和等于A1,
允许B1:F1中有0
B1=RAND()*A1
C1=IF(RAND()*(A1-B1)>0,RAND()*(A1-B1),0)
D1=IF(RAND()*(A1-B1-C1)>0,RAND()*(A1-B1-C1),0)
E1=IF(RAND()*(A1-B1-C1-D1)>0,RAND()*(A1-B1-C1-D1),0)
F1=A1-B1-C1-D1-E1
C1=IF(RAND()*(A1-B1)>0,RAND()*(A1-B1),0)
D1=IF(RAND()*(A1-B1-C1)>0,RAND()*(A1-B1-C1),0)
E1=IF(RAND()*(A1-B1-C1-D1)>0,RAND()*(A1-B1-C1-D1),0)
F1=A1-B1-C1-D1-E1
温馨提示:答案为网友推荐,仅供参考