=IF(AND(B2=11,B2<13),$I$2,if(b2=13,b2=20),$I$3,i f(b2=21,b2<30),$I$4,"")

I am trying to nest IF formula and I'm not writing the formula correctly. I
have like 6 different ranges I want it to look at.

Help! B.

It looks like you want to return the value in I2 if B2 is between 11 &12, I3
id 13 to 20, I4 if 21 to 30 and blank in all other cases.
Try this:
=IF(AND(B2=11,B2<13),$I$2,IF(AND(B2=13,B2<=20),$ I$3,IF(AND(B2=21,B2<30),$I$4,"")))

--
Ian
--
"BSantos" wrote in message
...
=IF(AND(B2=11,B2<13),$I$2,if(b2=13,b2=20),$I$3,i f(b2=21,b2<30),$I$4,"")

I am trying to nest IF formula and I'm not writing the formula correctly.
I
have like 6 different ranges I want it to look at.

Help! B.

look at the VLOOKUP function. It can work with ranges. List all the ranges
you want and I will show you how to use it.

Example (for the info given):

A B
1 0 =""
2 11 =I2
3 13 =I3
4 21 =I4
5 30 =""
6
7 =VLOOKUP(MAX(B7,0),A1:B5,2)

A7 will return these values:
"" for any value <11
I2 for any value =11 and <13
I3 for any value =13 and <21
I4 for any value =21 and <30
"" for any value =30.

I used B7 as the value of interest (instead of B2) in order to keep things
simple with the table placement. You can put the table anywhere, even on
another sheet.

"BSantos" wrote:

=IF(AND(B2=11,B2<13),$I$2,if(b2=13,b2=20),$I$3,i f(b2=21,b2<30),$I$4,"")

I am trying to nest IF formula and I'm not writing the formula correctly. I
have like 6 different ranges I want it to look at.

Help! B.