
21st April 2007, 08:47 PM
|
Member
|
|
Join Date: Apr 2006
Posts: 368
|
|
"I am a bit of a novice but having a go."
your not the only one dingoboy
I have one which I'm having trouble with
See if I can explain it
D2 price layed @
E2 price backed @
F2 the amount $
G2 amount win / Loss
H2 place horse came
now what I want to do if the horse doesn't place 1st 2nd or 3rd G2 to show 0 if it did place then G2 to show profit/loss ( F2*E2-(D2*F2))
I came up with something like this =IF("H2">4,F2*E2-(D2*F2),"H2"<4) played around for a while but cant get
Thanks
|