Hi I'm very new learning excel have a test coming up next week, however can't remember how to calculate commissions paid if sales greater than $12,000 they receive 8% commission this, would appreciate anyones advice, thanks
Salespersons Total Comm Paid % of Total Comm
$11,764
$14,638
$14,914
$10,649
$13,455
$65,420
Commission
Over $12,000 8%
Under $12,000 6%
Bookmarks