Excel中,在三个单元格中随机三个数,让这三个数满足和等于100,有没有办法做到

2025-04-09 06:32:49
推荐回答(2个)
回答1:

a1=round(rand()*100,0)
a2=round(rand()*(100-a1),0)
a3=100-a1-a2

回答2:

a1 =RAND()*100

b1 =(100-A1)*RAND()

c1 =100-B1-A1