Question: 4 . Write an Excel formula in cell Customers!I 5 to be copied down to determine the Base price for the specific model home the
Write an Excel formula in cell Customers!I to be copied down to determine the Base price for the specific model home the first customer has purchased. When copied down, the formula will determine the total value of each home for the corresponding customer. Do not use an IF function for this formula.
Write an Excel formula in cell Customers!J to determine the location surcharge not total cost if applicable, for the home purchased by the first customer. Remember that the surcharge percentage is applied to the home price including options. Write the formula so that it can be copied down the column to determine the surcharge for each corresponding customer. Do not use an IF function for this formula.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
