Thank you. This was a big help.
--
Rick


"BoniM" wrote:

=IF(A302000000,A30*0.0065,IF(A30=1250001,A30*0.0 06,IF(A30=750001,A30*0.0055,IF(A30=500001,A30*0. 005,IF(A30=0, A30*0.0045,"")))))

computed for total in A30, adjust as necessary.

"Rick" wrote:

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