Hello,
here I have commission at 20% for total sales in column F.
and a bonus commission for every 10 sales accumulated in column G. (at 10% of total dollar value earned in column E).
how do I make column G automatically do this calculation based on changing values in column B and D. (total sales x product value).
(For every 10 sales, they get 10% of adjusted value in E).
for example product value $5000, x 10 sales = $50,000, bonus commission is $5,000 (10%).
if 20 sales, thats 100K revenue, bonus commission is $10,000
if 30 sales, thats 150K, bonus commission is $15,000
bonus commission2.JPG
Bookmarks