it will return V for any value in b4 <= 500 - you need to invert it to
get what you want

=IF(B4<=500,"V",IF(B4<=400,"W",IF(B4<=300,"X",IF(B
4<=200,"Y",IF(B4<=100,"Z","")))))

=IF(B4<=100,"Z",IF(B4<=200,"Y",IF(B4<=300,"X",IF(B 4<=400,"W",IF(B4<=500,"V","")))))

will return for B$

Z <=100
Y 100<B4<=200
X 200<B4<=300
W 300<B4<=400
V 400<B4<=500
"" anything else


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=492068