Newbie attempting permutations calculator!

[gripperrocks]

Hi guys, I'm looking to create a calulator that works out returns from a permed accumulator bet. Trouble is I only really know the basic of basics about excel.

Essentially what I'm after is a table where each bet has one or more different options, and the calculator will be able to tell me my returns, as long as one option from each bet has come in.

EG:

Bet 1: option1 option2
Bet 2: option1 option2
Bet 3: option1 option2
Bet 4: option1 option2
Bet 5: option1 option2

so in this example, either option1 or option2 would have to win on each line for the bet to be successful.

the permutations are 2x2x2x2x2 = 32 lines of bets in total.

I would like to be able to input odds for each selection, and stake per line. I would like to be able to see the retuns of each line, so if all won there would be 32 amounts of returns to combine and total together to create a total returns cell, which is what I'm after really.

Hope I haven't lost everybody with my waffling!

Thank in advice for your help guys, I came across this site looking for advice on google and it looks really interesting.

 

[gripperrocks]

I forgot to mention I would also need the option of saying if option 1/2 had won/lost as that would change the amount of winning lines and therefore the total returns.

Thanks again.

 

[baitmaster]

welcome to the board

I'd like to help but your question doesnt really contain enough info from an Excel sense, and I dont know what equations you need for this tool

I assume you need somewhere to enter the result against each line. You can use =IF(...) to return a true or false answer if a match is found. You could also use =countif([your list of options],[result])>0 to return true/false if a value is found anywhere in a list

true/false can then be used in subsequent formulas to sum your results however you want

I suggest you think about how you want this tool to look, and the equations you want at each point, then ask for help on how to write each individual equation - Im not yet sure what equations you are asking to be written, hence my vagueness

hope this helps

 

[gripperrocks]

Hi Baitmaster, I see what you mean. Apologies for being so vague but I'm sort of teaching myself as I go along!

I'll try to explain what I have done so far.

I have a column running down next to my options (Column I) with a counta formula to show how many bets I have per line. So in cell I2 i have the counta formula showing me I have chosen two options, therefore two bets per that first line.

I have repeated this down the column for each "line" up to the tenth line.

I now want to create a cell that shows me the total amount of lines (I.e: 2x2x2, etc).

Trouble is I have created ten lines, and if I only wanted to use, say, five of those lines, I would get a zero figure as the counta value for lines 6-10 would be zero.

So at this stage essentially what I am after is a cell that will multiply all the numbers, except zero, to get my true "total lines"value.

Hope this isn't too confusing.