Hi,

I think you misunderstood the question ...

Q is supposed to be a constant - meaning if i set Q as 6, i a
generating all combinations of values of Q1, Q2, Q3 that satisfy 6 = Q
+ Q2 + Q3.

Many thanks for your effort! I really appreciate it! :)


Tom Ogilvy Wrote:
Sub AAA()
Dim i As Double, j As Double, k As Double
Dim l As Long
i = 1
j = 1.5
k = 2
l = 2
Do While Application.Round(i, 1) <= 2
Do While Application.Round(j, 1) <= 5
Do While Application.Round(k, 1) <= 4
Cells(l, 1) = i
Cells(l, 2) = j
Cells(l, 3) = k
Cells(l, 4) = i + j + k
Debug.Print l, i, j, k, i + j + k
k = k + 0.1
l = l + 1
Loop
k = 2
j = j + 0.1
Loop
j = 1.5
i = i + 0.1
Loop

End Sub

--
Regards,
Tom Ogilvy

"highjumper"
wrote
in messag
...

Hi all,

i have a problem that goes like this;

Q = Q1 + Q2 + Q3, where Q is constant

Q1 is between 1 and 2. Q2 is between 1.5 and 5. Q3 is between 2 an
4.
All values at Intervals of 0.1 (ie. Q1 = 1, 1.1, 1.2, ... 2)

i need to generate all combinations of values of Q1, Q2 and Q3 such
that the above relationship is satisfied.

Are that any kind souls that can help me with this?
Thanks in advance !!!
:)


--
highjumper

------------------------------------------------------------------------
highjumper's Profile:
http://www.excelforum.com/member.php...o&userid=26516
View this thread
http://www.excelforum.com/showthread...hreadid=397849


--
highjumpe
-----------------------------------------------------------------------
highjumper's Profile: http://www.excelforum.com/member.php...fo&userid=2651
View this thread: http://www.excelforum.com/showthread.php?threadid=39784