Excel formula with multiple criteria

[kypok999]

Hi Guys I need formula based on below picture If AR2=1, BT>3 and if ar2=2,ap2<3 and bt2<3 then BET otherwise no bet it multiple criteria I am strugling to put in one formula…Thank you

https://imgur.com/a/LZFp7

 

[Marcílio_Lobão]

kypok999, Good morning.

Try to use:

=IF(OR( AND(AR2=1, BT2>3), AND(AR2=2, BT2<3, AP2<3)), "BET", "--NO BET--")

Please, is that what you want?

I hope it helps.

 

[kypok999]

Thank you for your reply what i forgot to say it has be based on variable in column A as per picture:

https://imgur.com/a/HU4JJ

So culomn A represents a race and in that race i need to find those variations..

I guess it might be something like index match

Thank you

 

[Marcílio_Lobão]

kypok999, Good afternoon.

Using pictures is always harder for us to help you.

Ideally you save your spreadsheet on a free website, www.sendspace.com or another and put the download link here.

Give a concrete example of what the desired response should look like for some lines.

When you mention that column A has the race name, does it mean that for each race the criterion is different?

Will you create different criteria for each?

I will wait for your answer.

Have a nice day.

 

[kypok999]

Thank you in advance Marcílio I uploaded the file so basically formula should look into column a first example it would look into A2:A12 because its one race with 11 horses it should into if AR2:AR11=1 and BT2:BT11<3 and it should the same time look if in the same race Power 2 AR2:AR11= 2 AP2:AP11<3 and BT2:BT11<3 then bet on A8 which is POWER 2 AR8=2 so it means if horse which is ranked by power 1 AR2=1 but Draw rank is more then 3 and 2nd Power ranked horse in column AR2 =2 and spend and draw ranks are less then 3 then it should bet on Power 2 horse it should look into unique value in A:AA if that makes sence

https://www.sendspace.com/file/1isig1