=if(commission<=0.37,profitmargin*grossprofit,0.37 *grossprofit)

Should work. Might take some extra steps if the gross profit and percentage
are not in their own columns and will depend on if you're calculating gross
margin or markup percentage.

Jesse Hamilton




"Lenny Johnson" wrote in message
...
Help, my company pays Commission to sales people based on
the percentage of gross profit per order, the commission
earned is therefor variable. Example, the commision paid
is the same as the percentage of gross profit with a max
of 37% commission, 25% profit= 25% of the profit as
commission, 42% profit= 37% of the profit as commission.
I need help with a formula that will put a cap on the
commission at 37%. I have my sales and commission report
on a spreadsheet now.
Please, can anyone help me with a formula.

Thank you Very Much,
Lenny Johnson