=IF(D12=2000000,D12*0.0065,IF(D12=1250001,D12*0. 006,IF(D12=750001,D12*0.0055,IF(D12=500001,D12*0 .005,D12*0.0045))))

or should it be

=IF(D12=2000001,D12.......................
just curious why only the top range starts at 2000000

--
Greetings from New Zealand

"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