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
[TABLE="width: 838"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Win Price[/TD]
[TD]Outlay[/TD]
[TD]Finished[/TD]
[TD]Win Amount[/TD]
[TD]Won/Lost[/TD]
[TD]Difference[/TD]
[TD]Total Outlay[/TD]
[TD]Profit/Loss[/TD]
[TD] Prices Min [/TD]
[TD] Prices Max [/TD]
[TD]Bet[/TD]
[TD]Position[/TD]
[/TR]
[TR]
[TD]$1.55[/TD]
[TD]$250.00[/TD]
[TD]1st[/TD]
[TD]$387.50[/TD]
[TD]$387.50[/TD]
[TD="align: right"]$137.50[/TD]
[TD="align: right"]$250.00[/TD]
[TD]$137.50[/TD]
[TD]$1.00[/TD]
[TD]$2.00[/TD]
[TD]$250[/TD]
[TD]1st[/TD]
[/TR]
[TR]
[TD]$1.80[/TD]
[TD]$250.00[/TD]
[TD]3rd[/TD]
[TD]$450.00[/TD]
[TD]$0.00[/TD]
[TD="align: right"]-$250.00[/TD]
[TD="align: right"]$500.00[/TD]
[TD]-$112.50[/TD]
[TD]$2.01[/TD]
[TD]$3.00[/TD]
[TD]$200[/TD]
[TD]2nd[/TD]
[/TR]
[TR]
[TD]$2.70[/TD]
[TD]$200.00[/TD]
[TD]1st[/TD]
[TD]$540.00[/TD]
[TD]$540.00[/TD]
[TD="align: right"]$340.00[/TD]
[TD="align: right"]$700.00[/TD]
[TD]$227.50[/TD]
[TD]$3.01[/TD]
[TD]$4.00[/TD]
[TD]$150[/TD]
[TD]3rd[/TD]
[/TR]
[TR]
[TD]$7.00[/TD]
[TD]$100.00[/TD]
[TD]Unplaced[/TD]
[TD]$700.00[/TD]
[TD]$0.00[/TD]
[TD="align: right"]-$100.00[/TD]
[TD="align: right"]$800.00[/TD]
[TD]$127.50[/TD]
[TD]$4.01[/TD]
[TD]$150.00[/TD]
[TD]$100[/TD]
[TD]Unplaced[/TD]
[/TR]
[TR]
[TD]$3.40[/TD]
[TD]$150.00[/TD]
[TD]1st[/TD]
[TD]$510.00[/TD]
[TD]$510.00[/TD]
[TD="align: right"]$360.00[/TD]
[TD="align: right"]$950.00[/TD]
[TD]$487.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$950.00[/TD]
[TD]$487.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$950.00[/TD]
[TD]$487.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 838"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Win Price[/TD]
[TD]Outlay[/TD]
[TD]Finished[/TD]
[TD]Win Amount[/TD]
[TD]Won/Lost[/TD]
[TD]Difference[/TD]
[TD]Total Outlay[/TD]
[TD]Profit/Loss[/TD]
[TD] Prices Min [/TD]
[TD] Prices Max [/TD]
[TD]Bet[/TD]
[TD]Position[/TD]
[/TR]
[TR]
[TD]$1.55[/TD]
[TD]$250.00[/TD]
[TD]1st[/TD]
[TD]$387.50[/TD]
[TD]$387.50[/TD]
[TD="align: right"]$137.50[/TD]
[TD="align: right"]$250.00[/TD]
[TD]$137.50[/TD]
[TD]$1.00[/TD]
[TD]$2.00[/TD]
[TD]$250[/TD]
[TD]1st[/TD]
[/TR]
[TR]
[TD]$1.80[/TD]
[TD]$250.00[/TD]
[TD]3rd[/TD]
[TD]$450.00[/TD]
[TD]$0.00[/TD]
[TD="align: right"]-$250.00[/TD]
[TD="align: right"]$500.00[/TD]
[TD]-$112.50[/TD]
[TD]$2.01[/TD]
[TD]$3.00[/TD]
[TD]$200[/TD]
[TD]2nd[/TD]
[/TR]
[TR]
[TD]$2.70[/TD]
[TD]$200.00[/TD]
[TD]1st[/TD]
[TD]$540.00[/TD]
[TD]$540.00[/TD]
[TD="align: right"]$340.00[/TD]
[TD="align: right"]$700.00[/TD]
[TD]$227.50[/TD]
[TD]$3.01[/TD]
[TD]$4.00[/TD]
[TD]$150[/TD]
[TD]3rd[/TD]
[/TR]
[TR]
[TD]$7.00[/TD]
[TD]$100.00[/TD]
[TD]Unplaced[/TD]
[TD]$700.00[/TD]
[TD]$0.00[/TD]
[TD="align: right"]-$100.00[/TD]
[TD="align: right"]$800.00[/TD]
[TD]$127.50[/TD]
[TD]$4.01[/TD]
[TD]$150.00[/TD]
[TD]$100[/TD]
[TD]Unplaced[/TD]
[/TR]
[TR]
[TD]$3.40[/TD]
[TD]$150.00[/TD]
[TD]1st[/TD]
[TD]$510.00[/TD]
[TD]$510.00[/TD]
[TD="align: right"]$360.00[/TD]
[TD="align: right"]$950.00[/TD]
[TD]$487.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$950.00[/TD]
[TD]$487.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$950.00[/TD]
[TD]$487.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]