# Crazily long and complex formula

#### WelshGareth

##### New Member
Hi Folks,

I'm playing with a spreadsheet with past horse racing results, trying to find a way of staking that I like. The problem comes with my stepped staking idea. The formula (as in cell AB7)works as it is but I'm sure it could be done a better way (with the cells referring to a table maybe so I can play around with thresholds and percentages?)

Any help appreciated.
WeaselHorsesGa.xls
UVWXYZAAABAC
1StakeIncrementBasicStakeper
20.0050.03510
3Stake
4Active
5maxbnkminbnkStartBankPerbetDailyPerno.SteppedProfit
6500.00500.00500.0010.0010.00110.0010.00-10.00
7500.00486.00486.0017.0110.00210.009.729.72
Selection Data

Gareth

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Hi,

Try:

=MIN(1000,ROUNDDOWN(W7*(Y2-X2*LOOKUP(W7,{0,200,350,750,1500,5000,30000},{5,4,3,2,1,0,4})),2))

Tac Fairwinds

That's a lot easier to see what's going on. I'll give it a whirl tomorrow. In the longer term, I'm going to try and get it to take the info from a table using a " a User defined function in Excel (similar to an Excel Macro) that takes your bank level as input & outputs the appropriate stake". This is a suggestion made to me by the author of the spreadsheet in its original form.

In the meantime though, that's going to make playing around with it a breeze.

Thanks

L8r, Gareth

Replies
0
Views
550
Replies
9
Views
171
Replies
9
Views
609
Replies
0
Views
133
Replies
7
Views
246

1,203,727
Messages
6,056,981
Members
444,900
Latest member
QuillPet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back