Question

write an excel formula in cell models!h3 to determine the base price for the classic european home. this formula should also work when you copy it down to determine the base price for the new american home, cse favorite, etc. recall that the base price for each model depends on the number of levels and total square footage of the home. ($/sf for all combinations of stories) square footage can be found in the base worksheet.

Answer 1

To determine the base price for different home models in Excel, you can use a formula that depends on the number of levels and square footage. The formula should work for all models, and you can find the necessary data in the BASE worksheet.

Step-by-step explanation:

To determine the base price for the different models of homes in Excel, you can use a formula in cell MODELS!H3. The formula should work when copied down to determine the base price for the other models as well.

The base price for each model depends on the number of levels and total square footage of the home, which can be found in the BASE worksheet. You can use the $/sf for all combinations of stories. Here is an example of the formula you can use: =INDEX(Base!$B$2:$D$5, MATCH(MODELS!$A3, Base!$A$2:$A$5, 0), MATCH(MODELS!G$2, Base!$B$1:$D$1, 0))