LinkBack URL
About LinkBacks
Hello,
Please refer attached file
I would like to get a formula to calculate commission based on a sliding scale table shown in the file.
Any help will be greatly appreciated.
Regards,
Dumbo
Hello,
Please refer attached file
I would like to get a formula to calculate commission based on a sliding scale table shown in the file.
Any help will be greatly appreciated.
Regards,
Dumbo
the way you have created the table for Achievement Slab and %, it will not be possible to perform lookups from that table.
here is a formula that contains the entire lookup table within it, place the formula in B4 and drag-fill it towards right.
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
hey Joseph, i changed your table below to input just the minimum values. then:
=(IF(B2<90%,0,LOOKUP(B2,$A$9:$A$16,$B$9:$B$16)+MAX(0,B1-105.99%)*2))*B3
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 a lot Benishriyo and Icestation....it worked well...thanks heaps...u ppl are amazing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks