Help with Excel and VBA Programming

[QueHuong]

I have an assigment I'm stuck on. I'm sure it's deceptively simple, but I'm confused on step 7:

You enjoy shopping. To help you determine the final prices of items that you are interested in buying, you want to create a custom function that will tell you the final price of an item after sales tax, if the original price of the item and the sales tax rate are provided. The formula that you would use is:

FinalPrice = OriginalPrice + (OriginalPrice * SalesTaxRate)

To complete this task:

1. Start Excel, open a new, blank workbook, and then save it with the filename Prices-7.
2. Enter the column headings ?Item Name,? ?Original Price,? ?Sales Tax Rate,? and ?Final Price.?
3. Make up data for the Item Name, Original Price and Sales Tax Rate columns for approximately 10 different items.
4. Open the Visual Basic Editor, insert a new module, and add a comment with your name and the current date.
5. Enter a function statement that creates a new function named FinalPrice that uses two arguments: OriginalPrice and SalesTaxRate.
6. Use the formula provided above, which assigns the value of the calculation to the FinalPrice custom function.
7. In the worksheet, enter the formula using the FinalPrice custom function into the appropriate cells so that the results are displayed in the Final Price column.

EIther I'm misunderstanding the question, or I don't know how to call a function in the worksheet. In the FinalPrice column, I entered the following function call into the cell "=FinalPrice()" after doing steps 1-6 and it doesn't work. Can anyone shed any light on this? Thanks.

 

[TSDible]

If you set up the function as required, it should be

=FinalPrice(B2,C2)

Where B2 is the column with the original price, and C2 is the column with the sales tax.

I have it working here. If you need more help, let me know.