[請問] EXCEL 如何列出所有對應數字? 已解決，謝謝大家已回收
假設EXCEL裡有個公式
其中有4個格子可以填上0~10任意數字，
但總和只能=10
譬如我輸入 會得到結果
10 0 0 0 61 12 8 7
9 1 0 0 60 12 8 7
8 2 0 0 59 12 8 7
↓
↓
↓
↓
0 0 2 8 53 12 8 9
0 0 1 9 53 12 8 9
0 0 0 10 53 12 8 9
我要怎麼把所有可能的結果快速列出來?
請各位大師教教我!謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 203.73.105.203
※ 文章網址: http://www.ptt.cc/bbs/ask/M.1412262614.A.599.html
※ 編輯: hao0705 (203.73.105.203), 10/02/2014 23:10:42
推
10/02 23:18, , 1F
10/02 23:18, 1F
推
10/02 23:19, , 2F
10/02 23:19, 2F
→
10/02 23:20, , 3F
10/02 23:20, 3F
→
10/02 23:20, , 4F
10/02 23:20, 4F
→
10/02 23:21, , 5F
10/02 23:21, 5F
→
10/02 23:21, , 6F
10/02 23:21, 6F
推
10/02 23:24, , 7F
10/02 23:24, 7F
→
10/02 23:24, , 8F
10/02 23:24, 8F
→
10/02 23:26, , 9F
10/02 23:26, 9F
→
10/02 23:27, , 10F
10/02 23:27, 10F
推
10/02 23:28, , 11F
10/02 23:28, 11F
→
10/02 23:28, , 12F
10/02 23:28, 12F
哈哈，抱歉，我也覺得很難敘述
就，我要在4個格子，自動產生0~10的數字，
但相加只能等於10
同時，把得到的結果自動記錄下來
※ 編輯: hao0705 (203.73.105.203), 10/02/2014 23:30:12
推
10/02 23:30, , 13F
10/02 23:30, 13F
→
10/02 23:30, , 14F
10/02 23:30, 14F
→
10/02 23:31, , 15F
10/02 23:31, 15F
推
10/02 23:40, , 16F
10/02 23:40, 16F
→
10/02 23:40, , 17F
10/02 23:40, 17F
→
10/02 23:43, , 18F
10/02 23:43, 18F
→
10/02 23:43, , 19F
10/02 23:43, 19F
推
10/02 23:54, , 20F
10/02 23:54, 20F
→
10/02 23:55, , 21F
10/02 23:55, 21F
→
10/02 23:56, , 22F
10/02 23:56, 22F
→
10/02 23:57, , 23F
10/02 23:57, 23F
→
10/02 23:58, , 24F
10/02 23:58, 24F
→
10/03 00:38, , 25F
10/03 00:38, 25F
→
10/03 00:47, , 26F
10/03 00:47, 26F
→
10/03 00:50, , 27F
10/03 00:50, 27F
※ 編輯: hao0705 (203.73.105.203), 10/03/2014 02:15:20
ask 近期熱門文章
6
14
7
28
PTT職涯區 即時熱門文章
276
698
