# How to adjust staking plan to check date

#### honkin

##### Board Regular
Hi

I have a sheet which handles some calculations for staking, profit & loss and bank size, but I'd like it to be able to do a couple of additional things.

Here is the code I currently have

Code:
``=IF(E2="","",IF(E2<3.5,K1*0.01,IF(E2<7.45,K1*0.006,IF(E2<11.1,K1*0.004,"0"))))``

What is does is to look at column E to see what the odds are. It then calculates the stake based on various % of the current bank, column K.

Everything works really well with the sheet but I would like to be able to alter the above code so it checks an additional column. Here is what I would like it to be able to do.

So instead of altering the stake for each bet based on both the odds and current bank, I'd like it to only check what the current bank is daily, so bet size remains constant until the next day. People in different timezones will use the sheet to keep track of selections, so if I have it coded to check based on let's say <00:00 (midnight), that really won't work, as matches are listed in GMT, so what is midnight for someone in the UK is not midnight in other parts of the world. What I thought to do was to add was a helper column where either a 0 or 1 is input; 0 being for today and 1 being for tomorrow, so if a match is after midnight in your timezone, you input 1, otherwise 0.

The additional helper column will be column D, which will move the other columns above along one to the right as well, making the existing code now:-

Code:
``=IF(F2="","",IF(F2<3.5,L1*0.01,IF(G2<7.45,L1*0.006,IF(G2<11.1,L1*0.004,"0"))))``

Here is the additional idea in English

Total Bank is now column L

IF D = 0, the match is today and we want to use the last total bank entry (K) from yesterday for the calculation
IF D = 1, the match is tomorrow and we want to use the last bank entry (K) from today for the calculation

Date is column B

Any thought on how this would be added to the above code?

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

Replies
11
Views
231
Replies
3
Views
173
Replies
6
Views
227
Replies
1
Views
271
Replies
26
Views
511

### Forum statistics

1,126,928
Messages
5,621,639
Members
415,849
Latest member
PhoenixRising2015

### 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