Hi

You could set up a table and use a VLOOKUP function. Post your breakdowns
and we'll have a go!!

Andy.

"Anh" wrote in message
...
I have a sheet listing comission rate eg. sales less than $200, the rate is
.5%, less than 300, the rate is 1%..etc. Then i have another table showing
different sales value of different workers. How do i find the commission
rate
per worker using lookup functions??
Please help me..thx a lot