Help with IF / And / OR

[jas64]

I am not sure that I'm using the most efficient approach to what I'm trying to achieve. Input and advice is most welcome. I'm sure this is a simple formula, but I'm not having and success with it.

[TABLE="width: 515"]
<tbody>[TR]
[TD="class: xl69, width: 515"]IF(AND( A1 > 9, and < 20, and B1 = "PHONE"), (DO THIS)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 515"]
<tbody>[TR]
[TD="class: xl71, width: 515"] -OR-[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 515"]
<tbody>[TR]
[TD="class: xl71, width: 515"]IF(AND( A1 > 20, and B1 = "PHONE"), (DO THIS)[/TD]
[/TR]
</tbody>[/TABLE]

 

[Nine Zero]

try this out just replace the DO THIS with what you want

=IF(AND(A1>9,A1<20,B1="PHONE"),DO THIS,IF(AND(A1>20,B1="PHONE"),DO THIS,""))

 

[jproffer]

Is this on the right track? :

=IF(AND(A1>9,A1<20,B1="PHONE"),"DO THIS IF 9 to 20",IF(AND(A1>20,B1="PHONE"),"DO THIS IF over 20","BOTH CONDITIONS FALSE"))

BTW, you may want to decide which category you want if A1 is exactly 20. With this formula, as it is now, if A1 = 20, both cond would be false.

 

[jas64]

Thanks! That works. I swore that I tried that, but I'm thinking I misused a parentheses.

 

[jtakw]

Hi,

How about this slightly shorter version, assumes - DO THAT if > 9 and <= 20

Book1
	A	B	C
1	20	PHONE	DO THAT
Sheet66

Cell Formulas
Range	Formula
C1	=IF(B1="PHONE",IF(A1>20,"DO THIS",IF(A1>9,"DO THAT","A1 is less than 10")),"B1 is Not PHONE")