When you work with diverse document types like Bonus Plan, you are aware how important accuracy and focus on detail are. This document type has its specific format, so it is crucial to save it with the formatting intact. For that reason, dealing with such paperwork might be a struggle for conventional text editing applications: one wrong action might ruin the format and take extra time to bring it back to normal.
If you wish to work in formula in Bonus Plan with no confusion, DocHub is a perfect tool for such tasks. Our online editing platform simplifies the process for any action you may want to do with Bonus Plan. The streamlined interface is suitable for any user, no matter if that individual is used to dealing with such software or has only opened it the very first time. Gain access to all modifying instruments you need easily and save time on everyday editing activities. You just need a DocHub profile.
See how easy document editing can be irrespective of the document type on your hands. Gain access to all top-notch modifying features and enjoy streamlining your work on documents. Sign up your free account now and see instant improvements in your editing experience.
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 doesn't get a bonus so let's do it step by step here we're 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 let's 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 let's check if he earned above 50,000 so if h4 creator then we h...