Hi!

See this:

http://mcgimpsey.com/excel/variablerate.html

Biff

"Jasonroelofs" wrote in message
...
I need help programing a data base to figuare out commisions. I need a data
base to multiply 0-250 by $.50 then from 251-500 by $.65 then from 501-750
by
$.75 then from 751-1000 by $.85 then from 1001-1500 by $1.00 then from
1501-2000 by $1.15 and then from 2001 + by $1.25. So if someone would
enter
2000 I need the data base to multiply the first 250 by $.50 then the next
250
by $.65 then the next 250 by $.75 and so on. Any suggestions will help.
Thanks
Jason