Try

=G39*VLOOKUP(H39,{0,0.11;0.35,0.1;0.4,0.09},2,TRUE )

the values, like .11 range between 0 and .35, .1 between .35 and .4 etc.
Change to suit.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Doug" wrote in message
...
I pay sales commission that varies based on profit margin
I need a formula based on the margin:
When margin is .4, sales commission = .1
When margin is between .35 and ..39, sales commission = .09
ETC

What is the formula to determine?
I got this far:
=IF((H39=0.4),G39*0.1)