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.
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.