Thanks. this was a big help to a novice like me.
--
Rick


"Toppers" wrote:

Create a table as below say in Sheet2 A1 to B5 with Volumes & Commission rates:

A B
0 0.0045
500001 0.0050
750001 0.0055
1250001 0.0060
2000001 0.0065

With production volume in A1 of Sheet1

in "Commission" (assuming it is on Sheet1 also) cell put

=A1*VLOOKUP(A1,Sheet2!$A$1:$B$5,2,1)

Alternative options:

=A1*LOOKUP(A1,Sheet2!$A$1:$A$5,Sheet2!$B$1:$B$5)

or (but less flexible than using a table):

=A1*LOOKUP(A1,{0,500001,750001,1250001,2000001},{0 .0045,0.005,0.0055,0.006,0.0065})


HTH


"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