Page 322 - Excel Workbook for Dummies

33_798452 ch23.qxp 3/13/06 7:51 PM Page 305
Chapter 23: Using the Visual Basic Editor 305

17. Click cell C18 with the count of Jack’s sales to make it the ItemsSold argument for
the Commission function and then type a ) — close parenthesis — before clicking
the Enter button on the Formula bar.
18. Enter a formula in cell E19 that sums the sales commissions in cells E5, E10, and
E18.
Create a formula that uses the SUM function with these three cell references as
its number arguments.
19. Select cell A1 and then save your changes to the RV Sales worksheet in a file
named Solved23-5.xls in your Chapter 23 folder in the My Practice Spreadsheets
folder. Exit Excel, being sure to save your changes to the hidden PERSONAL.XLS
workbook file when prompted to do so during the closing of the program.