Hi all, I'm new to MrExcel
I'm trying to work out which input to use for this scenario.
In cell A2 i have 4 different win prices i can use
So what i want to be able to do is when i enter a price in A2 it will automatically put the outlay amount in cell B2 and in cell C2 when i enter 1st i want it to automatically enter the amount from cell D2 into E2 , obviously if the result in C2 is either 2nd,3rd or Unplaced it would automatically enter $0.00. I hope someone can help me with this, thanks.
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I'm trying to work out which input to use for this scenario.
In cell A2 i have 4 different win prices i can use
So what i want to be able to do is when i enter a price in A2 it will automatically put the outlay amount in cell B2 and in cell C2 when i enter 1st i want it to automatically enter the amount from cell D2 into E2 , obviously if the result in C2 is either 2nd,3rd or Unplaced it would automatically enter $0.00. I hope someone can help me with this, thanks.
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1
Win Price | Outlay | Finished | Win Amount | Won/Lost | Difference | Total Outlay | Profit/Loss | Prices Min | Prices Max | Bet | Position |
$1.55 | $250.00 | 1st | $387.50 | $387.50 | $137.50 | $250.00 | $137.50 | $1.00 | $2.00 | $250 | 1st |
$1.80 | $250.00 | 3rd | $450.00 | $0.00 | -$250.00 | $500.00 | -$112.50 | $2.01 | $3.00 | $200 | 2nd |
$2.70 | $200.00 | 1st | $540.00 | $540.00 | $340.00 | $700.00 | $227.50 | $3.01 | $4.00 | $150 | 3rd |
$7.00 | $100.00 | Unplaced | $700.00 | $0.00 | -$100.00 | $800.00 | $127.50 | $4.01 | $150.00 | $100 | Unplaced |
$3.40 | $150.00 | 1st | $510.00 | $510.00 | $360.00 | $950.00 | $487.50 | ||||
$0.00 | $0.00 | $950.00 | $487.50 | ||||||||
$0.00 | $0.00 | $950.00 | $487.50 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>