Page 758 - Excel 2013 All-in-One For Dummies

740 Creating Custom Excel Functions
Figure 2-9:
Specifying the Total- Sales and ItemsSold arguments in the RV Sales spreadsheet.
When you click OK in the Function Arguments dialog box, Excel calculates Fred’s commission by using the 4.5 percent commission rate because his two sales made in April are well below the five sales necessary to bump him up to the 5 percent commission rate used by the custom Commission function. Figure 2-10 shows the completed April sales table after calculating the monthly commissions for Fred, Holly, and Jack. In using the custom Commission function, both Fred and Holly fall into the 4.5 percent commission rate. Only Jack, the April RV sales king, gets paid the higher 5 percent commission rate for his six sales during this month.
Figure 2-10:
Completed spread- sheet for all salespeople computed with the Commissions function.