One way to cover it ..

Try instead in J2: =IF(H2="L",-G2,IF(H2="W",G2*E2/F2,""))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Dustywm" wrote in message
...


"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