michael coughlin
New Member
- Joined
- Dec 11, 2014
- Messages
- 20
POINTS | BAGS | WIN | WE | ||
WE | THEY | TOTAL | WE | LOSS | TOTAL |
392 | 568 | ($17.60) | ($4.00) | ($10.00) | ($63.20) |
551 | 427 | $12.40 | ($4.00) | $10.00 | $36.80 |
576 | 378 | $19.80 | $12.00 | $10.00 | $83.60 |
516 | 423 | $9.30 | $17.00 | $10.00 | $72.60 |
533 | 385 | $14.80 | $2.00 | $10.00 | $53.60 |
576 | 366 | $21.00 | $10.00 | $10.00 | $82.00 |
440 | 592 | ($15.20) | $2.00 | ($10.00) | ($46.40) |
565 | 426 | $13.90 | ($9.00) | $10.00 | $29.80 |
616 | 305 | $31.10 | $9.00 | $10.00 | $100.20 |
509 | 499 | $1.00 | $10.00 | $10.00 | $42.00 |
$0.00 | ($10.00) | ($20.00) | |||
$0.00 | ($10.00) | ($20.00) | |||
$0.00 | ($10.00) | ($20.00) | |||
$0.00 | ($10.00) | ($20.00) | |||
$0.00 | ($10.00) | ($20.00) | |||
$0.00 | ($10.00) | ($20.00) | |||
$0.00 | ($10.00) | ($20.00) | |||
TOTAL | $251.00 | ||||
in the columns with no values in b or c show zero value in columns f and g. the formula I am using in column f is =IF(B13>C13,10,-10) formula for column g is =SUM(D13:F13)*2 |
<colgroup><col width="101" span="6" style="width:76pt"> </colgroup><tbody>
</tbody>