Question: 0 Write an Excel formula in cell CustomerleS to be copied down to determine the total price of the home that the rst person will

 0 Write an Excel formula in cell CustomerleS to be copied

0 Write an Excel formula in cell CustomerleS to be copied down to determine the total price of the home that the rst person will purchase. Write the formula so that it can be copied down the column to determine the total home price for each corresponding customer. This should include options total, the base price and location charges. 0 In order to increase the number of customers who are purchasing the various options (Jacuzzi, basement walkout, larger plot, bay window in dining room), you have decided to offer an options package special for a limited time Customers who purchase all of the options listed will get the highest priced option for free. Currently the larger plot is the most expensive option at $11,000 but keep in mind that prices are always subject to change. Write an Excel formula for cell Customersll5, which can be copied down the column, to calculate the new total price of each home, taking into consideration any discounts for the options package, if applicable

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Law Questions!