show zero value

[michael coughlin]

[TABLE="width: 606"]
<colgroup><col width="101" span="6" style="width:76pt"> </colgroup><tbody>[TR]
[TD="class: xl73, width: 303, colspan: 3"]POINTS[/TD]
[TD="class: xl68, width: 101"]BAGS[/TD]
[TD="class: xl69, width: 101"]WIN[/TD]
[TD="class: xl70, width: 101"]WE[/TD]
[/TR]
[TR]
[TD="class: xl65"]WE[/TD]
[TD="class: xl65"]THEY[/TD]
[TD="class: xl65"]TOTAL[/TD]
[TD="class: xl68"]WE[/TD]
[TD="class: xl69"]LOSS[/TD]
[TD="class: xl70"]TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]392[/TD]
[TD="class: xl66, align: right"]568[/TD]
[TD="class: xl67, align: right"]($17.60)[/TD]
[TD="class: xl67, align: right"]($4.00)[/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($63.20)[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]551[/TD]
[TD="class: xl66, align: right"]427[/TD]
[TD="class: xl67, align: right"]$12.40 [/TD]
[TD="class: xl67, align: right"]($4.00)[/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$36.80 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]576[/TD]
[TD="class: xl66, align: right"]378[/TD]
[TD="class: xl67, align: right"]$19.80 [/TD]
[TD="class: xl67, align: right"]$12.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$83.60 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]516[/TD]
[TD="class: xl66, align: right"]423[/TD]
[TD="class: xl67, align: right"]$9.30 [/TD]
[TD="class: xl67, align: right"]$17.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$72.60 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]533[/TD]
[TD="class: xl66, align: right"]385[/TD]
[TD="class: xl67, align: right"]$14.80 [/TD]
[TD="class: xl67, align: right"]$2.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$53.60 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]576[/TD]
[TD="class: xl66, align: right"]366[/TD]
[TD="class: xl67, align: right"]$21.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$82.00 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]440[/TD]
[TD="class: xl66, align: right"]592[/TD]
[TD="class: xl67, align: right"]($15.20)[/TD]
[TD="class: xl67, align: right"]$2.00 [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($46.40)[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]565[/TD]
[TD="class: xl66, align: right"]426[/TD]
[TD="class: xl67, align: right"]$13.90 [/TD]
[TD="class: xl67, align: right"]($9.00)[/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$29.80 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]616[/TD]
[TD="class: xl66, align: right"]305[/TD]
[TD="class: xl67, align: right"]$31.10 [/TD]
[TD="class: xl67, align: right"]$9.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$100.20 [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]509[/TD]
[TD="class: xl66, align: right"]499[/TD]
[TD="class: xl67, align: right"]$1.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$10.00 [/TD]
[TD="class: xl67, align: right"]$42.00 [/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67, align: right"]$0.00 [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67, align: right"]($10.00)[/TD]
[TD="class: xl67, align: right"]($20.00)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl71"]TOTAL[/TD]
[TD="class: xl72"]$251.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

[/TD]
[/TR]
[TR]
[TD]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[/TD]
[TD]

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

If I have understood correctly, this may be it. In column F
=IF(COUNT(B13:C13)=2,IF(B13>C13,10,-10),0)

Column G formula can stay as you already have it.

 

[michael coughlin]

If I have understood correctly, this may be it. In column F
=IF(COUNT(B13:C13)=2,IF(B13>C13,10,-10),0)

Column G formula can stay as you already have it.

thank you worked great

 

[Peter_SSs]

thank you worked great

You're welcome. Thanks for the confirmation.