At the first blush, it may seem that online editors are roughly the same, but you’ll discover that it’s not that way at all. Having a powerful document management solution like DocHub, you can do far more than with regular tools. What makes our editor exclusive is its ability not only to rapidly Insert table in Bonus Program but also to create paperwork completely from scratch, just the way you want it!
Despite its comprehensive editing capabilities, DocHub has a very easy-to-use interface that offers all the functions you need at hand. Thus, adjusting a Bonus Program or a completely new document will take only a couple of moments.
Register for a free trial and enjoy your best-ever document-related experience with DocHub!
welcome to this video which is a continuation of exercise 1 sales analysis this time we want to calculate the bonus that will be awarded to each salesperson based on their performance for the month of July 2 to 2 December 2018 so you can see the rules for giving out the bonus down here if the salesperson earn 50,000 or more the bonus is 3,200 if the salesperson earned between 35,000 and 50,000 then he gets 1600 and if the salesperson earned between 20,000 and 35,000 he gets 800 and if his revenue is below 20,000 he doesnt get a bonus so lets do it step by step here were going to use a function called if I F and if is a function that can be used if you have two or more possible results in a formula which we have right here because we have actually four possible results okay so lets get started here for the bonus for Avery equal if okay and the open parenthesis so the bonus depends on the value in h4 so if h4 now first lets check if he earned above 50,000 so if h4 creator then we ha