How Excel tutorials Quickly calculate sales bonuses with formulas

Today this section of the tutorial is to solve this problem, in our Excel in the use of formulas can be easily achieved, the following is a witness!

① 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.