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:

	A	B
1	11	13
2	23	25

<tbody>
</tbody>

=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 ??

<tbody></tbody>

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.