Formula to recalculate a break-even

malfecha

New Member
Joined
Sep 25, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
___AAA000.jpg

Hi,

I try to build a nice table related to a slot bonus hunt (gambling).
The principle is to get bonuses from slots but not to open them directly. Once I have some, I open all of them in a row.
In my table, I encode their names, the bets, and the amount I won from the bonus.
In another part, I want to show some stats : balance before the hunt, balance before opening the bonuses, total number of bonuses, break even at start of the opening, etc.
The break even at start means the average number of times I have to multiply the bet for all bonuses to get the initial balance back.
Now, I would like also to calculate the break even "live". In other words, after I encode the win of a bonus, I want to know the break even regarding the bonuses not played yet to get my balance back (and of course considering the amount already won).

I attach an image to show my table.

Is this clear enough ? Could someone help me with doing such a formula ? I'm not expert enough to do this :)

Many thanks in advance,
malfecha
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,215,523
Messages
6,125,318
Members
449,218
Latest member
Excel Master

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top