Multiple choices from columns

[Davebro]

I have odds in column A and prediction in column H
I have minimum odds in J L N which relate to whether column H is a H, D or A.
So if A2 is predicted to be a 'D' (H2) then A2 odds would have to be over 2.1 (L2)
If H2 is a 'H' then odds should be over 1.9(J2) and if H2 is 'H' odds should be be over 2(N2).
Looking for a formula I can copy down.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

Home

Draw

Away

Home Minimum Odds

Draw Minimum Odds

Away Minimum Odds

6.1​

Bet

Brechin

4.8​

Queens Park

1.65​

D

1.9​

H

2.1​

H

2​

H

2.64​

No Bet

Hull

3.65​

Barnsley

1.82​

H

4.6​

A

4.1​

A

4.3​

A

1.92​

No Bet

Fulham

3.85​

Swansea

4.5​

H

3​

D

3.5​

D

7​

D

2.28​

Bet

Reading

3.4​

Wigan

3.6​

D

1.76​

No Bet

Sheffield Weds

3.75​

Charlton

5.8​

A

 

[mrshl9898]

=IF(AND(H2="D",L2>2.1),"FULFILLS CRITERIA",IF(AND(H2="H",J2>1.9,N2>2),"FULFILLS CRITERIA","DOESN'T FULFILL CRITERIA"))

 

[Davebro]

=IF(AND(H2="D",L2>2.1),"FULFILLS CRITERIA",IF(AND(H2="H",J2>1.9,N2>2),"FULFILLS CRITERIA","DOESN'T FULFILL CRITERIA"))

Hi, many thanks for your reply, I think I am nearly there but the formula does not take into consideration the odds is A2 to compare against.J L N.

 

[mrshl9898]

Ok, this is all a little unclear.

Where is this formula meant to go?

 

[mrshl9898]

And how does A effect it?

 

[Davebro]

And how does A effect it?

When I run the formula row 2 comes back as DOESN'T FULFILL CRITERIA, which it does as A2 (6.1) is more than L2 (2.1).
When the home team odds form the forecast (H) are more than or less than the minimum odds for Draw odds (L),


my start off was =IF(AND(H2="D",A2>L2),"Bet","No BET")

 

[mrshl9898]

I think I understand, thanks.

If this is correct:

"If H2 is a 'H' then odds should be over 1.9(J2) and if H2 is 'H' odds should be be over 2(N2)."

Then:

=IF(AND(H2="D",A2>L2),"FULFILLS CRITERIA",IF(AND(H2="H",A2>J2,A2>N2),"FULFILLS CRITERIA","DOESN'T FULFILL CRITERIA"))


Though if "H2 is 'H' odds should be be over 2(N2)." was meant to be "H2 is 'A'" then:

=IF(AND(H2="D",A2>L2),"FULFILLS CRITERIA",IF(AND(H2="H",A2>J2),"FULFILLS CRITERIA",IF(AND(H2="A",A2>N2),"FULFILLS CRITERIA","DOESN'T FULFILL")))

 

[Davebro]

I think I understand, thanks.

If this is correct:

"If H2 is a 'H' then odds should be over 1.9(J2) and if H2 is 'H' odds should be be over 2(N2)."

Then:

=IF(AND(H2="D",A2>L2),"FULFILLS CRITERIA",IF(AND(H2="H",A2>J2,A2>N2),"FULFILLS CRITERIA","DOESN'T FULFILL CRITERIA"))


Though if "H2 is 'H' odds should be be over 2(N2)." was meant to be "H2 is 'A'" then:

=IF(AND(H2="D",A2>L2),"FULFILLS CRITERIA",IF(AND(H2="H",A2>J2),"FULFILLS CRITERIA",IF(AND(H2="A",A2>N2),"FULFILLS CRITERIA","DOESN'T FULFILL")))

That seems to have done it, many thanks for your patience.

 

[Davebro]

I think I understand, thanks.

If this is correct:

"If H2 is a 'H' then odds should be over 1.9(J2) and if H2 is 'H' odds should be be over 2(N2)."

Then:

=IF(AND(H2="D",A2>L2),"FULFILLS CRITERIA",IF(AND(H2="H",A2>J2,A2>N2),"FULFILLS CRITERIA","DOESN'T FULFILL CRITERIA"))


Though if "H2 is 'H' odds should be be over 2(N2)." was meant to be "H2 is 'A'" then:

=IF(AND(H2="D",A2>L2),"FULFILLS CRITERIA",IF(AND(H2="H",A2>J2),"FULFILLS CRITERIA",IF(AND(H2="A",A2>N2),"FULFILLS CRITERIA","DOESN'T FULFILL")))

Hi again, just finished the sheet with all odds highlighted, had to F4 the cells that needed minimum odds so the formula would carry down.
The idea is not to bet at under value odds, the minimum odds change daily as results are added on another sheet.
Next project is to rank them in order of value, but that's for another day.
Thanks again for your help in this.

Home

Draw

Away

Home Minimum Odds

Draw Minimum Odds

Away Minimum Odds

6​

Bet

Brechin

4.8​

Bet

Queens Park

1.65​

No Bet

D

1.9​

H

2.1​

H

2​

H

2.64​

Bet

Hull

3.65​

Bet

Barnsley

1.82​

No Bet

H

4.6​

A

4.1​

A

4.3​

A

1.92​

Bet

Fulham

3.85​

Bet

Swansea

4.5​

No Bet

H

3​

D

3.5​

D

7​

D

2.28​

Bet

Reading

3.4​

No Bet

Wigan

3.6​

No Bet

D

1.76​

No Bet

Sheffield Weds

3.75​

No Bet

Charlton

5.8​

Bet

A