Hello

I am a commercial sales agent and are in the process of designing an excel sheet to help out a few of my principles and agents.

What I am looking for is if a products sells for $100 and the commission is 10% then the commission earned is $10 nice and simple. but if the principle or the agent offers a discount of 5% i want to peable to prorata the commission earned to reflect the discount.

100 sell = full 10% commission
95 sell = 9.5% ?

how can this be done?

Kind Regards

Kiwi