If one cell says "text" and one cell is # between range formula

[adam1993]

I am having trouble finding the right formula for cells.

In column A, I have the words either "Over 200" or "Under 225". In column B I have a range of numbers anywhere from 180 to 240. In column C is where I want the formula to work.

I am looking for a formula that goes like this..... If column A says Over 200 and column B is between 197 and 204 then column C says "Yes" but I also want it to include if column A says Under 225 and column B is between 220 and 230 then column C says "Yes", and if neither of these conditions are met, then it says "No".

Pleaseeeeee help me out.

 

[Oscar Cronquist]

Formula in cell C1:
=IF(((A1="Over 200")*(B1>=197)*(B1<=204))+((A1="Under 225)*(B1>=220)*(B1<=230)),"Yes","No")

 

[adam1993]

Formula in cell C1:
=IF(((A1="Over 200")*(B1>=197)*(B1<=204))+((A1="Under 225)*(B1>=220)*(B1<=230)),"Yes","No")

It keeps giving me the Error message :/

 

[Oscar Cronquist]

I made a mistake.

Formula in cell C1:
=IF(((A1="Over 200")*(B1>=197)*(B1<=204))+((A1="Under 225")*(B1>=220)*(B1<=230)),"Yes","No")

 

[adam1993]

i made a mistake.

Formula in cell c1:
=if(((a1="over 200")*(b1>=197)*(b1<=204))+((a1="under 225")*(b1>=220)*(b1<=230)),"yes","no")

thank you!!!!!!!