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

adam1993

New Member
Joined
May 16, 2018
Messages
16
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. :confused:
 

Some videos you may like

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
Joined
Apr 20, 2018
Messages
200
Formula in cell C1:
=IF(((A1="Over 200")*(B1>=197)*(B1<=204))+((A1="Under 225)*(B1>=220)*(B1<=230)),"Yes","No")
 

Oscar Cronquist

Board Regular
Joined
Apr 20, 2018
Messages
200
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")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,315
Messages
5,527,957
Members
409,794
Latest member
ajithppajith

This Week's Hot Topics

Top