This assignment is basically the same as assignment 3 with one exception.

Suppose a certain store gives any customer a 10% discount for any sales totalling over $200.

Therefore the actual cost charged to the customer is given by the total cost if the total cost is less than $200, but is given by (1-0.1) times the total cost if the total cost is more than or equal to $200.

Create a macro using relative reference that computes the actual cost for any total cost amount found in an cell. The actual cost should be placed two cell to the right of the cell where a total cost was entered.

Test it for a total cost of $210. Do you get the correct result for the actual cost?

Test again for total costs of $198 and $200. Are the results correct?

Go to the VBE and copy the macro that you have just created. Submit an electronic copy of that file for this assignment.