|
发表于 2016-3-7 10:40
|
显示全部楼层
本楼为最佳答案
暴搜。- Sub tt()
- Dim A1%, A2%, A3%, A4%, A5%, A6%
- Dim brr()
- A1 = 1: A2 = 15: A3 = 30
- A4 = 10: A5 = 12: A6 = 30
- s = 1 * A1 + 2 * A2 + 3 * A3 + 5 * A4 + 10 * A5 + 20 * A6
- ReDim arr(s)
- For x1 = 0 To A1: For x2 = 0 To A2: For x3 = 0 To A3: For x4 = 0 To A4: For x5 = 0 To A5: For x6 = 0 To A6
- s = 1 * x1 + 2 * x2 + 3 * x3 + 5 * x4 + 10 * x5 + 20 * x6
- arr(s) = 1
- Next: Next: Next: Next: Next: Next
- For i = 1 To IIf(s > 1000, 1000, s)
- If arr(i) = 1 Then
- m = m + 1
- ReDim Preserve brr(1 To m)
- brr(m) = i
- End If
- Next
- Range("A1") = "总共有" & m & "种质量可被称出"
- Range("A2") = Join(brr, ",")
- End Sub
复制代码 |
评分
-
查看全部评分
|