• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

calculation on slab value

webmax

Member
hi Team
I have a sales slab value from 0-5,6-10,11-20,20 & Above.
If the salesperson sells 25 nos of the product the same will be calculated according to the slab value as a bonus instead of the overall bonus percentage.
Attaching the excel sheet for your reference.
Kindly help
 

Attachments

  • bonuscalc.xlsx
    10 KB · Views: 5
Back
Top