Hi,
I'm trying to create a formula that will calculate the appropriate commission depending on sales % falling within a certain range. See attached, I'm looking to put the formula into column C based on the compensation model in columns F and G.
Any suggestions? Thanks!
hi RWLAUS,
i had to add a column for my formula to read & adjusted the your range abit because it overlapped. like if sales performance is 80%, should it be commission of $250 or $500? so i made it $500 only if it reaches more than 80.00%. u can hide the Column F
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks so much, that works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks