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.