29th October 2008, 08:38 AM
|
Member
|
|
Join Date: Oct 2005
Posts: 1,007
|
|
Hi ,
Figured it out myself I had to write a little thingy others might like it
Qx = number of selections in top row
Qy = number of selections in second row
TempQcost = 0
QCost = 0
For QCalc = 1 To Qx
TempQcost = 1 * Qy - 1
QCost = QCost + TempQcost
Qy = Qy - 1
Next QCalc
That is it, once the calculation comes out of the loop the Quinella (QCost) is calculated correctly I think.
I also feel quite smart again
Michal
|