Formula help please

[Anthony]

Hi
Can anybody suggest a formula for the following?

Based on a game of roulette I have a worksheet that tracks my current game

Cell R6 holds chip value
Cell P21 holds number of chips placed on this bet
Cell P23 shows L or W (lose or Win)
I want cell P24 to contain a formula to shown nett result of spin

so..

If P23 is blank (as no spin as yet for this game) then P24 is blank
If P23 = L then P24 = loss calculated at chip value (R6) x P21 **must be
shown as loss**

eg spin results if a loss with 2 x $10 chips placed P24 = -$20

Now the tricky bit....

If P23 = W then P24 = chip value(R6) * 5 (winning odds at 5/1) less any
chips lost if more than 1 chip placed.

eg winning spin come out after me placing 3 chips each worth $5 (1 x winner
2x lost)
I would get back $25 less 2 losing chips = nett win of $15

If I only placed 2 chips each worth $5 1 win / 1 lost I would get back $25
less 1 losing chip = nett win this time of $20

Also.....

In the next cell along from P24 ie Q24 I want the same formula as needed
from above calculation but also to add the nett result from the previous cell
ie P24

I hope this all makes sense, and hope more a formula can be given

Thanks in advance

 

[Newbeetle]

Hi

This hopefully is what you was after for part 1 & 2 of your question

In P24 type

=IF(P23="","",IF(P23="l",-R6*P21,IF(P23="w",(R6*P1)-(P21-1)*P1)))

I've added P1 which looks at your odds.

For the last part of your question, what cells will Q24 be looking at?

Hope that helps!