View Single Post
Old 02-11-2019, 12:37 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 530
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about

Into your table with data, add a column (may be hidden) , where depending on sales and GP % the bonus group number (values 1, 2, 3 or 4) for every row is calculated.
The bonus will be calculated as
=CHOOSE(BonusGroupNumber, Bonus1, Bonus2, Bonus3, Bonus4)
where Bonus# are numeric values for different bonuses like 0.01, 0.03, etc.
Reply With Quote