Nested If formula with two AND conditions

[adrienne0914]

I always have trouble with nested IF AND formulas. Trying to figure out how to combine the two formulas below based on whether a number falls between these two sets of numbers:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]11[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]23[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

=IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3","") and =IF(AND(N$3>=$A$2,N$3<=$B$2),"last 3","")

 

[jtakw]

Hi,

Just Nest the 2nd IF in the 1st:

=IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3",IF(AND(N$3>=$A$2,N$3<=$B$2),"last 3",""))

 

[adrienne0914]

Hi,

Just Nest the 2nd IF in the 1st:

=IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3",IF(AND(N$3>=$A$2,N$3<=$B$2),"last 3",""))

That returns a result of PY last 3 to all cells >= A1. I need for it to be blank if the number isn't between either range.

 

[jtakw]

Well, it works for me, are you certain you have Numeric values in N3, A1, B1, A2, B2 ??

Book1
	A	B	C	N	O	P	Q	R	S
1	11	13
2	23	25
3				23	11	15	22	27	24
4				last 3	PY last 3				last 3
Sheet593

Cell Formulas
Range	Formula
N4	=IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3",IF(AND(N$3>=$A$2,N$3<=$B$2),"last 3",""))

 

[adrienne0914]

Well, it works for me, are you certain you have Numeric values in N3, A1, B1, A2, B2 ??

[TABLE="width: 85%"]
<tbody></tbody>[/TABLE]

It works now. The cells in my document were actually different from those above. I didn't change all of the cell references properly. Thanks, jtakw!

 

[jtakw]

You're welcome.