Hi guys

i have to choose commission rate against the values, if upto 4.99 then it wilb be 0.03, if in 5- 99.9, then the commission will be charged 0.05 and so on. i have successfully computed the values for 1 and 3rd slab ,Howver for the second i get a N/A value. Need help. have stated the formula used below

Commission Slab
Commission Roll over
Upto 4.99 0.03 0.01
5.00-99.99 0.05 0.01
100- above 0.10 0.02 


=IF(C11<=4.99,B$4,IF(AND(C11>=5,B$5),IF(C11>=100,B$6)))
Regards
Aisha