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 absolute reference that computes the actual cost to be placed in cell C3 for any total cost amount found in cell A3. 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.