The company's research and Development department has finally developed a very good communication software, now to be handed over to the sales department for sale. In order to stimulate the enthusiasm of the sales staff, the company will set bonuses, of course, is not fixed, the so-called more pay, when the amount of sales over a certain value, the bonus is a grade, below this value, is another grade. So many people, how can we quickly calculate the bonuses that everyone deserves?
Solving ideas
We can use the relevant functions in Excel to calculate, when a certain condition, according to a certain number of calculations, not achieved by another calculation, which we immediately thought of the IF function, the following is an example demo.
① start Excel2013, rough produce the following form data, when the sales amount exceeds 10000, according to 12% calculation, no more than according to 10% calculation.
② in D2 cell input: =if (c2>10000,12%,10%), to determine the condition is c2>10000, if true, then return 12%, otherwise it is 10%. Of course the formula is not filled in completely, it's just interest rates.
③ Perfect the formula, add *c2 at the back, multiply the amount by the interest rate and get the employee's bonus.
④ Finally, the remaining data can be completed in a cell-filled way. Move the mouse to the lower right corner of the cell, the + number appears, left-click, pull down, fill, and then loosen.
Classification: