# Multiplying a cell by one number if another cell is one number or by another if it is another number

#### YoungSparky

##### New Member
What I am trying to do is build a bankroll management spreadsheet.

My base bet would be 4%
Increase the bet by 1.25% on a win
Decrease it by .25% on a loss

Cell A1 = 4 Cell B2 =1.25 Cell C3 = .25

Cell A4 = 10000
cell A5 = 500 B5:B500 = wins C5:C500 = losses
Cell A6 = A4+B5-C5 Giving the new bankroll number
Cell A6 = would be a formula that multiplies cell A6 by either B2 or C3 depending on if the last bet was a win or a loss.

Any suggestions? I am currently doing most of this by just entering the info myself but I'm trying to automate the process. I have a few other things I want to do as well but I have to figure this one out first as the other issues are similar.

Thanks

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
What do you have in B5 and C2
do you have the text Win and lose?

= A4 + B5 -c5

I would perhaps structure so that just one column has a win/loss - say Column B)
then you could use
In A6
=IF( B5="", "", IF( B5="Loss" , A5* (1-\$C\$3) , A5*(1+\$B\$2) ))

Thanks. This has gotten me a lot closer to where I want. One more little issue has come up. I want each new bet to increase or decrease depending on a previous win or loss.

ex. Bet 1 4% win, bet 2 5.5% win, bet 3 7% loss, bet 4 6.75% loss, bet 5 6.5% win, bet 6 8% etc....

How would I do this? Thanks in advance for any help.

you maybe able to have a table for Loss and Win showing the %

1 Win %
1 Loss %
2 Win %
2 Loss %
3 Win %
3 Loss %
etc
then you could the range for how many wins or loss
and then look up the % for a win or loss

can you provide more detail please
Win1 =4%
Win2 =5.5%
Win3 =6.5%
is this always increasing by 1.5% and is there an upper limit?

BUT you said increase by 1.25% and now it appears to be 1.5%

For loss
Loss1 = 4%
Loss2 = ?
Loss3 = 7% ????
loss4 = 6.75

so could we say 4% + Count how many wins so far and increase by
4% + Countif( range, "Win" ) * 1.25%
4% - countif(range, "loss" ) * 0.25%

perhaps that may work

Can you load the spreadsheet onto a share like, dropbox, onedrive please so we can see some examples
Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

Replies
4
Views
744
Replies
2
Views
474
Replies
3
Views
632
Replies
4
Views
651
Replies
3
Views
2K

1,203,674
Messages
6,056,681
Members
444,882
Latest member
cboyce44

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