The second spreadsheet assignment is a little bit more complicated because you need to create formulas and functions that will determine the commissions for you automatically. There are a few more details that you need to be aware of.

The formulas for the commission can be complex because they need to take several things into consideration. The following are some hints that will help you determine the commission formulas.

1. First set up the formula that will determine the commission based on the Amount charged for commission. You can set up this part of the formula using IF or LOOKUP functions.
2. Next, you need to modify the formula to check if the over-riding minimum requirement has been met (if there is one). You can set up this part of the formula using the MAX function.
3. Finally, you need to modify the formula to check if any thing has been bought. If something has been bought/sold, then the formula should determine the commission; if nothing has been bought/sold, then no commission should be paid.

If you have any problems with the formulas, go to the help section to figure out how to use some of the functions. You need to work on your own first and you should seek help from books, friends, colleagues, etc. If you continue to have problems, come talk to me.

Make sure you turn in a hard copy and a disk containing the spreadsheet file.