"Dustywm" wrote:

How do I set a Excel formula for Win/Lose calculation please ie in a racing
betting record, entering W or L in a colunm.
Im usuing Excel 2002

Sorry didnt make my self clear.
formula requried :-
D2 = Horse. E2/F2 Oddds ie 2/1. G2=Stake. H2="W" or"L" I2=Profit/Loss.
J2=Balance.
=Sum(G2*E2)/F2 gives Profit loss when H2 is "W"

How do i expand this formula to result in minus G2 in J2 when H2 is "L" loss
Your help appreciated Thanks