Time is a crucial resource that each organization treasures and attempts to change in a reward. When choosing document management application, pay attention to a clutterless and user-friendly interface that empowers users. DocHub offers cutting-edge instruments to enhance your file administration and transforms your PDF editing into a matter of one click. Replace Formulas in the Incentive Plan with DocHub to save a lot of time as well as improve your productivity.
Make PDF editing an easy and intuitive operation that saves you plenty of precious time. Effortlessly adjust your files and send them for signing without the need of switching to third-party options. Concentrate on relevant tasks and improve your file administration with DocHub right now.
welcome back to new video tutorial in microsoft excel and in this video we are going to learn how to calculate the sales incentive of sales person based on target and achievement and here i have given some target and achievement values of different sales persons and here in this cells i need to calculate the incentive owned by the sales person based on the achievement of given targets and there is two criteria for providing incentive the first one is upon achieving hundred percent of target the sales person is eligible for rupees 2500 and if the salesperson achieves 105 percentage of given target then erc will be applicable for 3500 monthly incentive so based on these two criteria here in this table i need to calculate the incentive owned by these sales persons and here i am also calculating the grand total incentive on which will be calculated by simply using some formula here the major formula we are going to use here is the month wise incentive on and to calculate incentive amount w