【問題】請教一下Excel:亂數加總後等於指定數字 ; 5, =RANDBETWEEN(1,$A$10), =ROUND(A5*$A$10/SUM($A$1:$A$9),0) ; 6, =RANDBETWEEN(1,$A$10), =ROUND(A6 ...
確定! 回上一頁