Spreadsheet formula help

[Jonny2621]

Im trialling some sports bets with variable staking

Column A = True odds, i.e. Betfair -1
Column B = Stake Required
Column C = Rolling bank

No odds on bets
Odds 1.0 -4.0 1%
Odds 4.1 - 6.9 0.6%
Odds 7.0 - 10.5 0.3%

Can you have a formula that from the odds entered the stake is worked out ? Or is it not possible to work within bands this way ?

I bow to the excel experts of the forum :)

cheers

[mathare]

Enter the following into B1 (in fact in all of B)

=IF(A1<1,0,IF(A1<=4,0.01*C1,IF(A1<7,0.006*C1,IF(A1<=10.5,0.003*C1,0))))

[Jonny2621]

How did I know Mat would come to my rescue ? :D

cheers Mate

[Jonny2621]

What freaks me out is that taking it bit by bit, i actually think i understand it too :ooo

[mathare]

What freaks me out is that taking it bit by bit, i actually think i understand it too :oooThat's because none of this is that hard :)

All you have there is nested IF,THEN,ELSE statements. Powerful but simple

[Jonny2621]

That's because none of this is that hard :)

Well, I wouldn't go that far !

[mathare]

Well, I wouldn't go that far !:laugh Good job you have an expert around when you need one then. Just keep shining the beacon and I'll do what I can to help :)

[Win2Win]

How did I know Mat would come to my rescue ? :D

cheers Mate
Beacuse the rest of us can't be :butthead: answering and know he'll do it :laugh