IF AND OR Not correct

[honkin]

I have a formula to try and make a calculation of profit or loss, but cannot seem to get it to function correctly

C is the number of runners
R is the price
T is the finish position

Here is the formula

=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

 

[honkin]

Just as a follow up, here is the same code as above without the price check in R2. Well, it is slightly different, as I moved the -80 around to try and accommodate the price check, but couldn't get it to work.This code works flawlessly, but just does not have the price check

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

I just need this whole formula to also check that if R2 >=20, then the answer is always 0

Any help gladly accepted

 

[Peter_SSs]

Like this?

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

 

[honkin]

Like this?

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

Ah you're a legend mate. Yep, that seems to handle it perfectly. Now I need to learn from that in case I ever have something similar. I can see the structure of this, so it helps

cheers

 

[Peter_SSs]

You're welcome. Glad it helped.