I am trying to calculate a commission % based on a gross profit % range. So
I have 8 rows of % ranges with 3 columns, column 1 is greater than and column
2 is less than, the third column has the commission %. Can someone tell me
how to have a formula look at the table and tell me which % should be used
for the calculation?