Compute tax percentage using nested if

Assignment Help Programming Languages

Reference no: EM1367963

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%.

Reference no: EM1367963

Questions Cloud

Positive interpretation of cynical behavior : Here is a rather positive interpretation of cynical behavior. I always view cynicism as negative until I read this. Do you think that this quote rings true about us, our colleagues, our staff?

What is total cost of saving water : What is total cost of saving water. Illustrate what is marginal cost saving 1 meter cubic of water.

Economics and related issues : Determine the trade volume necessary for PBI to reach a target return of $7,500 per month for a typical office. Determine and interpret the elasticity of cost with respect to output at the trade volume found in part A.

Determine proper cash balance : Dumaine Equipment Corporation closes its books regularly on December 31, but at the end of 2007 it held its cash book open so that a favorable balance sheet could be created for credit purposes.

Compute tax percentage using nested if : On Home Sales Data worksheet, in column E, compute Tax Percentage. Using nested IF calculate the following (Hint: do not use the function AND because if the house does not have 1 bedroom

Impact of downsizing on the organization : Write down the impact of a lay-off on the survivors? Write down the impact of downsizing on the organization?

How many more units of this product will free market produce : Assume that a industry produces 200000 units a year and sells m all for $10 each. Furthermore, assume that marginal external damage of this product is $6 per unit. How many more units of this product will free market produce than is socially.

Elucidate its possible that we have sustainable development : Elucidate how it is possible that we have "sustainable development" (as it is defined in text book) in a world in which minerals, oil and or non-renewable resources are being depleted.

Determining optimal combination of labor-capital : Crew Brew produces a popular brand of beer in its mini-brewery located on a small river in Kentucky. Assume that capital can be purchased for $8 per unit, and labor costs $6 per unit. What is the optimal combination of inputs for the firm to employ..

User Account

All Pages