View Single Post
  #9  
Old 21st April 2007, 08:47 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

"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
Reply With Quote