On the Home Sales Data worksheet, in column E, calculate the Tax Percentage. Using a nested IF calculate the following (Hint:

1.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.)a.1 Bedroom homes use 3%b.2 Bedroom homes use 4%c.For all homes with 3 OR MORE bedrooms:i. if the age of the home is less than 10 years old, use 5.25%ii.If the age of the home is less than 20 years old (but more than 9), use 5.5%iii.If the age of the home is 20 years old or more (or for all other homes), use 5.75%