hello all, i have had help on this before but i have added something new and can't work out the formula
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>At the moment i have in the won/lost column =IF(E2="1st",F2,0)
What i want to put in that column is the win amount + place amount if they finish 1st, 2nd or 3rd
i hope someone can help, thanks
Win Price | Place Price | Win Outlay | Place Outlay | Finished | Win Amount | Place Amount | Won/Lost |
$4.70 | $1.90 | $50.00 | $50.00 | 1st | $235.00 | $95.00 | $235.00 |
$2.60 | $1.50 | $50.00 | $150.00 | 1st | $130.00 | $225.00 | $130.00 |
$2.20 | $1.30 | $50.00 | $150.00 | 1st | $110.00 | $195.00 | $110.00 |
$4.50 | $2.10 | $50.00 | $50.00 | 1st | $225.00 | $105.00 | $225.00 |
$2.60 | $1.25 | $50.00 | $150.00 | Unplaced | $130.00 | $187.50 | $0.00 |
$3.25 | $1.70 | $50.00 | $100.00 | 2nd | $162.50 | $170.00 | $0.00 |
$1.85 | $1.10 | $50.00 | $200.00 | 3rd | $92.50 | $220.00 | $0.00 |
$1.30 | $1.10 | $50.00 | $200.00 | 1st | $65.00 | $220.00 | $65.00 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
What i want to put in that column is the win amount + place amount if they finish 1st, 2nd or 3rd
i hope someone can help, thanks