I have a number in B4 which will be 1 thru 100 (percentage)

I have columns set below and depending on the percentage need to pickup
that percentage. If B4 = 20% and F13 is the 15-20% column then F14
needs to contain the number in B5. Make sense?? How can I accomplish
this? F14 needs some kind of formula that say if B4 is greater than
15% but less than 20% then equal B5 else nothing. ??

Thanks


--
maximus73
------------------------------------------------------------------------
maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877
View this thread: http://www.excelforum.com/showthread...hreadid=499968