C is the number of runners

R is the price

T is the finish position

Here is the formula

Code:

`=IF(OR(AND(C2<=3,R2<=20,T2>1),-80, AND(C2>=4,C2<=7,R2<=20,T2>2),-80, AND(C2>=8,R2<=20,T2>3),-80),78.4*S2-78.4,0)`

So what I am trying to achieve is the following:

IF C2<=3 & R2<=20 & T2=1 then perform the profit calculation. Otherwise the answer-80 (if R2 is >20 the answer should be 0)

or

IF C2>=4 & C2<=7 & R2<=20 & T2<=2 then perform the profit calculation. Otherwise the answer is -80 (if R2 is >20 the answer should be 0)

or

IF C2>=8 & R2<=20 & T2<=3 then perform the profit calculation. Otherwise the answer -80 (if R2 is >20 the answer should be 0)

So the R2<=20 seems to be the vital part, as if R2 >20, then the result will always be zero - no calculations necessary at all. If R2 is <=20, then the other criteria need to be used, with either a profit calculation or loss of -80 showing. Only 3 possibilities, 0, Profit or -80

There are obviously some flaws in this, but it is beyond me to figure it out.

Thanks in advance