New a little help

M

maximus73

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
 
Top