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