|
可否帮助求14X+21Y+26Z=488正整数解?用EXCEL解决,公式和规划求解都行,
TELEXON,QQ=859290525,十分感谢
适合二元或三元都行: - Sub ep()
- Dim i As Integer, j As Integer, k As Integer, Rnum As Integer
- Dim re()
- Dim Totalsum As Integer, X1 As Integer, X2 As Integer, X3 As Integer
- X1 = Sheets(1).Range("d2")
- X2 = Sheets(1).Range("e2")
- X3 = Sheets(1).Range("f2")
- Totalsum = Sheets(1).Range("g2")
- For i = 0 To Totalsum / X1
- For j = 0 To Totalsum / X2
- If X3 > 0 Then
- For k = 0 To Totalsum / X3
- If Totalsum = X1 * i + X2 * j + X3 * k Then
- m = m + 1
- ReDim Preserve re(1 To 3, 1 To m)
- re(1, m) = i
- re(2, m) = j
- re(3, m) = k
- End If
- Next k
- Else
- If Totalsum = X1 * i + X2 * j Then
- m = m + 1
- ReDim Preserve re(1 To 3, 1 To m)
- re(1, m) = i
- re(2, m) = j
- End If
- End If
- Next j
- Next i
- Sheets(1).[a1].Resize(UBound(re, 2), 3) = Application.Transpose(re)
- End Sub
复制代码
|
|