Breakeven Point

[mrcois]

I've got a scenario where I need to work out the BE point in excel formula.

If I spend $10 and need to recover the $10, taking the winning % of 80% in consideration, what would the formula / calculation look like?

$10 + $? (+80%) = $?

[CAntosh]

is $12.50 the number you're looking for in your example? I'm just trying to make sure that I understand you correctly. If $12.50 is the correct answer, then you can use:

=A1/B1

Where A1 is the amount spent ($10) and B1 is the recovery percentage (80%). If I'm misunderstanding you, please indicate what answer you're expecting.

[mrcois]

If I play a gambling game and win 80% with each bet, I would bet $10, and win $10 plus 80% of amount bet, the total winnings would be $18.

If I lose the $10, what should I bet to recover the 1st $10 bet plus the 2nd amount bet, also taking in consideration that with the 2nd bet I would make 80% on top of that?

[CAntosh]

To clarify: if you bet $10 and win, you receive the $10 you risked plus an additional $8 in winnings, correct (you walk away with $18)? When you say $18 in winnings, it sounds like you're getting $18 in addition to the $10 you risked, so you'd walk away with $28. If the first scenario is accurate, you can use the table I've attached to help track your progress and what you need to bet to return to the break even point. I built it for a gambler with a similar strategy a while back. Enter your bet in Column A and your Victory or Defeat in Column C and it'll track your progress and update you on what your current break even bet would be. I've entered a few values so you can see how it works.

If the second scenario I described is the accurate interpretation and you're walking away with $28 after a successful $10 bet, then change the 80% figure in column B to 180% and it should work as desired. Let me know if you have any issues.

[mrcois]

Thanks Cantosh, it is exactly what I needed.... I was WAY out on the calculations...

I would also to round the number of the last column's value to the next value? (Eg. 2.86 rounded to 3.00)?

[CAntosh]

Glad I could help! Assuming you want to round up to the nearest dollar, change the formula in F2 to:

=IF(C2<>"",IF(E2<0,ROUNDUP(-1*(E2)/B3,0),"You're up on the day"),"")

...and fill down. If you just want to round it to the nearest dollar (up OR down), use:

=IF(C2<>"",IF(E2<0,ROUND(-1*(E2)/B3,0),"You're up on the day"),"")

Good luck!