Calculating Commisions based on profit

[Ed Rawley]

I need a formula to calculate a commision based off of a net profit. As an
example in cell C1 I have a profit of 27 to 30%, I need D1 to calculate that
as a 20% commision off of a dollar figure in B1. If the profit margin is
between 23 and 26% I need D1 to calculate that at a 17% commision and so on
down to 15 to 18%. I need to be able to do this in multiple rows, a value
in C2 has the profit margin of 27 to 30%, I need D2 to calculate for a 20%
Commision and so on. Any help would be appreciated

 

[duane]

try this, on a separate sheet named "commission" put the profit margin
in column a in ascending order (1%, 2%, etc). Let's assume thi
includes rows 1-100 (1 to 100%) In column b put the correspondin
commission.

back on your original sheet, cell d1

=vlookup(c1,commission!$a$1:$b$100,2)

copy this down column d as far as you need t