LinkBack URL
About LinkBacks
I am trying to calculate the commission % to pay to a sales team based on a increasing % the more they achieve.
% of Target Bonus as % of Salary
50% - 0%
100% - 15%
200% - 100%
300% - 200%
I am trying to calculate the commission % to pay to a sales team based on a increasing % the more they achieve.
% of Target Bonus as % of Salary
50% - 0%
100% - 15%
200% - 100%
300% - 200%
Hi and welcome to the forum.
Check out the VLOOKUP function.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks