作者sdtty (低调低调)
看板Visual_Basic
标题[VBA ] 用VBA要怎麽写出所有可能的组合阿
时间Sat Jan 6 15:20:17 2007
限制式 a1+a2+a3+a4=1
a1={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11组可行解
a2={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11组可行解
a3={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11组可行解
a4={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11组可行解
要怎麽用vba写出所有可能的组合呢?
拜托各位高手了<(_ _)>
--
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.134.72.45
1F：→ PsMonkey:连题目都看不太懂 01/06 15:31
2F：推 slalala:这是资料结构的问题 建议用回圈 01/07 00:53
3F：推 edwar:X1+X2+X3+X4=10 非负整数解数目: H(4,10)=C(13,3)=286 01/07 11:58