excel - Excel将数字划分/划分为5个部分，范围在10到42之间[关闭](Excel Divide / Split a Number into 5 parts that range between 10 and 42 [closed])

Question

Closed) . 已关闭) 。) This question needs to be more focused . 这个问题需要更加集中 。) It is not currently accepting answers. 它当前不接受答案。)

---

Want to improve this question?)

(想改善这个问题吗？))

Update the question so it focuses on one problem only by editing this post .

(更新问题，使其仅通过编辑此帖子来关注一个问题。)

Closed 3 hours ago .

(3小时前关闭。)

What I am trying to do is I want to achieve a Specified value as sum of 5 individual numbers chosen randomly between 10 to 42. To be precise, suppose I have 165 in cell D2.

(我想做的是要获得一个指定值，该值是在10到42之间随机选择的5个独立数字的总和。准确地说，假设我在单元格D2中有165。)

Now I want to distribute split this number into 5 separate parts, each cell having random number between 10 to 42 so that when I add up the sum equals 165 or the value in cell D2.

(现在，我想将此数字分为5个独立部分，每个单元格的随机数在10到42之间，这样当我加起来等于165或单元格D2中的值时。)

  ask by SrB33 translate from so

Answer 1

等待大神答复