Question
PLEASE PROVIDE THE EXCEL FORMULA FOR THE BELOW (Bedrooms cell is I2 and the age is D2) On the Home Sales Data worksheet, in column
PLEASE PROVIDE THE EXCEL FORMULA FOR THE BELOW (Bedrooms cell is I2 and the age is D2)
On the Home Sales Data worksheet, in column E, calculate the Tax Percentage. Using a nested IF calculate the following (Hint: do not use the function AND because if the house does not have 1 bedroom and does not have 2 bedrooms then the house MUST have more than 3 bedrooms.)
1 Bedroom homes use 0.75%
2 Bedroom homes use 1%
For all homes with 3 or more bedrooms:
i. if the age of the home is less than 10 years old, use 1.25%
ii.If the age of the home is less than 20 years old (but more than 9), use 1.5%
iii.If the age of the home is 20 years old or more (or for all other homes), use 1.75%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started