I have a commision form that return the amount of commission my sales guys
are suppose to get base on percentage of sales value. a represents the high
of the range while b represents the low end of range. c represent the
percentage for that range and d represents the presentage this saleguy got
for this sales. How do I get e to show the value of 9 which is the
percentage for this sale. Thanks for all you help


a b c d e
100.00% 99.991% 10 98.72
99.99% 97.50% 9
97.49% 95.00% 8
94.99% 92.50% 7
92.49% 90.00% 6
89.99% 87.50% 5
87.49% 85.00% 4
84.49% 82.50% 3
82.99% 0.00% 2

--
We all need a little help