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

##### New Member
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. ### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### Oscar Cronquist

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

##### New Member
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

##### Board Regular

Formula in cell C1:

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

##### New Member

Formula in cell c1:

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

thank you!!!!!!!

Replies
10
Views
109
Replies
3
Views
49
Replies
1
Views
75
Replies
7
Views
48
Replies
22
Views
249