4402

Excel 數學 重要問題 送

請問(a b c d)=10a

b

c

d1.一共有幾種組合方式?2.是否可以用Excel 計算出來?3.請告訴我全部的組合數字 如 (1

2

3

4)

( 2

2

2

6)

(3

3

3

1)等等~~~~ 謝謝各位
總共286組用Excel的vba可以作出來以下是所有的組合(麻煩自己定位一下)ABCD10000910090109001820081108101802080118002730072107201712071117102703070217012700364006310630162206211620261306121611261036040603160226013600455005410540153205311530252305221521252035140513151225113510450505041503250235014500546004510450144204411440243304321431243034240423142224213420441504141413241234114410540604051404240334024401540063700361036013520351135023430342134123403334033313322331333043250324132323223321432053160315131423133312431153106307030613052304330343025301630072800271027012620261126022530252125122503244024312422241324042350234123322323231423052260225122422233222422152206217021612152214321342125211621072080207120622053204420352026201720081900181018011720171117021630162116121603154015311522151315041450144114321423141414051360135113421333132413151306127012611252124312341225121612071180117111621153114411351126111711081090108110721063105410451036102710181009010000910090108200811080207300721071207030640063106220613060405500541053205230514050504600451044204330424041504060370036103520343033403250316030702800271026202530244023502260217020801900181017201630154014501360127011801090010000910082007300640055004600370028001900010
a

b

c

d條件不足

會產生以下狀況:1.無限組合(因為可以為負數或是非整數)2.不行3.無限組合無法列出...PS:正數?正整數嗎?2005/08/15修正下面兩位答題者已經將問題回答了這種題目根本無須使用Excel來做公式排列用簡單的排列組合即可算出有286組
第一題可以排列組合解題

(1)abcd可以為0: 即為將10個相同的東西分給4個人　C(10 4-1

4-1)=C(13

3)=(13*12*11)/(3*2*1)=286(2)abcd為正數 : 即每人先分一個

再將6個相同的東西分給4個人　C(6 4-1

4-1)=C(9

3)=(9*8*7)/(3*2*1)=84
Sub number() Dim a

b

c

d

sum As Integer Range(