Another idea
=LOOKUP(F14/10000,{0,50,75,125,200},{0.0045,0.005,0.0055,0.006 ,0.0065})*f14

--
Don Guillett
SalesAid Software

"Rick" wrote in message
...
I have a spreadsheet set up that calculates my total production volume and
is
entered in a cell for Totals. I want to take that total number and
calculate
commissions using the following formula:
if volume 0-500000, multiply by .0045
if 500001-750000, multiply by .0050
if 750001-1250000, multiply by .0055
if 1250001-2000000, multiply by .0060
if 2000000 and above, multiply by .0065

and return the answer to the cell labeled "Commission"
--
Rick