Formula for calculating horse placement

[oddjob2001]

What i have been trying for hours and failing at is excel's daft logic when it comes to using 2 cells and a > combined with a < function.

What i am trying to do is, (written in plain terms)

IF F1600 is more than equal 5 BUT less than equal 7 AND M1600 is more than 0 BUT less than equal 2 return "true" else return "false"

i also wish to combine that with two other statements all together in the same formula so in plain terms the logic would be.

IF F1600 is more than equal 5 BUT less than equal 7
AND M1600 is more than 0 BUT less than equal 2 give result true
AND IF F1600 is more than equal 8 BUT less than equal 15
AND M1600 is more than 0 BUT less than equal 3 give result true
AND IF F1600 is more than equal 16
AND M1600 is more than 0 BUT less than equal 4 give result true
ELSE anything else give result false


Complex and I am not even sure excel can do this, any help would be greatly appreciated.

 

[mikerickson]

I recall from philosophy class that, logically, AND and BUT are the same. I'm interpeting some of your ands to as OR.

=OR(AND(5<=F1600,F1600<=7,0 < M1600,M1600 < 2),AND(8<=F1600,F1600<=15,0< M1600,M1600<=3),AND(16<=F1600,0 < M1600,M1600<=4))

 

[T. Valko]

What i have been trying for hours and failing at is excel's daft logic when it comes to using 2 cells and a > combined with a < function.

What i am trying to do is, (written in plain terms)

IF F1600 is more than equal 5 BUT less than equal 7 AND M1600 is more than 0 BUT less than equal 2 return "true" else return "false"

i also wish to combine that with two other statements all together in the same formula so in plain terms the logic would be.

IF F1600 is more than equal 5 BUT less than equal 7
AND M1600 is more than 0 BUT less than equal 2 give result true
AND IF F1600 is more than equal 8 BUT less than equal 15
AND M1600 is more than 0 BUT less than equal 3 give result true
AND IF F1600 is more than equal 16
AND M1600 is more than 0 BUT less than equal 4 give result true
ELSE anything else give result false


Complex and I am not even sure excel can do this, any help would be greatly appreciated.

Try this...

=OR(AND(F1600>=5,F1600<=7,M1600>0,M1600<=2),AND(F1600>=8,F1600<=15,M1600>0,M1600<=3),AND(F1600>=16,M1600>0,M1600<=4))

 

[oddjob2001]

For some unknown reason those two didn't work, but using them as examples i ended up using this

=IF(AND(F295>1,F295<=4,N295=1),1,IF(AND(F295>=5,F295<=7,N295>=1,N295<=2),1,IF(AND(F295>=8,F295<=15,N295>=1,N295<=3),1,IF(AND(F295>=16,N295>=1,N295<=4),1,0))))


yes I know it's huge! but it does the job.

Thanks for the help

 

[T. Valko]

For some unknown reason those two didn't work, but using them as examples i ended up using this

=IF(AND(F295>1,F295<=4,N295=1),1,IF(AND(F295>=5,F295<=7,N295>=1,N295<=2),1,IF(AND(F295>=8,F295<=15,N295>=1,N295<=3),1,IF(AND(F295>=16,N295>=1,N295<=4),1,0))))


yes I know it's huge! but it does the job.

Thanks for the help

Good deal. Thanks for letting us know!